Question

School

Air Force Falcons
Akron Zips
Alabama Crimson Tide Arizona State Sun Devils Arizona Wildcats
Arkansas Razorbacks Arkansas State Red Wolves Army Black Knights Auburn Tigers

Ball State Cardinals Baylor Bears
Boise State Broncos Boston College Eagles Bowling Green Falcons Buffalo Bulls

BYU Cougars
California Golden Bears
Central Michigan Chippewas Charlotte 49ers
Cincinnati Bearcats
Clemson Tigers
Colorado Buffaloes
Colorado State Rams
Connecticut Huskies
Duke Blue Devils
East Carolina Pirates
Eastern Michigan Eagles
Florida International Golden Panthers Florida Atlantic Owls
Florida Gators
Florida State Seminoles
Fresno State Bulldogs
Georgia Bulldogs
Georgia State Panthers
Georgia Tech Yellow Jackets Hawaiʻi Warriors
Houston Cougars
Idaho Vandals
Illinois Fighting Illini
Indiana Hoosiers
Iowa Hawkeyes

StadiumCapacity Latitude

52,480 38.86

30,000 41.08 101,821 33.24 73,379 33.39 57,803 32.20 76,000 36.07 30,964 35.82 40,000 41.36 87,451 32.59 22,500 40.12 50,000 31.57 37,000 43.61 44,500 42.34 23,724 41.37 29,013 42.89 63,725 40.25 62,717 37.87 30,199 43.60 15,300 35.20 35,000 39.14 81,500 34.68 53,750 40.03 34,400 40.56 40,000 41.81 33,941 35.98 50,000 35.60 30,200 42.24 20,000 25.78 30,000 26.37 92,548 29.67 82,300 30.46 41,031 36.78 92,746 33.96 71,149 33.76 55,000 33.76 50,000 19.70 32,000 29.77 16,000 46.73 60,670 40.11 52,929 39.17 70,585 41.66

Longitude

-104.76 -81.52 -87.54

-111.93 -110.89 -94.16 -90.69 -74.03 -85.48 -87.84 -97.18 -116.23 -71.02 -83.65 -78.86 -111.64 -122.30 -84.78 -80.83 -84.51 -82.81 -105.25 -105.07 -72.26 -78.91 -77.37 -83.62 -80.21 -80.11 -82.34 -84.28 -119.79 -83.39 -84.42 -84.42 -155.09 -95.39 -117.00 -88.26 -86.53 -91.54

Iowa State Cyclones
Kansas Jayhawks
Kansas State Wildcats
Kent State Golden Flashes Kentucky Wildcats
Louisiana Tech Bulldogs Louisiana–Lafayette Ragin' Cajuns Louisiana–Monroe Warhawks Louisville Cardinals

LSU Tigers
Marshall Thundering Herd Maryland Terrapins Massachusetts Minutemen Memphis Tigers
Miami Hurricanes
Miami University RedHawks Michigan State Spartans Michigan Wolverines
Middle Tennessee Blue Raiders Minnesota Golden Gophers Mississippi State Bulldogs Missouri Tigers
Navy Midshipmen
NC State Wolfpack
Nebraska Cornhuskers
Nevada Wolf Pack
New Mexico Lobos
New Mexico State Aggies North Carolina Tar Heels North Texas Mean Green Northern Illinois Huskies Northwestern Wildcats
Notre Dame Fighting Irish Ohio Bobcats
Ohio State Buckeyes Oklahoma Sooners
Oklahoma State Cowboys
Old Dominion Monarchs
Ole Miss Rebels
Oregon Ducks
Oregon State Beavers
Penn State Nittany Lions

55,000 42.02 50,071 38.96 50,000 39.19 30,520 41.15 67,606 38.04 30,600 32.53 31,000 30.22 30,427 32.51 56,000 38.22 92,542 30.45 38,016 38.41 54,000 39.00 17,000 42.07 62,380 35.11 74,916 25.78 24,386 39.51 75,025 42.74

114,804 42.28 31,000 35.85 50,805 44.96 55,082 33.46 71,004 38.95 34,000 38.97 57,583 35.82 81,091 40.82 33,400 39.44 40,094 35.11 30,343 32.34 62,980 35.93 30,850 33.21 30,998 41.93 49,256 42.05 80,795 41.68 24,000 39.32

102,329 39.99 82,112 35.47 60,218 35.47 19,818 36.92 60,580 34.36 53,800 44.05 45,674 45.54

107,282 40.28

-93.63 -95.26 -96.59 -81.36 -84.46 -92.64 -92.03 -92.08 -85.74 -91.13 -82.43 -76.93 -71.25 -90.01 -80.21 -84.75 -84.48 -83.73 -86.39 -93.27 -88.82 -92.33 -76.50 -78.66 -96.69

-119.75 -106.61 -106.76

-79.04 -97.13 -88.75 -87.69 -86.27 -82.10 -82.99 -97.51 -97.51 -76.24 -89.53

-123.11 -122.66 -76.88

Pittsburgh Panthers Purdue Boilermakers Rice Owls
Rutgers Scarlet Knights San Diego State Aztecs San Jose State Spartans SMU Mustangs

South Alabama Jaguars
South Carolina Gamecocks South Florida Bulls
Southern Miss Golden Eagles Stanford Cardinal
Syracuse Orange
TCU Horned Frogs
Temple Owls
Tennessee V olunteers
Texas A&M Aggies
Texas Longhorns
Texas State Bobcats
Texas Tech Red Raiders Toledo Rockets
Troy Trojans
Tulane Green Wave
Tulsa Golden Hurricane
UAB Blazers
UCF Knights
UCLA Bruins
UNLV Rebels
USC Trojans
Utah State Aggies
Utah Utes
UTEP Miners
UTSA Roadrunners Vanderbilt Commodores Virginia Cavaliers
Virginia Tech Hokies
Wake Forest Demon Deacons Washington Huskies Washington State Cougars West Virginia Mountaineers Western Kentucky Hilltoppers Western Michigan Broncos

65,050 40.44 62,500 40.44 70,000 29.77 52,454 40.49 70,561 32.81 30,456 37.30 32,000 32.79 40,646 30.68 80,250 34.04 65,647 27.96 36,000 31.31 50,000 37.42 49,262 43.04 45,000 32.75 68,532 40.01

102,455 35.97 82,600 30.63 101,624 30.31 30,000 29.88 60,454 29.70 26,248 41.66 30,000 31.81 73,208 30.07 35,542 36.13 70,100 33.53 45,301 28.50 94,118 34.11 36,800 36.21 93,607 34.11 25,513 41.74 45,634 40.78 51,500 31.85 65,000 29.46 39,790 36.17 61,500 38.04 66,233 37.23 31,500 36.10 72,500 47.62 35,117 46.73 60,540 39.64 22,000 36.97 30,100 42.27

-79.98 -86.91 -95.39 -74.45

-117.14 -121.85 -96.77 -88.09 -80.89 -82.48 -89.31 -122.16 -76.14 -97.34 -75.13 -83.95 -96.33 -97.75 -97.93 -98.12 -83.58 -85.97 -89.93 -95.92 -86.80 -81.37 -118.41 -115.33 -118.41 -111.84 -111.93 -106.44 -98.51 -86.78 -78.49 -80.43 -80.26 -122.35 -117.16 -79.95 -86.44 -85.59

Wisconsin Badgers 80,321 43.08 -89.39 Wyoming Cowboys 32,580 41.31 -105.58

AthleticRevenue ($)

39,823,782

25,583,730 124,498,616 55,294,113 59,663,128 91,768,112 13,374,507 34,342,038 103,982,441 20,483,476

37,524,722

20,157,361 26,228,030

65,243,053 23,500,552

42,724,841 61,174,977 60,923,253 29,372,783 63,089,340

34,048,869 27,717,621 23,849,954 19,438,422

123,514,257 78,575,788 30,190,480 92,341,067 22,895,575 54,354,409 36,801,458 34,614,033 17,545,304 77,863,883 71,017,355 93,353,561

Endowment ($000)

56,600 171,513 995,147 514,724 552,351 788,668

39,479

73,190 471,851 140,275

1,003,929 72,507 1,726,100 141,788 494,791 920,149 3,257,667 85,267 140,913 1,004,368 473,748 784,580 221,231 312,329 5,747,377 128,551 47,101 136,237 179,739 1,295,313 525,260 127,293 745,765 113,199 1,619,718 215,119 662,984 192,003 1,600,603 1,574,815 1,044,097

Enrollment

4,413 27,470 31,647 72,254 39,236 23,199 13,900

4,624 25,469 22,147 15,029 19,664 13,906 17,577 28,860 34,101 25,885 28,194 25,277 32,264 19,914 32,252 30,450 25,868 15,427 27,386 23,341 44,686 29,290 49,589 41,087 21,981 34,816 32,022 20,941 20,429 39,820 12,312 44,407 42,731 29,810

48,591,617 74,850,203 69,947,834 21,448,821 84,878,311 17,146,559 13,556,901 11,661,727 87,736,323

107,259,352 27,444,906 61,634,829 27,248,277 40,384,265

26,745,727 122,739,052 84,510,199 27,125,185 78,924,683 58,981,769 64,146,530

51,076,345 83,679,756 22,652,490 40,287,108 26,997,597 75,606,311 11,259,222 24,148,602

25,470,296 131,815,821 104,338,844

82,631,915 32,893,744 49,180,892 85,819,699 55,544,015

116,118,025

612,283 29,611 1,250,443 27,939 337,460 23,863 37,250 27,855 915,924 27,226 63,314 11,518 69,627 16,885 23,158 8,583 772,157 21,153 692,556 29,718 83,810 13,966 791,809 37,580 210,101 28,084 195,060 22,725 719,852 16,068 403,070 17,395 317,721 47,954 7,834,752 42,716 64,570 26,442 2,503,305 52,557 346,676 20,424 1,119,032 33,805 89,780 4,576 617,632 34,767 1,241,577 24,593 235,404 18,004 349,145 28,977 186,737 18,024 2,260,970 29,137 110,735 35,574 49,890 22,990 7,182,745 19,968 6,259,598 12,004 336,000 26,201 2,120,714 56,867 1,212,023 30,743 681,744 24,231 170,176 24,753 469,006 18,224 467,211 24,936 411,964 24,977 1,725,138 45,628

66,202,493

60,190,100 45,201,703 18,861,113

17,432,045 83,813,226 41,948,123

6,799,370

104,368,992 87,296,532 150,295,926 21,741,489 59,534,895 19,485,449 15,246,720

25,690,048 42,762,625 66,003,893 59,544,869

22,777,944 38,091,538 27,694,358 16,675,632

78,439,006 66,909,557

70,231,336 39,983,482 60,451,426 22,269,484 25,627,752

2,527,398 28,766 2,001,601 39,637 4,451,452 6,224

698,507 39,950 135,191 31,303 73,100 30,236 1,196,508 10,982 283,496 14,769 494,358 30,721 349,320 39,596 58,745 11,604 16,502,606 19,945 913,662 20,829 1,191,900 9,518 280,731 36,855 848,329 30,194 358,946 49,861 2,852,959 38,437 119,711 34,087 890,930 32,327 197,374 22,610 30,640 28,322 1,014,985 13,359 800,925 4,092 326,970 17,575 127,129 58,587 2,975,615 40,675 168,560 27,378 3,517,173 38,810 208,986 26,657 668,683 31,660 174,922 22,640 81,760 30,968 3,414,514 12,836 4,760,515 24,927 600,648 30,936 1,058,250 7,351 2,154,494 42,428 722,717 27,327 392,001 29,617 114,415 21,036 198,436 25,086

96,288,191 1,872,933 42,441 27,577,001 321,781 12,925
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 orn 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. Click on the datafile logo to reference the data. DATA file App y hierarchical clustering with 10 clusters using latitude and longitude as variables. Be sure to Normalize I put Data in Step 2 of the XL Mine Hierarchical 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. a Steที่ng procedure. Compute Cluster Id Cluster Size Min of Latitude Max of Latitude Min of Longitude Max of Longitude 4 38.9 41.3 105.6 -104.8 4 40.3 41.7 7 8 9 10 19.7 19.7 155.1 155.1

Answer 1

a) From the given information, mentioned Below is the Table containing the required details. Clustering was done using Latitude & Longitude variables. The Latitude & Longitude were standardized before applying clustering.

Cluster Id	cluster size	Min of latitude	Max of latitude	Min of longitude	Max of longitude
1	4	38.9	41.3	-105.6	-104.8
2	99	25.8	45.0	-98.5	-71.0
3	2	32.2	33.4	-111.9	-110.9
4	3	43.6	46.7	-117.2	-116.2
5	3	40.3	41.7	-111.9	-111.6
6	8	32.8	39.4	-122.3	-117.1
7	1	19.7	19.7	-155.1	-155.1
8	3	31.9	35.1	-106.8	-106.4
9	3	44.1	47.6	-123.1	-122.4
10	1	36.2	36.2	-115.3	-115.3

Please post the remaining questions in another post.