Conduct a cluster analysis in Excel for a set of Geo Co-ordinates

Concluído Postado May 23, 2015 Pago na entrega
Concluído 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

Extração de Dados Excel Estatísticas

ID do Projeto: #7725316

Sobre o projeto

5 propostas Projeto remoto Ativo em May 23, 2015

Concedido a:

abender777

Hi there I recorded an audio proposal: [login to view URL] Please check out all of my positive reviews on my profile. Thanks Alex

$294 AUD em 6 dias
(13 Comentários)
4.6

5 freelancers estão ofertando em média $195 nesse trabalho

zExcel

Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions

$250 AUD in 3 dias
(167 Comentários)
6.9
Dhruvika111

A proposal has not yet been provided

$117 AUD em 1 dia
(119 Comentários)
7.0
gokulanand

Hello, I think this is doable. I have few questions still. Please ping me if you are interested. Thanks

$150 AUD in 3 dias
(48 Comentários)
5.1
sknadeem123

Interested and want to start work on this. lets discuss i am professional and trusted freelancer. highly interested

$164 AUD in 3 dias
(14 Comentários)
4.0