Assignment $6$: Segmentation

Please finish the following assignments in Excel and submit the Excel file onto Pilot.

$1.$ Segment the cities in $$City$.$xsls$$ into four groups using k$-$means clustering analysis

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