。。。

The Football Bowl Subdivision (FBS) level of the National Collegiate Athletic Association (NCAA) consists of over 100 schools. Most of these schools belong to one of several conferences, or collections of schools, that compete with each other on a regular basis in collegiate sports. Suppose the NCAA has commissioned a study that will propose the formation of conferences based on the similarities of the constituent schools. The file FBS contains data on schools belong to the Football Bowl Subdivision (FBS). Each row in this file contains information on a school. The variables include football stadium capacity, latitude, longitude, athletic department revenue, endowment, and undergraduate enrollment. Refer to the Appendix for instructions on how to perform a given hierarchical clustering method using the Analytic Solver Platform. (Hint: This can be done using a PivotTable in Excel to display the count of schools in each cluster as well as the minimum and maximum of the latitude and longitude within each cluster.)

In the Hierarchical Clustering — Step 2 of 3 dialog box, be sure to use Normalize input data. Use Euclidean distance as the Similarity Measure and set the Clustering Method to Single Linkage and in a second analysis to Group Average Linkage. In the Hierarchical Clustering — Step 3 of 3 dialog box set theMaximum Number of Leaves: to 10 and the Number of Clusters: to 10.

Click on the datafile logo to reference the data.

(a)

Apply hierarchical clustering with 10 clusters using latitude and longitude as variables. Compute the cluster sizes, as well as the minimum and maximum of the latitude and longitude of single linkage method. If required, round your answers to one decimal places. If your answer is negative, use minus sign.

Cluster Id	Cluster Size	Min of Latitude	Max of Latitude	Min of Longitude	Max of Longitude
1
2
3
4
5
6
7
8
9
10

(b)	Compute the cluster sizes, as well as the minimum and maximum of the latitude and longitude of group average linkage method. If required, round your answers to one decimal place. If your answer is negative, use minus sign.

Cluster Id	Cluster Size	Min of Latitude	Max of Latitude	Min of Longitude	Max of Longitude
1
2
3
4
5
6
7
8
9
10