A company wants to locate a new warehouse to minimize the distance traveled by its delivery trucks. It has four stores and their coordinates are listed in the accompanying spreadsheet. What formula goes in cell D4 of the spreadsheet?

= (B4-$B$3)^2+(C4-$C$3)^2

= SQRT((B4-$B$3) + (C4-$C$3))

= SQRT((B4-$B$3)^2 + (C4-$C$3)^2)

= (B4-$B$3) + (C4-$C$3)

Transcribed Image Text:

11 2 3 4 3 6 7 8 9 A Warehouse Store 1 Store 2 Store 3 Store 4 B X-Coordinate 163.800 100 90 210 180 Total Distance: С Y Coordinate 101 000 130 60 80 110 D Distance: 70.082 84.424 50.749 18.532 223.787 11 2 3 4 3 6 7 8 9 A Warehouse Store 1 Store 2 Store 3 Store 4 B X-Coordinate 163.800 100 90 210 180 Total Distance: С Y Coordinate 101 000 130 60 80 110 D Distance: 70.082 84.424 50.749 18.532 223.787

Answer rating: 100% (QA)

Correc... View the full answer