Question: can you help me with the excel formula Problem 4: Hierarchical Clustering (40 points) The table below contains data on 10 schools that belong to

can you help me with the excel formula

Problem 4: Hierarchical Clustering (40 points) The table below contains data on 10 schools that belong to the FBS (Football Bowl Subdivision). a) Apply hierarchical clustering using variables StadiumCapacity, Latitude, Longitude, and Enrollment. Decide whether to normalize the values or not. Use Single Linkage method, 10 for maximum number of levels, and 2 for number of clusters; b) Click on HC_Dendrogram tab (if you don't see a dedrogram, click on "Model" button in the "Data Mining" tab and the dendrogram will appear), use a snipping tool to copy the dendrogram and save it on the HC_Dendrogram tab; c) Draw a horizontal line which will divide the dendrogram into four clusters. d) List (or highlight) all four clusters found in c). e) What is the (approximate) largest distance within each cluster found in c)?
School StadiumCapacity Latitude Longitude AthleticRevenue ($) Endowment ($000) Enrollment
Michigan Wolverines 114804 42.27535 -83.730841 84510199 7834752 42716
Penn State Nittany Lions 107282 40.27605 -76.884503 116118025 1725138 45628
Tennessee Volunteers 102455 35.97455 -83.946288 104368992 848329 30194
Ohio State Buckeyes 102329 39.988933 -82.987381 131815821 2120714 56867
Alabama Crimson Tide 101821 33.2377 -87.540979 124498616 995147 31647
Texas Longhorns 101624 30.30588 -97.750522 150295926 2852959 38437
UCLA Bruins 94118 34.112101 -118.411201 66003893 2975615 40675
Georgia Bulldogs 92746 33.9553 -83.393701 92341067 745765 34816
Florida Gators 92548 29.67415 -82.336277 123514257 1295313 49589
LSU Tigers 92542 30.448967 -91.126043 107259352 692556 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Step 2 Highlight Clusters in the Normal... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!