# Question: Refer to the clustering problem involving the file FBS described

Refer to the clustering problem involving the file FBS described in Problem 1. Apply hierarchical clustering with 10 clusters using football stadium capacity, latitude, longitude, endowment, and enrollment as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Use Ward's method as the clustering method.

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.)

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.)

**View Solution:**## Answer to relevant Questions

Refer to the scenario described in Problem 19 and the file HousingBubble. a. For the following substeps, consider the Pre-Crisis worksheet data. Partition the data into training (50 percent), validation (30 percent), and ...Suppose that IBM employs a network of expert analytics consultants for various projects. To help it determine how to distribute its bonuses, IBM wants to form groups of employees with similar performance according to key ...Professor Rao would like to accurately calculate the grades for the 58 students in his Operations Planning and Scheduling class (OM 455). He has thus far constructed a spreadsheet, part of which follows: The file RSR ...Use the spreadsheet model constructed to answer Problem 1 to answer this problem. a. Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from ...Kelson Sporting Equipment, Inc., makes two types of baseball gloves: a regular model and a catcherâ€™s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in ...Post your question