Conduct a cluster analysis in Excel for a set of Geo Co-ordinates
$30-250 AUD
Pago na entrega
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
ID do Projeto: #7725316
Sobre o projeto
Concedido a:
Hi there I recorded an audio proposal: [login to view URL] Please check out all of my positive reviews on my profile. Thanks Alex
5 freelancers estão ofertando em média $195 nesse trabalho
Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions
Hello, I think this is doable. I have few questions still. Please ping me if you are interested. Thanks
Interested and want to start work on this. lets discuss i am professional and trusted freelancer. highly interested