Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 16

Refer to the clustering problem involving the file FBS described in Problem 1.
a. Apply hierarchical clustering with 10 clusters using latitude and longitude as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure, and specify single linkage as the clustering method. Analyze the resulting clusters by computing the cluster size and the geographical range that the cluster spans. It may be helpful to use a PivotTable on the data in the HC_Clusters
worksheet generated by XLMiner. you can also visualize the clusters by creating a scatter plot with longitude as the x -variable and latitude as the y -variable.
b. Repeat part a using average linkage as the clustering method. Compare the clusters to the previous methods.
c. Repeat part a using Ward's method as the clustering method. Compare the clusters to the previous methods.
d. Repeat part a using complete linkage as the clustering method. Compare the clusters to the previous methods.
e. Repeat part a using average group linkage as the clustering method. Compare the clusters to the previous methods.