GEO 370 Numerical Methods in Geography Descriptive spatial statistics homework

1. Use Excel to convert the latitude and longitude measurements for the capital coordinates into decimal degrees. Your answer should be two columns, representing the latitude and the longitude. Write the Excel formulas you used below, paying attention to cell references. (3 pts.)

2 of 3

2. Compute the mean center of the provincial capitals, and then plot the mean center on the map. HINT: It will help you to write the geographic coordinates next to each provincial capital. (4 pts.) 3. Please express this mean center in DMS, rather than DD, coordinates. Be sure to show your work. (2 pts.) 4. The capital of Canada is Ottawa, Ontario. One might imagine that if a new capital were to be chosen for a nation as expansive as Canada, there might be a logical argument for siting the national capital at a location which would be the closest aggregate point to all of the 13 provincial capitals. On the map, please clearly estimate where you think this point might be with a . (2 pts.) 5. This hypothetical new capital would be which of the following? Place a checkmark in the correct box below, and then explain the reason. (2 pts.) Mean center Weighted mean Median center Center of gravity Euclidean median Weighted Euclidean median Manhattan median Explanation:

3 of 3

6. Measure the individual distances from the provincial capitals to Ottawa. What is the average capital distance to Ottawa, weighted by the capital population? Report your answer in kilometers. YOU MUST SHOW YOUR WORK, ON AND OFF THE MAP. (4 pts). 7. Explain how you would compute the standard distance to the provincial capitals. Discuss any complications or assumptions which your procedure might encounter, based on the available data, and how you would deal with them. (3 pts.)