Question: Segment the cities into four groups using k-means clustering analysis Describe the differences among the four segments (you can use a Pivot table to create

Segment the cities into four groups using k-means clustering analysis

Describe the differences among the four segments (you can use a Pivot table to create the summary for the four segments, then write down their differences in Excel)

City

City % age black %age Hispanic %age Asian Median Age Unemployment rate Per capita income(000's)
Albuquerque 3 35 2 32 5 18
Atlanta 67 2 1 21 5 22
Austin 12 23 3 29 3 19
Baltimore 59 1 1 33 11 22
Boston 26 11 5 30 5 24
Charlotte 32 1 2 32 3 20
Chicago 39 20 4 31 9 24
Cincinnati 38 1 1 31 8 21
Cleveland 47 5 1 32 13 22
Columbus 23 1 2 29 3 13

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!