The nine total clusters formed from the regions

Assignment Help Operation Management

Reference no: EM132226392

Refer to the background involving the file FBS described in Chapter 4 homework 1 &2. 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. Follow 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. Using the cluster assignments, separate the original data in the Data worksheet into three separate data sets – one data set for each of the three “regional” clusters.

For Region 1 data set, 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 the corresponding HC_Clusters worksheet, report the characteristics of each cluster.

For the Region 2 data set, 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 the corresponding HC_Clusters worksheet, report the characteristics of each cluster.

For the Region 3 data set, 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 the corresponding HC_Clusters worksheet, report the characteristics of each cluster.

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?

Reference no: EM132226392

Questions Cloud

Explain how you identify the consumer priorities : Explain how you identify the consumer priorities, needs and preferences affecting marketing mix.

Where does sergio marchionne fall on the leadership grid : Where does Sergio Marchionne fall on The Leadership Grid?

What are some tactics used by sergio marchionne : What are the primary sources of power used by Sergio Marchionne ? What are some tactics used by Sergio Marchionne?

Where does sergio fall on the leadership grid : Where does Sergio fall on “The Leadership Grid”. How would you discribe his intelligence?

The nine total clusters formed from the regions : 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?

Developed to replace moisturizing black soap : Read the New Product Proposal, which contains three examples of possible products that could be developed to replace Moisturizing Black Soap Shampoo.

Challenges and opportunities for public sector unions : Explain the Challenges and Opportunities for Public Sector Unions

What happens if all attempts fail to nudge project sponsor : What proposals, if any, have been presented to amend the Affordable Care Act policy? "What happens if all attempts fail to nudge the project sponsor"?

Selecting the managing director of its indian subsidiary : Tel-Comm-Tek (TCT) manufactures a variety of small office equipment such as copying machines, dictation units, laser printers, and paper shredders.

User Account

All Pages