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

Refer to the clustering problem involving the file FBS described in Problem 1. The NCAA has a preference for conferences consisting of similar schools with respect to their endowment, enrollment, and football stadium capacity, but these conferences must be in the same geographic region to reduce traveling costs. Take the following steps to address this desire. Apply k-means clustering using latitude and longitude as variables with k = 3. Be sure to Normalize input data, and specify 50 iterations and 10 random starts in Step 2 of the XLMiner k-Means Clustering procedure. Then create one distinct data set for each of the three regional clusters.

a. For the west cluster, apply hierarchical clustering with Ward's method to form two clusters using football stadium capacity, endowment, and enrollment as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure.

Using a PivotTable on the data in HC_Clusters1, report the characteristics of each cluster.

b. For the east cluster, apply hierarchical clustering with Ward's method to form three clusters using football stadium capacity, endowment, and enrollment as variables.

Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Using a PivotTable on the data in HC_Clusters1, report the characteristics of each cluster.

c. For the south cluster, apply hierarchical clustering with Ward's method to form four clusters using football stadium capacity, endowment, and enrollment as variables.

Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Using a PivotTable on the data in HC_Clusters1, report the characteristics of each cluster.

d. What problems do you see with the plan with defining the school membership of nine conferences directly with the nine total clusters formed from the regions? How could this approach be tweaked to solve this problem?

a. For the west cluster, apply hierarchical clustering with Ward's method to form two clusters using football stadium capacity, endowment, and enrollment as variables. Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure.

Using a PivotTable on the data in HC_Clusters1, report the characteristics of each cluster.

b. For the east cluster, apply hierarchical clustering with Ward's method to form three clusters using football stadium capacity, endowment, and enrollment as variables.

Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Using a PivotTable on the data in HC_Clusters1, report the characteristics of each cluster.

c. For the south cluster, apply hierarchical clustering with Ward's method to form four clusters using football stadium capacity, endowment, and enrollment as variables.

Be sure to Normalize input data in Step 2 of the XLMiner Hierarchical Clustering procedure. Using a PivotTable on the data in HC_Clusters1, report the characteristics of each cluster.

d. What problems do you see with the plan with defining the school membership of nine conferences directly with the nine total clusters formed from the regions? How could this approach be tweaked to solve this problem?

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

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 ...Cox Electric makes electronic components and has estimated the following for a new design of one of its products: Fixed cost = $10,000 Material cost per unit = $0.15 Labor cost per unit = $0.10 Revenue per unit = $0.65 These ...Consider again the mortgage refinance problem faced by Dave and Jana in Problem 16. Assume that they have accepted the refinance offer of a 15-year loan at 3 percent interest rate with out-of-pocket expenses of $2,937. ...Through a series of Web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4000 - 6p where p is the price of the e-book. a. Update your ...STAR Co. provides paper to smaller companies with volumes that are not large enough to warrant dealing directly with the paper mill. STAR receives 100-feet-wide paper rolls from the mill and cuts the rolls into smaller rolls ...Post your question