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
Get step-by-step solutions from verified subject matter experts
