Do all this in Excel

The shortest distance between two points on the surface of the globe $($great$-$

circle distance$)$ can be calculated by using the haversine formula. If ${}_1$ and

${}_1$ are the latitude and longitude of point $1$ and ${}_2$ and ${}_2$ are the latitude

and longitude of point $2,$ the great circle distance between the points is given

by:

$d=2Rsi{n}^{-1}(\sqrt[\phantom{2}]{a})$

where $a=si{n}^2(\frac{{}_2-{}_1}{2})+cos{}_{1}cos{}_{2}cos{}_{1}si{n}^2(\frac{{}_2-{}_1}{2}),$ and $R=3,959mi$ is

the Farth radius. Write a user$-$defined function that determines the distance

between two points on the Earth. For the function name and arguments, use

dis $=$ GreatCirDis $($Lat$1,$ Lng$1,$ Lat $2,$ Lng$2),$ where the input argu$-$

ments are the latitude and longitude of the two points $($degrees in decimal

format$),$ and dis is the great$-$circle distance in miles. Use the function to

calculate the distance between London $(51\mathrm{.}50853,-0\mathrm{.}12574)$ and New York City $(40\mathrm{.}71427,-74\mathrm{.}00597)$