Can someone help me answer the questions at the bottom? And maybe explain how you got it? I feel like my answers are wrong. the data set is provided right below. thank you so much!

2 3 School 4 5 6 7 8 St. Ambrose C (NC) Albion College (Albion, MI) Alfred University (Alfred, NY) Allegheny College (Meadville, PA) Beloit College (Beloit, WI) Bentley University (Waltham, MA) Boston University (Boston, MA) California Lutheran University (Thousand Oaks, CA) Carroll College (Helena, MT) 9 10 11 12 13 14 15 16 Catholic University of America (Washington, DC) Cedar Crest College (Allentown, PA) Champlain College (Burlington, VT) Chapman University (Orange, CA) Clark University (Worcester, MA) Colby-Sawyer College (New London, NH) College of Mount St. Vincent (Riverdale, NY) College of St. Benedict (St. Joseph, MN) 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Davis & Elkins College (Elkins, WV) DeSales University (Center Valley, PA) Dickinson College (Carlisle, PA) Doane College (Crete, NE) Dominican University (River Forest, IL) Drew University (Madison, NJ) Drexel University (Philadelphia, PA) Earlham College (Richmond, IN) Eckerd College (St. Petersburg, FL) Elmhurst College (Elmhurst, IL) Elmira College (Elmira, NY) Elon University (Elon, NC) Endicott College (Beverly, MA) Florida Southern College (Lakeland, FL) Fort Lewis College (Durango, CO) Franklin Pierce University (Rindge, NH) Fresno Pacific University (Fresno, CA) George Fox University (Newberg, OR) Gonzaga University (Spokane, WA) Goucher College (Baltimore, MD) Gustavus Adolphus College (St. Peter, MN) Hawaii Pacific University (Honolulu, HI) Hendrix College (Conway, AR) Hobart and William Smith Colleges (Geneva, NY) 33 34 35 36 37 38 39 40 41 42 43 44 45 Hollins University (Roanoke, VA) 46 Ithaca College (Ithaca, NY) 47 Johnson & Wales University at Denver (Denver, CO) 48 49 50 51 Juniata College (Huntingdon, PA) Kalamazoo College (Kalamazoo, MI) Lake Forest College (Lake Forest, IL) Lasell College (Newton, MA) Lesley University (Cambridge, MA) Lewis and Clark College (Portland, OR) Linfield College (McMinnville, OR) 55 Island University - C.W. Post Campus (Brookville, NY) Loyola University New Orleans (New Orleans, LA) 52 53 54 56 57 Lycoming College (Williamsport, PA) 58 59 Lynn University (Boca Raton, FL) Marietta College (Marietta, OH) McDaniel College (Westminster, MD) 60 61 Menlo College (Atherton, CA) Meredith College (Raleigh, NC) 62 63 64 65 66 67 Mills College (Oakland, CA) Monmouth College (Monmouth, IL) Moravian College (Bethlehem, PA) Nazareth College of Rochester (Rochester, NY) Nebraska Wesleyan University (Lincoln, NE) New England College (Henniker, NH) Niagara University (Niagara University, NY) Oglethorpe University (Atlanta, GA) Otterbein University (Westerville, OH) 68 69 70 71 Earnings Grad Cost Debt 62 22920 88 44800 45100 73 23429 92 42300 19567 87 49200 63 78 78 25147 92 37900 21979 93 74900 86 29886 98 84 34603 95 90 65 28107 65 23583 95 92 68 34086 61 19156 83 31564 89 87 60600 52900 44000 54500 45200 40400 51800 44100 38600 51900 47600 35900 48300 52100 42300 62 74 33821 80 56 23415 94 88 22644 54 19647 85 98 71 81 23518 43 16575 69 27080 85 29678 90 95 21713 90 44400 62 65 69 13902 86 27652 93 67 33742 90 19414 96 81 91 71 63 29864 74 19466 60 83 72 22787 89 31898 96 31810 96 50900 61100 32300 40800 48100 43600 44500 42800 37600 34000 38000 39700 43300 52800 45500 50100 43400 57 21558 82 77 88 37 14398 47 24266 57 15403 63 24402 81 92 82 28155 95 91 67 83 24246 23162 95 20967 87 40500 87 40 71 22231 78 30720 58 20252 95 80 76 31958 96 80 96 93 93 88 86 96 93 74 83 90 48600 37000 50400 35100 54 24423 45200 75 24614 49400 79 21531 48100 67 23921 40900 49 25316 36700 46 32534 43400 75 32636 51300 68 24893 46000 41 25613 41300 57 21546 42800 64 21127 35500 41 33074 42600 59 22473 44600 50600 38400 39000 40700 50000 43900 45500 35600 44000 43900 41200 76 89 73 20675 95 78 87 81 38 25918 61 22275 62 25539 58 15685 89 74 24730 91 70 25936 67 22204 41 28458 93 93 78 87 79 66 17437 59 19721 59 24850 86 City 1 0 0 0 1 1 1 1 0 1 1 1 1 1 0 1 0 0 0 1 0 0 0 1 0 1 0 1 0 0 1 0 0 1 0 1 1 0 1 1 0 0 0 1 0 1 0 1 1 1 0 0 1 1 1 0 0 0 0 000 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 A Monmouth College (Monmouth, IL) Moravian College (Bethlehem, PA) Nazareth College of Rochester (Rochester, NY) Nebraska Wesleyan University (Lincoln, NE) New England College (Henniker, NH) Niagara University (Niagara University, NY) Oglethorpe University (Atlanta, GA) Otterbein University (Westerville, OH) Pace University (New York, NY) Pacific Lutheran University (Tacoma, WA) Pine Manor College (Chestnut Hill, MA) Providence College (Providence, RI) Quinnipiac University (Hamden, CT) Regis University (Denver, CO) Rhode Island College (Providence, RI) Rider University (Lawrenceville, NJ) Ripon College (Ripon, WI) Roanoke College (Salem, VA) Roger Williams University (Bristol, RI) Rollins College (Winter Park, FL) Saint Francis University (Loretto, PA) Seattle University (Seattle, WA) Simmons College (Boston, MA) Spelman College (Atlanta, GA) Springfield College (Springfield, MA) Stetson University Ideland, FL) Suffolk University (Boston, MA) Susquehanna University (Selinsgrove, PA) Syracuse University (Syracuse, NY) Temple University (Philadelphia, PA) The College of Idaho (Caldwell, ID) The College of Wooster (Wooster, OH) The George Washington University (Washington, DC) The University of Tulsa (Tulsa, OK) Trinity University (San Antonio, TX) University of Denver (Denver, CO) University of Hartford (West Hartford, CT) University of Miami (Coral Gables, FL) University of Puget Sound (Tacoma, WA) University of Redlands (Redlands, CA) University of Rochester (Rochester, NY) University of San Diego (San Diego, CA) University of San Francisco (San Francisco, CA) University of Tampa (Tampa, FL) University of the Pacific (Stockton, CA) Wartburg College (Waverly, IA) Washington & Jefferson College (Washington, PA) Washington College (Chestertown, MD) Wells College (Aurora, NY) West Virginia Wesleyan College (Buckhannon, WV) Western New England University (Springfield, MA) Whittier College (Whittier, CA) Widener University (Chester, PA) Willamette University (Salem, OR) Winthrop University (Rock Hill, SC) Wittenberg University (Springfield, OH) B 40700 50000 43900 45500 35600 44000 43900 41200 58400 45900 34700 59600 56400 53100 39600 48100 42800 42500 47200 42200 46900 55200 51400 46400 45100 42600 49900 50000 56600 46500 38900 44400 64500 43200 53200 51400 45900 52400 51500 53800 55500 56300 61000 44400 66400 43200 49900 48300 33600 43100 55100 45100 51700 49200 36100 42700 D 15685 24730 25936 22204 28458 66 17437 59 19721 24850 59 53 70 24961 23486 32 13735 34841 86 76 35159 21046 58 43 9938 67 28210 73 19254 65 26451 62 33838 69 29427 22593 68 77 33557 29085 69 70 31293 27674 67 64 56 27507 21815 75 24954 81 28912 66 20845 65 16681 75 21455 80 30206 25702 67 81 22389 77 29362 55 29140 81 30394 78 32115 72 25057 85 26608 75 31593 68 31915 27955 30318 59 57 64 76 26491 22124 69 30255 57 19739 59 18292 61 28517 67 33181 56 27387 78 30312 54 15311 64 26616 58 47011 67 E 89 91 93 93 78 87 79 86 86 93 52 96 96 85 84 89 90 89 93 83 90 92 93 67 80 86 84 95 93 86 90 91 95 87 96 92 86 90 94 91 93 92 87 87 89 90 93 92 86 82 92 86 83 93 76 90 F 0 1 0 1 0 0 0 0 1 0 0 1 0 1 0 0 0 0 0 0 0 1 1 1 1 0 1 0 1 1 0 0 1 1 1 1 1 0 1 1 1 1 1 1 1 0 0 0 0 0 1 0 0 1 1 1 G Cluster the Colleges data using the following variables: earnings, grad, cost, and debt. Use hierarchical clustering normalized data, Euclidean distance, and group average linkage. Create 4 clusters. How many colleges are in cluster 1? 106 QUESTION 13 How many colleges are in cluster 2? 8 QUESTION 14 How many colleges are in cluster 3? 3 QUESTION 15 How many colleges are in cluster 4? 8 QUESTION 16 Examine the dendrogram for the Colleges data. Which of the following values of kare viable for these data? 02 3 04 05 QUESTION 17 Now recluster the Colleges data using the same hierarchical clustering settings, but with k = 5. Examine the number of schools in each group for this analysis. Based on the results, and comparing the number of schools per cluster to your results for k = 4, are 4 or 5 groups more appropriate for these data? 4 5 It does not matter