1 School 2 Air Force Falcons 3 Akron Zips 4 Alabama Crimson Tide 5 Arizona State Sun Devils 6 Arizona Wildcats 1 Arkansas Razorbacks 3 Arkansas Sute Red Wolves 9 Amy Black Knights 10 Auburn Tigers 11 Ball State Cardinals 12 Baylor Bears 13 Bolse Sorte Broncos 14 Boston College Eagles 15 Bowling Green Falcons 16 Buffalo Bulls 17 BYU Cougars 15 California Golden Bears 19 Central Michigan Chippews 20 Charlotte 49ers 21 Cincinnati Burcats 22 Clemson Tigers 23 Colorado Buffaloes 24 Colorado State Rams 25 Connecticut Huskies 26 Duke Blue Devils 27 East Carolina Pirates 2 Eastern Michigan Eagles 29 Florida International Golden Panthers 30 Florida Atlantic Owls 31 Florida Gators 32 Florida State Seminoles 11 Fan Club Data + StadiumCapacity Latitude Longitude 52,480 38.86 -104.76 30,000 41.08 -81.52 101,821 33.24 -87.54 73,379 33.39 111.93 57,803 32.20 -110.89 76,000 36.07 -94.16 30,964 35.82 -90.69 40,000 41.36 -74.03 87.451 32.59 -85.48 22,500 40.12 -87.84 50,000 3157 -97.18 37,000 43.61 -116.23 44.500 42.34 -71.02 23,724 41.37 -83.65 29.013 42.89 -78.86 63,725 40.25 -111.64 62.717 37.87 -122 30 30,199 43.60 -84.78 15,300 35.20 -80.83 35,000 39.14 -8451 81,500 34.68 -82.81 53,750 40.03 -105.25 34,400 40.56 -105.07 40,000 41.81 -72.26 33,941 35.98 -78.91 50,000 35.60 -7737 30,200 42.24 -83.62 20,000 25.78 80.21 30,000 26.37 -80.11 92,548 29.67 .82 34 82,300 30.46 -84.28 41081 3678 .11970 AthleticRevenue (5) Endowment (5000) Enrollment 39,823,782 56,600 4,413 25,583,730 171,513 27,470 124,498,616 995,147 31,647 55,294,113 514,724 72,254 59,663,128 552,351 39,236 91,768,112 788,668 23,199 13,374,507 39,479 13,900 34,342,038 73,190 103.982,441 471,851 25,469 20,483,476 140,275 22,147 1.003.929 15.029 37,524,722 72,507 19,664 1.726,100 13,906 20,157,361 141,788 17,577 26,228,030 494,791 28,860 920,149 34,101 65,243,053 3,257,667 25.885 23,500.552 85,267 28,194 140,913 25,277 42,724,841 1,004,368 32,264 61,174,977 473,748 19.914 60,923,253 784,580 32,252 29,372,783 221.231 30.450 63,089,340 312,329 25,868 5.747,377 15,427 34,048,869 128,551 27,386 27,717,621 47.101 23,341 23,849,954 136,237 44.686 19,438,422 179,739 29.290 123,514,257 1,295,313 49,389 78,575,788 525.260 41,087 2010 ann 127991 21 OR 32 Florida State Seminoles 33 Fresno State Bulldogs 34 Georgia Bulldogs 35 Georgia State Panthers 36 Georgia Tech Yellow Jackets 37 Hawaii Warriors 3 Houston Cougars 39 Idaho Vandals 40 Mlinois Fighting Illini 41 Indiana Hoosiers 42 Towa Hawkeyes 43 Iowa State Cyclones 4 Kansas Jayhawks 45 Kansas State Wildcats 46 Kent State Golden Flashes 47 Kentucky Wildcats 48 Louisiana Tech Bulldogs 49 Louisiana Lafayette Ragio Cajuns 50 Louisiana Monroe Warhawks 51 Louisville Cardinals 52 LSU Tigers 5) Marshall Thundering Herd 34 Maryland Termins 35 Massachusetts Minutemen 56 Memphis Tigers 57 Miami Hurricanes 58 Mimi University RedHawks 19 Michigan State Spartans 60 Michigan Wolverines 61 Middle Tennessee Blue Raiders 2 Minnesota Golden Gophers Mississippi State Bulldogs Data + 92,54% 82,300 41,031 92,746 71,149 55,000 50.000 32,000 16,000 60,670 52,929 70,585 55,000 50,071 50,000 30,520 67,606 30,600 31,000 30,427 56,000 92,542 38,016 54,000 17,000 62,380 74,916 24,385 75,025 114,804 31,000 50,805 55,082 29.07 30.46 36.78 33.96 33.76 33.76 19.70 29.77 46.73 40.11 39.17 41.66 42.02 38.96 39,19 41.15 38.04 32.53 30.22 32.51 38.22 30.45 38.41 39.00 42.07 35.11 25.78 39.51 42.74 42.28 35.85 44.96 33.46 -84.28 -119,79 -83.39 -84.42 -84.42 -155.09 -95.39 -117.00 -88.26 -86.33 -91.54 -93.63 -95.26 -96.39 -81.36 -34,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 123,314,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 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 1,293,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 612,283 1,250,443 337,460 37,250 915,924 63,314 09.627 23.158 772,157 692,356 83,810 791,809 210,101 195,060 719,852 403,070 317,721 7,834,752 64,570 2,503,305 346,676 49,389 41,087 21,981 34,816 32,022 20,941 20,429 39,820 12,312 44,407 42.731 29,810 29,611 27.939 23,863 27.855 27.226 11,518 16,885 8,583 21,153 29,718 13,966 37,380 28,084 22,725 16,068 17,395 47,954 42,716 26,442 52,557 20,424 26,745,727 122,739,052 84,510,199 27,125,185 78,924,683 58,981,769 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 63 Mississippi State Bulldogs 64 Missouri Tigers 65 Navy Midshipmen 66 NC State Wolfpack 67 Nebraska Comhuskers 68 Novada Wolf Pack 6 New Mexico Lobos 70 New Mexico State Aggies 71 North Carolinn Tar Heels 72 North Texas Mean Green 73 Northern Illinois Huskies 74 Northwestem Wildcats 75 Notre Dame Fighting Irish 76 Ohio Bobcats 77 Ohio State Buckeyes 73 Oklahoma Sooners 79 Oklahoma State Cowboys 89 Old Dominion Monarchs N1 Ole Miss Rebels H2 Oregon Ducks * Oregon State Beavers 84 Penn State Nittany Lions e Pittsburgh Panthers 35 Purdue Boilermakers 87 Rice Owls 8 Rutgers Scarlet Knights 89 San Diego Site Aztecs 90 San Jose State Spartans 91 SMU Mustang 92 South Alabama Jaguars 9) South Carolina Gamecocks 94 South Florida Balls Calen Data + 55,082 71,004 34,000 57,583 81,091 33,400 40,094 30,343 62,980 30,850 30,998 49,256 80.795 24,000 102,329 82,112 60,218 19,818 60,580 53,800 45,674 107,282 65,050 62,500 70,000 52,454 70,561 30,456 32.000 40,646 80,250 65,647 33.46 38.95 38.97 35.82 40.82 39.44 35.11 32.34 35.93 33.21 41.93 42.05 41.68 39.32 39.99 35.47 35.47 36.92 34 36 44.05 45.54 40.28 40.44 40.44 29.77 40.49 32.81 37.30 32.79 30.68 34.04 27.96 -88.82 -92.33 -76.50 -78.66 -96.69 -119.75 -106,61 -106.76 - 29.04 -97.13 -88.75 -87.69 -86.27 -$2.10 -82.99 -97.51 -97.51 - 76.24 -89.53 -123.11 -122.66 - 76.88 -79.98 -86.91 -95.39 - 74.45 -117.14 -121.85 -96.77 -88.09 -80.89 -82.48 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 346,676 1,119,032 89,780 617,632 1,241,577 235,404 349,145 186,737 2,260,970 110,735 49,890 7,182,745 6,259,598 336,000 2,120,714 1,212,023 681,744 170,176 469,006 467,211 411,964 1,725,138 2,527,398 2,001,601 4,451,452 698,507 135,191 73,100 1,196,508 283,496 494,358 349,320 COTA 20,424 33,805 4,576 34,767 24,593 18,004 28,977 18,024 29,137 35,574 22,990 19,968 12,004 26,201 56,867 30,743 24,231 24,753 18,224 24,936 24,977 45,628 28,766 39,637 6,224 39,950 31,303 30,236 10,982 14,769 30,721 39,596 66,202,493 60,190,100 45,201,703 18,861,113 17,432,045 83,813,226 41,948,123 0021 41,948,123 6,799,370 104,368,992 87,296,532 150,295,926 21,741,489 59,334,893 19,485,449 15,246,720 94 South Florida Bulls 95 Southern Miss Golden Eagles 96 Stanford Cardinal 97 Syracuse Orange 98 TCU Home Frogs 99 Temple Owls 100 Tennessee Volunteers 101 Texas A&M Aggies 102 Texas Longhorns 103 Texas State Bobcats 104 Texas Tech Red Raiders 105 Toledo Rockets 105 Troy Trojans 107 Tulane Green Wave 108 Tulsa Golden Hurricane 109 UAB Blazers 110 UCF Knights 1 UCLA Bruins 112 UNLV Rebels 113 USC Trojans 114 Utah State Aggles 115 Utah Utes 116 UTEP Miners 117 UTSA Roadrunners 118 Vanderbilt Commodores 119 Virginia Cavaliers 120 Virginia Tech Hokies 121 Wake Forest Demon Descons 122 Washington Huskies 123 Washington State Cougars 124 West Virginia Mountaineers 125 Western Kentucky Hillhoppers Data + 65,647 36,000 50,000 49,262 45,000 68,532 102,455 82,600 101,624 30,000 60,454 26,248 30,000 73.208 35,542 70.100 45,301 94,118 36,800 93,607 25,513 45,634 51,500 65,000 39,790 61,500 66,233 31,500 72,500 35,117 60,540 22,000 27.96 31.31 37.42 43.04 32.75 40.01 35.97 30.63 30.31 29.88 29.70 41.66 31.81 30.07 36.13 33.53 28.50 34.11 36.21 34.11 41.74 40.78 31.85 29.46 36.17 38.04 37.23 36.10 47.62 46.73 39.64 36.97 -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 25,690,048 42,762,625 66,003,893 59,544,869 349,320 58,745 16,502,606 913,662 1,191,900 280,731 848,329 358,946 2,852,959 119,711 890,930 197,374 30,640 1,014,985 800.925 326,970 127,129 2,975,615 168,560 3,517,173 208.986 668,683 174,922 81.760 3,414,514 4,760,515 600.648 1,058,250 2,154,494 722,717 392,001 114,415 39,596 11,604 19,945 20,829 9,518 36,855 30,194 49,861 38,437 34,087 32,327 22,610 28,322 13,359 4,092 17,575 58,587 40,675 27,378 38,810 26,657 31,660 22,640 30,968 12,836 24.927 30,936 7,351 42,428 27,327 29,617 21,036 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 ARRA G 15,246,720 25,690,048 42,762,625 66,003,893 59,544,869 106 Troy Trojans 107 Tulane Green Wave 108 Tulsa Golden Hurricane 109 UAB Blazers 110 UCF Knights 111 UCLA Bruins 112 UNLV Rebels 113 USC Trojans 114 Utah State Aggies 115 Utah Utes 116 UTEP Miners 117 UTSA Roadrunners 118 Vanderbilt Commodores 119 Virginia Cavaliers 120 Virginia Tech Hokies 121 Wake Forest Demon Deacons 122 Washington Huskies 123 Washington State Cougars 124 West Virginia Mountaineers 125 Western Kentucky Hilltoppers 126 Western Michigan Broncos 127 Wisconsin Badgers 128 Wyoming Cowboys 129 30,000 73,208 35,542 70,100 45,301 94,118 36,800 93,607 25,513 45,634 51,500 65,000 39,790 61,500 66,233 31,500 72,500 35,117 60,540 22,000 30,100 80,321 32,580 31.81 30.07 36.13 33.53 28.50 34.11 36.21 34.11 41.74 40.78 31.85 29.46 36.17 38.04 37.23 36,10 47.62 46.73 39.64 36.97 42.27 43.08 41.31 -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 -89.39 -105.58 22,777,944 38,091,538 27,694,358 16,675,632 30,640 1,014,985 800,925 326,970 127,129 2,975,615 168,560 3,517,173 208,986 668,683 174,922 81,760 3,414,514 4,760,515 600,648 1,058,250 2,154,494 722,717 392,001 114,415 198,436 1,872,933 321,781 28,322 13,359 4,092 17,575 58,587 40,675 27,378 38,810 26,657 31,660 22,640 30,968 12,836 24,927 30,936 7,351 42,428 27,327 29,617 21,036 25,086 42,441 12,925 78,439,006 66,909,557 70,231,336 39,983,482 60,451,426 22,269,484 25,627,752 96,288,191 27,577,001 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. Click on the datafile logo to reference the data. DATA file (a) Apply hierarchical clustering with 10 clusters using latitude and longitude as variables. Be sure to Normalize Input Data in Step 2 of the XL Miner Hierarchical Clustering procedure. 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 DIIIIIII 6 7 8 7 8 Jun 9 10 Choose the correct scatter plot diagrams below with longitude as the x-variable and latitude as the y-variable of single linkage method. (1) Single Linkage Clusters Lade 140 10 Longitude Write down the geographical span for the largest cluster. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (b) Compute the cluster sizes, as well as the minimum and maximum of the latitude and longitude of group average linkage meth Cluster Size Min of Latitude Max of Latitude Min of Longitude Max of Longitude Cluster Id 1 2 3 4 5 6 7 8 9 10 Choose the correct scatter plot diagrams below with longitude as the x-variable and latitude as the y-variable of group average li Compare the results of the two approaches. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank 1 School 2 Air Force Falcons 3 Akron Zips 4 Alabama Crimson Tide 5 Arizona State Sun Devils 6 Arizona Wildcats 1 Arkansas Razorbacks 3 Arkansas Sute Red Wolves 9 Amy Black Knights 10 Auburn Tigers 11 Ball State Cardinals 12 Baylor Bears 13 Bolse Sorte Broncos 14 Boston College Eagles 15 Bowling Green Falcons 16 Buffalo Bulls 17 BYU Cougars 15 California Golden Bears 19 Central Michigan Chippews 20 Charlotte 49ers 21 Cincinnati Burcats 22 Clemson Tigers 23 Colorado Buffaloes 24 Colorado State Rams 25 Connecticut Huskies 26 Duke Blue Devils 27 East Carolina Pirates 2 Eastern Michigan Eagles 29 Florida International Golden Panthers 30 Florida Atlantic Owls 31 Florida Gators 32 Florida State Seminoles 11 Fan Club Data + StadiumCapacity Latitude Longitude 52,480 38.86 -104.76 30,000 41.08 -81.52 101,821 33.24 -87.54 73,379 33.39 111.93 57,803 32.20 -110.89 76,000 36.07 -94.16 30,964 35.82 -90.69 40,000 41.36 -74.03 87.451 32.59 -85.48 22,500 40.12 -87.84 50,000 3157 -97.18 37,000 43.61 -116.23 44.500 42.34 -71.02 23,724 41.37 -83.65 29.013 42.89 -78.86 63,725 40.25 -111.64 62.717 37.87 -122 30 30,199 43.60 -84.78 15,300 35.20 -80.83 35,000 39.14 -8451 81,500 34.68 -82.81 53,750 40.03 -105.25 34,400 40.56 -105.07 40,000 41.81 -72.26 33,941 35.98 -78.91 50,000 35.60 -7737 30,200 42.24 -83.62 20,000 25.78 80.21 30,000 26.37 -80.11 92,548 29.67 .82 34 82,300 30.46 -84.28 41081 3678 .11970 AthleticRevenue (5) Endowment (5000) Enrollment 39,823,782 56,600 4,413 25,583,730 171,513 27,470 124,498,616 995,147 31,647 55,294,113 514,724 72,254 59,663,128 552,351 39,236 91,768,112 788,668 23,199 13,374,507 39,479 13,900 34,342,038 73,190 103.982,441 471,851 25,469 20,483,476 140,275 22,147 1.003.929 15.029 37,524,722 72,507 19,664 1.726,100 13,906 20,157,361 141,788 17,577 26,228,030 494,791 28,860 920,149 34,101 65,243,053 3,257,667 25.885 23,500.552 85,267 28,194 140,913 25,277 42,724,841 1,004,368 32,264 61,174,977 473,748 19.914 60,923,253 784,580 32,252 29,372,783 221.231 30.450 63,089,340 312,329 25,868 5.747,377 15,427 34,048,869 128,551 27,386 27,717,621 47.101 23,341 23,849,954 136,237 44.686 19,438,422 179,739 29.290 123,514,257 1,295,313 49,389 78,575,788 525.260 41,087 2010 ann 127991 21 OR 32 Florida State Seminoles 33 Fresno State Bulldogs 34 Georgia Bulldogs 35 Georgia State Panthers 36 Georgia Tech Yellow Jackets 37 Hawaii Warriors 3 Houston Cougars 39 Idaho Vandals 40 Mlinois Fighting Illini 41 Indiana Hoosiers 42 Towa Hawkeyes 43 Iowa State Cyclones 4 Kansas Jayhawks 45 Kansas State Wildcats 46 Kent State Golden Flashes 47 Kentucky Wildcats 48 Louisiana Tech Bulldogs 49 Louisiana Lafayette Ragio Cajuns 50 Louisiana Monroe Warhawks 51 Louisville Cardinals 52 LSU Tigers 5) Marshall Thundering Herd 34 Maryland Termins 35 Massachusetts Minutemen 56 Memphis Tigers 57 Miami Hurricanes 58 Mimi University RedHawks 19 Michigan State Spartans 60 Michigan Wolverines 61 Middle Tennessee Blue Raiders 2 Minnesota Golden Gophers Mississippi State Bulldogs Data + 92,54% 82,300 41,031 92,746 71,149 55,000 50.000 32,000 16,000 60,670 52,929 70,585 55,000 50,071 50,000 30,520 67,606 30,600 31,000 30,427 56,000 92,542 38,016 54,000 17,000 62,380 74,916 24,385 75,025 114,804 31,000 50,805 55,082 29.07 30.46 36.78 33.96 33.76 33.76 19.70 29.77 46.73 40.11 39.17 41.66 42.02 38.96 39,19 41.15 38.04 32.53 30.22 32.51 38.22 30.45 38.41 39.00 42.07 35.11 25.78 39.51 42.74 42.28 35.85 44.96 33.46 -84.28 -119,79 -83.39 -84.42 -84.42 -155.09 -95.39 -117.00 -88.26 -86.33 -91.54 -93.63 -95.26 -96.39 -81.36 -34,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 123,314,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 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 1,293,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 612,283 1,250,443 337,460 37,250 915,924 63,314 09.627 23.158 772,157 692,356 83,810 791,809 210,101 195,060 719,852 403,070 317,721 7,834,752 64,570 2,503,305 346,676 49,389 41,087 21,981 34,816 32,022 20,941 20,429 39,820 12,312 44,407 42.731 29,810 29,611 27.939 23,863 27.855 27.226 11,518 16,885 8,583 21,153 29,718 13,966 37,380 28,084 22,725 16,068 17,395 47,954 42,716 26,442 52,557 20,424 26,745,727 122,739,052 84,510,199 27,125,185 78,924,683 58,981,769 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 63 Mississippi State Bulldogs 64 Missouri Tigers 65 Navy Midshipmen 66 NC State Wolfpack 67 Nebraska Comhuskers 68 Novada Wolf Pack 6 New Mexico Lobos 70 New Mexico State Aggies 71 North Carolinn Tar Heels 72 North Texas Mean Green 73 Northern Illinois Huskies 74 Northwestem Wildcats 75 Notre Dame Fighting Irish 76 Ohio Bobcats 77 Ohio State Buckeyes 73 Oklahoma Sooners 79 Oklahoma State Cowboys 89 Old Dominion Monarchs N1 Ole Miss Rebels H2 Oregon Ducks * Oregon State Beavers 84 Penn State Nittany Lions e Pittsburgh Panthers 35 Purdue Boilermakers 87 Rice Owls 8 Rutgers Scarlet Knights 89 San Diego Site Aztecs 90 San Jose State Spartans 91 SMU Mustang 92 South Alabama Jaguars 9) South Carolina Gamecocks 94 South Florida Balls Calen Data + 55,082 71,004 34,000 57,583 81,091 33,400 40,094 30,343 62,980 30,850 30,998 49,256 80.795 24,000 102,329 82,112 60,218 19,818 60,580 53,800 45,674 107,282 65,050 62,500 70,000 52,454 70,561 30,456 32.000 40,646 80,250 65,647 33.46 38.95 38.97 35.82 40.82 39.44 35.11 32.34 35.93 33.21 41.93 42.05 41.68 39.32 39.99 35.47 35.47 36.92 34 36 44.05 45.54 40.28 40.44 40.44 29.77 40.49 32.81 37.30 32.79 30.68 34.04 27.96 -88.82 -92.33 -76.50 -78.66 -96.69 -119.75 -106,61 -106.76 - 29.04 -97.13 -88.75 -87.69 -86.27 -$2.10 -82.99 -97.51 -97.51 - 76.24 -89.53 -123.11 -122.66 - 76.88 -79.98 -86.91 -95.39 - 74.45 -117.14 -121.85 -96.77 -88.09 -80.89 -82.48 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 346,676 1,119,032 89,780 617,632 1,241,577 235,404 349,145 186,737 2,260,970 110,735 49,890 7,182,745 6,259,598 336,000 2,120,714 1,212,023 681,744 170,176 469,006 467,211 411,964 1,725,138 2,527,398 2,001,601 4,451,452 698,507 135,191 73,100 1,196,508 283,496 494,358 349,320 COTA 20,424 33,805 4,576 34,767 24,593 18,004 28,977 18,024 29,137 35,574 22,990 19,968 12,004 26,201 56,867 30,743 24,231 24,753 18,224 24,936 24,977 45,628 28,766 39,637 6,224 39,950 31,303 30,236 10,982 14,769 30,721 39,596 66,202,493 60,190,100 45,201,703 18,861,113 17,432,045 83,813,226 41,948,123 0021 41,948,123 6,799,370 104,368,992 87,296,532 150,295,926 21,741,489 59,334,893 19,485,449 15,246,720 94 South Florida Bulls 95 Southern Miss Golden Eagles 96 Stanford Cardinal 97 Syracuse Orange 98 TCU Home Frogs 99 Temple Owls 100 Tennessee Volunteers 101 Texas A&M Aggies 102 Texas Longhorns 103 Texas State Bobcats 104 Texas Tech Red Raiders 105 Toledo Rockets 105 Troy Trojans 107 Tulane Green Wave 108 Tulsa Golden Hurricane 109 UAB Blazers 110 UCF Knights 1 UCLA Bruins 112 UNLV Rebels 113 USC Trojans 114 Utah State Aggles 115 Utah Utes 116 UTEP Miners 117 UTSA Roadrunners 118 Vanderbilt Commodores 119 Virginia Cavaliers 120 Virginia Tech Hokies 121 Wake Forest Demon Descons 122 Washington Huskies 123 Washington State Cougars 124 West Virginia Mountaineers 125 Western Kentucky Hillhoppers Data + 65,647 36,000 50,000 49,262 45,000 68,532 102,455 82,600 101,624 30,000 60,454 26,248 30,000 73.208 35,542 70.100 45,301 94,118 36,800 93,607 25,513 45,634 51,500 65,000 39,790 61,500 66,233 31,500 72,500 35,117 60,540 22,000 27.96 31.31 37.42 43.04 32.75 40.01 35.97 30.63 30.31 29.88 29.70 41.66 31.81 30.07 36.13 33.53 28.50 34.11 36.21 34.11 41.74 40.78 31.85 29.46 36.17 38.04 37.23 36.10 47.62 46.73 39.64 36.97 -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 25,690,048 42,762,625 66,003,893 59,544,869 349,320 58,745 16,502,606 913,662 1,191,900 280,731 848,329 358,946 2,852,959 119,711 890,930 197,374 30,640 1,014,985 800.925 326,970 127,129 2,975,615 168,560 3,517,173 208.986 668,683 174,922 81.760 3,414,514 4,760,515 600.648 1,058,250 2,154,494 722,717 392,001 114,415 39,596 11,604 19,945 20,829 9,518 36,855 30,194 49,861 38,437 34,087 32,327 22,610 28,322 13,359 4,092 17,575 58,587 40,675 27,378 38,810 26,657 31,660 22,640 30,968 12,836 24.927 30,936 7,351 42,428 27,327 29,617 21,036 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 ARRA G 15,246,720 25,690,048 42,762,625 66,003,893 59,544,869 106 Troy Trojans 107 Tulane Green Wave 108 Tulsa Golden Hurricane 109 UAB Blazers 110 UCF Knights 111 UCLA Bruins 112 UNLV Rebels 113 USC Trojans 114 Utah State Aggies 115 Utah Utes 116 UTEP Miners 117 UTSA Roadrunners 118 Vanderbilt Commodores 119 Virginia Cavaliers 120 Virginia Tech Hokies 121 Wake Forest Demon Deacons 122 Washington Huskies 123 Washington State Cougars 124 West Virginia Mountaineers 125 Western Kentucky Hilltoppers 126 Western Michigan Broncos 127 Wisconsin Badgers 128 Wyoming Cowboys 129 30,000 73,208 35,542 70,100 45,301 94,118 36,800 93,607 25,513 45,634 51,500 65,000 39,790 61,500 66,233 31,500 72,500 35,117 60,540 22,000 30,100 80,321 32,580 31.81 30.07 36.13 33.53 28.50 34.11 36.21 34.11 41.74 40.78 31.85 29.46 36.17 38.04 37.23 36,10 47.62 46.73 39.64 36.97 42.27 43.08 41.31 -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 -89.39 -105.58 22,777,944 38,091,538 27,694,358 16,675,632 30,640 1,014,985 800,925 326,970 127,129 2,975,615 168,560 3,517,173 208,986 668,683 174,922 81,760 3,414,514 4,760,515 600,648 1,058,250 2,154,494 722,717 392,001 114,415 198,436 1,872,933 321,781 28,322 13,359 4,092 17,575 58,587 40,675 27,378 38,810 26,657 31,660 22,640 30,968 12,836 24,927 30,936 7,351 42,428 27,327 29,617 21,036 25,086 42,441 12,925 78,439,006 66,909,557 70,231,336 39,983,482 60,451,426 22,269,484 25,627,752 96,288,191 27,577,001 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. Click on the datafile logo to reference the data. DATA file (a) Apply hierarchical clustering with 10 clusters using latitude and longitude as variables. Be sure to Normalize Input Data in Step 2 of the XL Miner Hierarchical Clustering procedure. 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 DIIIIIII 6 7 8 7 8 Jun 9 10 Choose the correct scatter plot diagrams below with longitude as the x-variable and latitude as the y-variable of single linkage method. (1) Single Linkage Clusters Lade 140 10 Longitude Write down the geographical span for the largest cluster. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (b) Compute the cluster sizes, as well as the minimum and maximum of the latitude and longitude of group average linkage meth Cluster Size Min of Latitude Max of Latitude Min of Longitude Max of Longitude Cluster Id 1 2 3 4 5 6 7 8 9 10 Choose the correct scatter plot diagrams below with longitude as the x-variable and latitude as the y-variable of group average li Compare the results of the two approaches. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank