Geocoded Sales Densities

[andypandy123]

I have a data dump of sales transactions with corresponding dollar values and delivery coordinates (latitude and longitude). I'd like to run some form of cluster analysis to output a ranked listing of where the highest to lowest density of sales is based on an input of an X-mile radius. I'm guessing the steps are as below:

1. Need formula to convert lat/long coordinates into miles
2. Run a table or something to get all orders' distance from each other's coordinates in miles
3. Run another sensitivity table with the universe of lat/long coordinates and their corresponding 1 mile radius sales

Order Amount	Latitude	Longitude
$54	-76	54
$25	-78	25

<tbody>
</tbody>

Any ideas / sample spreadsheets for this? Preferably without using any macros.