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
Step 2 Highlight Clusters in the Normal... View full answer
Get step-by-step solutions from verified subject matter experts
