The distance between any two cities can be approximated by the formula:

$=69*$SQRT$(($lat city$1-$lat city$2)^2+($long city$1-$long city$2)^2)$

The table below contains the data needed to fill in the chart in yellow. Use VLOOKUPS to solve.

max $10$ points

Lat Long

New York $40\mathrm{.}773\mathrm{.}9$ HINT: The table contains the latitude and longitude for each city.

Boston $42\mathrm{.}371\mathrm{.}0$ The cities in cells A$30$:A$50$ represent what should be city$1$ in your formulas.

Philadelphia $40\mathrm{.}075\mathrm{.}1$ The cities in cells B$29$:V$29$ represent what should be city$2$ in your formulas.

Charlotte $35\mathrm{.}280\mathrm{.}8$ It makes the formula easier to write if we use Named Ranges for the table, city$1,$ and city$2.$

Atlanta $33\mathrm{.}884\mathrm{.}4*$This is a very complicated formula, do not give up$.$ To help you determine if you are on the right track,

New Orleans $30\mathrm{.}089\mathrm{.}9$ the answer for New York to Boston in $229($rounded$).$

Miami $25\mathrm{.}880\mathrm{.}2$

Dallas $32\mathrm{.}896\mathrm{.}8$

Houston $29\mathrm{.}895\mathrm{.}4$

Chicago $41\mathrm{.}887\mathrm{.}7$

Detroit $42\mathrm{.}483\mathrm{.}1$

Cleveland $41\mathrm{.}581\mathrm{.}7$

Indy $39\mathrm{.}886\mathrm{.}1$

Denver $39\mathrm{.}8104\mathrm{.}9$

Minneapolis $45\mathrm{.}093\mathrm{.}3$

Phoenix $33\mathrm{.}5112\mathrm{.}1$

Salt Lake City $40\mathrm{.}8111\mathrm{.}9$

LA $34\mathrm{.}1118\mathrm{.}4$

SF $37\mathrm{.}8122\mathrm{.}6$

SD $32\mathrm{.}8117\mathrm{.}1$

Seattle $41\mathrm{.}6122\mathrm{.}4$

New York Boston Philadelphia Charlotte Atlanta New Orleans Miami Dallas Houston Chicago Detroit Cleveland Indy Denver Minneapolis Phoenix Salt Lake City LA SF SD Seattle

New York

Boston

Philadelphia

Charlotte

Atlanta

New Orleans

Miami

Dallas

Houston

Chicago

Detroit

Cleveland

Indy

Denver

Minneapolis

Phoenix

Salt Lake City

LA

SF

SD

Seattle