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?
A)=(B4-$B$3)^2+(C4-$C$3)^2
B)=SQRT((B4-$B$3)+(C4-$C$3))
C)=SQRT((B4-$B$3)^2+(C4-$C$3)^2)
D)=(B4-$B$3)+(C4-$C$3)

Question

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? 
A)=(B4-$B$3)^2+(C4-$C$3)^2 
B)=SQRT((B4-$B$3)+(C4-$C$3)) 
C)=SQRT((B4-$B$3)^2+(C4-$C$3)^2) 
D)=(B4-$B$3)+(C4-$C$3)

Quizplus · Accepted Answer

The formula for calculating the distance between two points in two-dimensional space is the distance formula, which is given by D = √((x2 – x1)^2 + (y2 – y1)^2). The formula in choice C uses this distance formula to calculate the distance between the warehouse location (cell B3 and C3) and each store location (given in cells B4:C7) and returns the sum of those distances. This formula can be used to determine the location of the warehouse where the total distance traveled by delivery trucks is minimized.

A Company Wants to Locate a New Warehouse to Minimize