Conduct a cluster analysis in Excel for a set of Geo Co-ordinates
$30-250 AUD
Completed
Posted almost 9 years ago
$30-250 AUD
Paid on delivery
I have a large data set in excel of 20k plus entries. Each entry includes the following data:
LOCATION name, Geo lat, Geo Long + some other non important details.
I have included a small sample of the data.
I need to create a list of clusters, ranked by the number of LOCATIONS in each.
The number of clusters will be defined by a diametre defined by a single cell entry. IE 1 km.
The process for the spreadsheet would be:
- user enters the diametre for this analysis (say 1km)
- sheet processes the LOCATIONS and lists all the clusters with more than 0 outlets
- it sorts the list of clusters based on the number of locations in it. For each cluster, it has the following info:
Cluster ID, Lat, Long, Number of locations in cluster
- it reports on the number of clusters based on the diametre
We need to be able to tweak the DIAMETRE entry, to give an adequate number of clusters.
Bonus would be to:
- map the cluster centre points on a map
- lookup the cluster address details
Thanks