Statistics Solutions

[Solution] Given here are the coordinates for each of the four towns to be serviced by the warehouse in Problem 15. Use the information from Problem 15

Question: Given here are the coordinates for each of the four towns to be serviced by the warehouse in Problem 15. Use the information from Problem 15 and the center of gravity method to determine coordinates for the warehouse.

Town Coordinates (X, Y)
A (4, 18)
B (12, 2)
C (10, 8)
D (8, 15)
  1. Calculate the coordinates for the new warehouse by hand using the center-of-gravity heuristic.
  2. Develop and use an excel spreadsheet to find the optimal center-of-gravity coordinates for the new warehouse and compare this location with the one you computed in part (a) above. Submit two printouts of your spreadsheet. The first printout should show your solution, and the second should display the formulas, gridlines, and the row and column headings. (use the CTRL ~) You should also show the Solver dialog settings on the second printout.

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in