In Progress

Cluster analysis of Chinese city-level data

We need to create a natural clustering of cities in China based on their geographic location (their distance from one another) and an importance factor we assign to each city. This will help us group cities with largest importance and nearest to each other as a larger geographical cluster. We do not wish to do the clustering based on what prefecture or province the cities belong to, as this will not allow us to create an efficient segmentation, as we may have cities within the borders of several prefectures that form a more important cluster when grouped together than if we simply group them into their respective prefectures.

We will provide the following data in excel format:

-> City name (Approximately 2.6k cities)

-> Province name (of the city)

-> Latitude (to determine geographical location)

-> Longitude (to determine geographical location)

-> Importance factor (nominal value to determine importance factor of a city)

Deliverables

1. Core Analysis: The deliverable will require the natural clustering of cities as well as a descriptive methodology (algorithm) that was used to cluster the cities.

A. We may require doing several iterations of the clustering, as we may adjust the values for the importance factors

B. We would like to see several options for the number of natural geographical clusters depending on the output of the analysis; the main focus being:

i. Mega-clusters, identifying 5-10 major clusters for highest importance areas (i.e. Beijing and Shanghai centered mega-clusters)

C. Clusters mapped in Tableau

2. Excel spreadsheet: All the data we sent plus a new column indicating which clustering group the city belongs to.

3. Heat Map: Create a heat map of China with the natural clusters (darkness of color based on importance factor of natural cluster (the natural cluster is the sum of the importance factor of each individual city).

A. We prefer that the mapping be done in Tableau so we can make adjustments ourselves, if this is not possible, we will need you to perform the adjustments as we move along.

1. The map must have a good quality to include it in a power point presentation

2. We may need to modify the color scheme of the heat map

3. We will need to label the location of certain key cities in China (a few key cities)

4. We should be able to see the geographical limits (borders) between the natural cluster

Skills: Data Processing, Data Science, Excel, SPSS Statistics, Statistical Analysis

See more: computer project level data dictionary, chinese english gear data translation, edmonton entry level data entry, cluster analysis library, entry level data entry home, java code level data mirroring, entry level data entry, questionaire spss cluster analysis, swot analysis cebu city, jakarta city economic data, quezon city encoder data, cluster analysis example statistica outsourcing, cluster analysis, cluster analysis mysql, davao city money data

About the Employer:
( 0 reviews ) Korea, Republic of

Project ID: #15772910

30 freelancers are bidding on average $1095 for this job

schoudhary1553

Greeting, I have understood your Cluster analysis of Chinese city-level data task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 year More

$1250 USD in 20 days
(228 Reviews)
7.4
KreativeTeam

hi there, I'd like to be considered for your project Relevant Skills and Experience I'm expert writer,editor and researcher. I've been delivering top quality papers for students from college to PhD [login to view URL] do le More

$1250 USD in 20 days
(7 Reviews)
4.6
cyash61

Hello, I am an analytics consultant with more than 6 years of experience in statistical analysis including clustering for clients across the globe. I can create this map smoothly. (Check reviews) Relevant Skills and E More

$1500 USD in 20 days
(7 Reviews)
4.3
npquynh

I am a senior lecturer in finance at a prestige university for 4 years, with a master degree in finance from a U.S. University. I am a Ph.D. student in finance in Germany. I had also worked as an investment consultant More

$1500 USD in 20 days
(3 Reviews)
3.8
NeetuSinghal

Cluster Analysis Relevant Skills and Experience I have 9 years of work exp in Data Analytics with M.Phil. in Operation Research. Techniques – Predictive Modeling, Machine Learning Tools–R, Excel, SAS, SPSS, Python Pr More

$777 USD in 15 days
(11 Reviews)
3.6
dinhfreedom

-----------------Best result on time && Master in Data Processing and Statistics, Excel!------------------------------ Hello, dear! I have read your proposal and I am very interesting in your project. I have good ex More

$750 USD in 20 days
(3 Reviews)
3.3
$888 USD in 20 days
(3 Reviews)
3.0
$833 USD in 10 days
(5 Reviews)
3.3
kkc1985612

Hi, How are you? I’ve carefully gone through your job post. I am very much interested in your project with all of your requirements. Stay tuned, I'm still working on this proposal.

$1250 USD in 20 days
(3 Reviews)
2.5
earthat

HI I have done prior similar work of geo-clustering for a courier company using google API and calculated the shortest delivery path also. If longitude and lattitude are even not provided, it will. Relevant Skill More

$1455 USD in 45 days
(1 Review)
1.6
$777 USD in 20 days
(0 Reviews)
0.0
alisiddique123

I have assisted clients with data and statistical analysis in the past. I can complete the task inside a day. I hope I am considered. Thanks. Relevant Skills and Experience SPSS. Statistics. Analysis Proposed Milesto More

$1250 USD in 3 days
(1 Review)
0.0
bturner7

-----------------------------PhD in Statistics! Best Result in Time!---------------------- Relevant Skills and Experience I'm a professional mathematician on the fields of probability&statistics and have high level sk More

$750 USD in 20 days
(1 Review)
0.0
pratikdatta91

I have excellent working Knowledge of Tableau and use it to create geographic and demographic Analysis of Sales/Presales / Recruitment related data.

$1333 USD in 5 days
(0 Reviews)
0.0
bjornhe

Cluster analysis of Chinese city-level data. A data driven analysis. Relevant Skills and Experience We sit in Beijing and have worked on a similar analysis for a major German car manufacturer. I have a small team of More

$1498 USD in 19 days
(0 Reviews)
0.0
ovgrig

I have a lor oh experience in machine learning, pattern recognition, including clustering. I am intereted in your work/proje

$1250 USD in 20 days
(0 Reviews)
0.0
mohamedmakhlo

Hello I work Data entry , Data Processing ,Excel , Word , Data Analytics , Copy Typing ,Internet Marketing Web search fast and high skill with 2 years experience Relevant Skills and Experience Hello I work Data ent More

$755 USD in 20 days
(1 Review)
0.0
s6solutions

I am an undergraduate at IIT Bombay, India's foremost engineering college. Besides a major in the Computer Science and Engineering Department, I am pursuing a minor in Applied Statistics and Informatics and this makes More

$827 USD in 7 days
(0 Reviews)
0.0
datotahost

We provide the developer on tableau, informatica and cognos design dashboard, visualization and reporting. Relevant Skills and Experience Tableau, Informatica Proposed Milestones $750 USD - Tableau work

$750 USD in 20 days
(0 Reviews)
0.0
BekaluB3

A proposal has not yet been provided

$1111 USD in 10 days
(1 Review)
0.0