do test only use techniqes found in files

profileroberto pulpo
CollegesandUniversitiesClusterAnalysisWorksheetNov5.xlsx
Home>Business & Finance homework help>Accounting homework help>do test only use techniqes found in files

Raw data

Colleges and Universities
School Type Median SAT Acceptance Rate Expenditures/Student Top 10% HS Graduation %
Amherst Lib Arts 1315 22% $ 26,636 85 93
Barnard Lib Arts 1220 53% $ 17,653 69 80 Euclidian distance
Bates Lib Arts 1240 36% $ 17,554 58 88
Berkeley University 1176 37% $ 23,665 95 68
Bowdoin Lib Arts 1300 24% $ 25,703 78 90
Brown University 1281 24% $ 24,201 80 90
Bryn Mawr Lib Arts 1255 56% $ 18,847 70 84 1 5 6.4031242374
Cal Tech University 1400 31% $ 102,262 98 75 6 9
Carleton Lib Arts 1300 40% $ 15,904 75 80
Carnegie Mellon University 1225 64% $ 33,607 52 77
Claremont McKenna Lib Arts 1260 36% $ 20,377 68 74 normalizing data Z = (x-μ)/σ
Colby Lib Arts 1200 46% $ 18,872 52 84
Colgate Lib Arts 1258 38% $ 17,520 61 85 mean (SAT) 1263.1020408163
Columbia University 1268 29% $ 45,879 78 90 st dev 62.6764990839
Cornell University 1280 30% $ 37,137 85 83 z -1.0067894943
Davisdson Lib Arts 1230 36% $ 17,721 77 89
Duke University 1310 25% $ 39,504 91 91
Georgetown University 1278 24% $ 23,115 79 89
Grinnell Lib Arts 1244 67% $ 22,301 65 73
Hamilton Lib Arts 1215 38% $ 20,722 51 85
Harvard University 1370 18% $ 46,918 90 90
Haverford Lib Arts 1285 35% $ 19,418 71 87
Johns Hopkins University 1290 48% $ 45,460 69 86
Middlebury Lib Arts 1255 25% $ 24,718 65 92
MIT University 1357 30% $ 56,766 95 86
Mount Holyoke Lib Arts 1200 61% $ 23,358 47 83
Northwestern University 1230 47% $ 28,851 77 82
Oberlin Lib Arts 1247 54% $ 23,591 64 77
Occidental Lib Arts 1170 49% $ 20,192 54 72
Pomona Lib Arts 1320 33% $ 26,668 79 80
Princeton University 1340 17% $ 48,123 89 93
Rice University 1327 24% $ 26,730 85 88
Smith Lib Arts 1195 57% $ 25,271 65 87
Stanford University 1370 18% $ 61,921 92 88
Swarthnore Lib Arts 1310 24% $ 27,487 78 88
U Michigan University 1195 60% $ 21,853 71 77
U of Chicago University 1300 45% $ 38,937 74 73
U of Rochester University 1155 56% $ 38,597 52 73
U Pennsylvania University 1280 41% $ 30,882 87 86
U Va University 1218 37% $ 19,365 77 88
UCLA University 1142 43% $ 26,859 96 61
UNC University 1109 32% $ 19,684 82 73
Vassar Lib Arts 1287 43% $ 20,179 53 84
Washington U (MO) University 1225 54% $ 39,883 71 76
Washinton and Lee Lib Arts 1234 29% $ 17,998 61 78
Wellesley Lib Arts 1250 49% $ 27,879 76 86
Wesleyan (CT) Lib Arts 1290 35% $ 19,948 73 91
Williams Lib Arts 1336 28% $ 23,772 86 93
Yale University 1350 19% $ 52,468 90 93

Normalized data

Normalized Data
School Type Median SAT Acceptance Rate (%) Expenditures/Student Top 10% HS Graduation % Amherst Barnard Bates Berkeley Bowdoin
Amherst Lib Arts 0.8280290052 -1.2041896607 -0.2214485079 0.7966997726 1.3096699405 Amherst 0 3.528429241 2.7006876027 4.2454058294 0.7157907639
Barnard Lib Arts -0.6876906248 1.1141425251 -0.8023720643 -0.3840424234 -0.4356433484 Barnard 0 1.8790140078 2.8901006639 2.9744381066
Bates Lib Arts -0.3685917553 -0.1572009316 -0.8087743166 -1.1958026832 0.6383955986 Bates 0 3.9836721315 2.061542031
Berkeley University -1.3897081377 -0.0824160224 -0.413580745 1.5346636451 -2.046701769 Berkeley 0 3.8954242852
Bowdoin Lib Arts 0.5887048531 -1.0546198423 -0.2817848853 0.2801250618 0.9069053354 Bowdoin 0
Brown University 0.2855609271 -1.0546198423 -0.3789180459 0.4277178363 0.9069053354
Bryn Mawr Lib Arts -0.1292676032 1.3384972528 -0.7251570218 -0.3102460362 0.1013761251
Cal Tech University 2.1841992004 -0.5311254777 4.6692255293 1.7560528068 -1.1069176903 Amherst/Bowdoin Barnard Bates Berkeley
Carleton Lib Arts 0.5887048531 0.1419387053 -0.9154785209 0.0587359001 -0.4356433484 Amherst/Bowdoin 0 2.9744381066 2.061542031 3.8954242852
Carnegie Mellon University -0.6079159074 1.9367765266 0.2293605884 -1.6385810067 -0.8384079536 Barnard 0 1.8790140078 2.8901006639
Claremont McKenna Lib Arts -0.0494928859 -0.1572009316 -0.6262131232 -0.4578388107 -1.2411725587 Bates 0 3.9836721315
Colby Lib Arts -1.0067894943 0.5906481606 -0.7235402915 -1.6385810067 0.1013761251 Berkeley 0
Colgate Lib Arts -0.0814027728 -0.0076311132 -0.8109730699 -0.9744135215 0.2356309935
Columbia University 0.0781466619 -0.6806952962 1.0229811922 0.2801250618 0.9069053354
Cornell University 0.2696059836 -0.605910387 0.4576429165 0.7966997726 -0.0328787433
Davisdson Lib Arts -0.5281411901 -0.1572009316 -0.7979745577 0.2063286746 0.772650467 Amherst/Bowdoin Barnard/Bates Berkeley
Duke University 0.7482542878 -0.9798349331 0.6107149479 1.2394780961 1.0411602038 Amherst/Bowdoin 0 2.061542031 3.8954242852
Georgetown University 0.2376960966 -1.0546198423 -0.4491488131 0.3539214491 0.772650467 Barnard/Bates 0 2.8901006639
Grinnell Lib Arts -0.3047719815 2.1611312542 -0.501789554 -0.6792279725 -1.3754274271 Berkeley 0
Hamilton Lib Arts -0.7674653422 -0.0076311132 -0.6039022441 -1.712377394 0.2356309935
Harvard University 1.7055508962 -1.5033292976 1.0901725063 1.1656817088 0.9069053354
Haverford Lib Arts 0.349380701 -0.2319858408 -0.6882309002 -0.2364496489 0.5041407302
Johns Hopkins University 0.4291554183 0.740217979 0.9958847912 -0.3840424234 0.3698858619
Middlebury Lib Arts -0.1292676032 -0.9798349331 -0.3454840619 -0.6792279725 1.1754150721
MIT University 1.4981366311 -0.605910387 1.7270349335 1.5346636451 0.3698858619
Mount Holyoke Lib Arts -1.0067894943 1.7124217989 -0.433434194 -2.007562943 -0.0328787433
Northwestern University -0.5281411901 0.6654330698 -0.0782061972 0.2063286746 -0.1671336117
Oberlin Lib Arts -0.256907151 1.1889274343 -0.4183662669 -0.7530243597 -0.8384079536
Occidental Lib Arts -1.4854377985 0.8150028882 -0.638176928 -1.4909882322 -1.5096822954
Pomona Lib Arts 0.9078037225 -0.3815556593 -0.219379093 0.3539214491 -0.4356433484
Princeton University 1.226902592 -1.5781142068 1.1680989102 1.0918853216 1.3096699405
Rice University 1.0194883268 -1.0546198423 -0.2153696017 0.7966997726 0.6383955986
Smith Lib Arts -1.0865642117 1.413282162 -0.3097219861 -0.6792279725 0.5041407302
Stanford University 1.7055508962 -1.5033292976 2.0604047357 1.3132744833 0.6383955986
Swarthnore Lib Arts 0.7482542878 -1.0546198423 -0.1664150061 0.2801250618 0.6383955986
U Michigan University -1.0865642117 1.6376368897 -0.5307613622 -0.2364496489 -0.8384079536
U of Chicago University 0.5887048531 0.5158632514 0.5740475032 -0.0150604872 -1.3754274271
U of Rochester University -1.7247619506 1.3384972528 0.5520599701 -1.6385810067 -1.3754274271
U Pennsylvania University 0.2696059836 0.2167236145 0.0531369781 0.9442925471 0.3698858619
U Va University -0.7196005118 -0.0824160224 -0.6916583686 0.2063286746 0.6383955986
UCLA University -1.9321762157 0.3662934329 -0.207027273 1.6084600323 -2.9864858476
UNC University -2.4586893504 -0.4563405685 -0.6710288891 0.5753106108 -1.3754274271
Vassar Lib Arts 0.3812905879 0.3662934329 -0.6390176278 -1.5647846195 0.1013761251
Washington U (MO) University -0.6079159074 1.1889274343 0.6352245803 -0.2364496489 -0.9726628219
Washinton and Lee Lib Arts -0.4643214162 -0.6806952962 -0.7800611852 -0.9744135215 -0.7041530852
Wellesley Lib Arts -0.2090423206 0.8150028882 -0.1410646739 0.1325322873 0.3698858619
Wesleyan (CT) Lib Arts 0.4291554183 -0.2319858408 -0.6539562164 -0.0888568744 1.0411602038
Williams Lib Arts 1.1630828181 -0.7554802054 -0.406661139 0.8704961598 1.3096699405
Yale University 1.3864520267 -1.4285443884 1.4490866484 1.1656817088 1.3096699405

2 clusters 1) Amherst, Bowdoin, Barnard, Bates 2) Berkely

image1.png