Question: The distance between any two US cities ( excluding cities in Alaska and Hawaii ) can be approximated by the following formula: 6 9 *

The distance between any two US cities (excluding cities in Alaska and Hawaii) can be approximated by the following formula: 69*(lat1 lat2)2+(long1 long2)2 The file Citydata.xlsx contains the latitude and longitude of selected US cities. Create a table that gives the distance between any two of the listed cities. How can I solve this in excel using any lookup function?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!