Refer to the clustering problem involving the file FBS described in Problem 1. Apply hierarchical clustering with
Question:
a. Use a PivotTable on the data in the HC_Clusters1 worksheet to compute the cluster centers for the clusters in the hierarchical clustering.
b. Identify the cluster with the largest average football stadium capacity. Using all the variables, how would you characterize this cluster?
c. Examine the smallest cluster. What makes this cluster unique?
d. By examining the dendrogram on the HC_Dendrogram worksheet (as well as the sequence of clustering stages in HC_Output1), what number of clusters seems to be the most natural fit based on the distance? What is the increase in distance if 9 clusters were used instead of 10? (Use the HC_Output1 worksheet as well as the HC_Dendrogram worksheet.)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Question Posted: