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

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Order Amount
[/TD]
[TD]Latitude[/TD]
[TD]Longitude[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]$54[/TD]
[TD]-76[/TD]
[TD]54[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]$25[/TD]
[TD]-78[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]






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