Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me! I need to figure this problem out! I don't understand it at all! For the Excel file Colleges and Universities Cluster Analysis
Please help me! I need to figure this problem out! I don't understand it at all!
For the Excel file Colleges and Universities Cluster Analysis Worksheet, compute the normalized Euclidean distances between Berkeley, Cal Tech, UCLA, and UNC, and illustrate the results in a distance matrix. | |||||||||||||||||||||||
Normalized Data | Distance Matrix (first five) | ||||||||||||||||||||||
School | Type | Median SAT | Acceptance Rate (%) | Expenditures/Student | Top 10% HS | Graduation % | School | Type | Median SAT | Acceptance Rate (%) | Expenditures/Student | Top 10% HS | Graduation % | Amherst | Barnard | Bates | Berkeley | Bowdoin | |||||
Amherst | Lib Arts | 1315 | 22% | $26,636.00 | 85 | 93 | Amherst | Lib Arts | 0.8280 | -1.2042 | -0.2214 | 0.7967 | 1.3097 | Amherst | 0 | 3.528429241 | 2.7006876 | 4.24540583 | 0.71579076 | ||||
Barnard | Lib Arts | 1220 | 53% | $17,653.00 | 69 | 80 | Barnard | Lib Arts | -0.6877 | 1.1141 | -0.8024 | -0.3840 | -0.4356 | Barnard | 0 | 1.87901401 | 2.89010066 | 2.97443811 | |||||
Bates | Lib Arts | 1240 | 36% | $17,554.00 | 58 | 88 | Bates | Lib Arts | -0.3686 | -0.1572 | -0.8088 | -1.1958 | 0.6384 | Bates | 0 | 3.98367213 | 2.06154203 | ||||||
Berkeley | University | 1176 | 37% | $23,665.00 | 95 | 68 | Berkeley | University | -1.3897 | -0.0824 | -0.4136 | 1.5347 | -2.0467 | Berkeley | 0 | 3.89542429 | |||||||
Bowdoin | Lib Arts | 1300 | 24% | $25,703.00 | 78 | 90 | Bowdoin | Lib Arts | 0.5887 | -1.0546 | -0.2818 | 0.2801 | 0.9069 | Bowdoin | 0 | ||||||||
Brown | University | 1281 | 24% | $24,201.00 | 80 | 90 | Brown | University | 0.2856 | -1.0546 | -0.3789 | 0.4277 | 0.9069 | ||||||||||
Bryn Mawr | Lib Arts | 1255 | 56% | $18,847.00 | 70 | 84 | Bryn Mawr | Lib Arts | -0.1293 | 1.3385 | -0.7252 | -0.3102 | 0.1014 | ||||||||||
Cal Tech | University | 1400 | 31% | $102,262.00 | 98 | 75 | Cal Tech | University | 2.1842 | -0.5311 | 4.6692 | 1.7561 | -1.1069 | ||||||||||
Carleton | Lib Arts | 1300 | 40% | $15,904.00 | 75 | 80 | Carleton | Lib Arts | 0.5887 | 0.1419 | -0.9155 | 0.0587 | -0.4356 | ||||||||||
Carnegie Mellon | University | 1225 | 64% | $33,607.00 | 52 | 77 | Carnegie Mellon | University | -0.6079 | 1.9368 | 0.2294 | -1.6386 | -0.8384 | ||||||||||
Claremont McKenna | Lib Arts | 1260 | 36% | $20,377.00 | 68 | 74 | Claremont McKenna | Lib Arts | -0.0495 | -0.1572 | -0.6262 | -0.4578 | -1.2412 | ||||||||||
Colby | Lib Arts | 1200 | 46% | $18,872.00 | 52 | 84 | Colby | Lib Arts | -1.0068 | 0.5906 | -0.7235 | -1.6386 | 0.1014 | ||||||||||
Colgate | Lib Arts | 1258 | 38% | $17,520.00 | 61 | 85 | Colgate | Lib Arts | -0.0814 | -0.0076 | -0.8110 | -0.9744 | 0.2356 | ||||||||||
Columbia | University | 1268 | 29% | $45,879.00 | 78 | 90 | Columbia | University | 0.0781 | -0.6807 | 1.0230 | 0.2801 | 0.9069 | ||||||||||
Cornell | University | 1280 | 30% | $37,137.00 | 85 | 83 | Cornell | University | 0.2696 | -0.6059 | 0.4576 | 0.7967 | -0.0329 | ||||||||||
Davisdson | Lib Arts | 1230 | 36% | $17,721.00 | 77 | 89 | Davisdson | Lib Arts | -0.5281 | -0.1572 | -0.7980 | 0.2063 | 0.7727 | ||||||||||
Duke | University | 1310 | 25% | $39,504.00 | 91 | 91 | Duke | University | 0.7483 | -0.9798 | 0.6107 | 1.2395 | 1.0412 | ||||||||||
Georgetown | University | 1278 | 24% | $23,115.00 | 79 | 89 | Georgetown | University | 0.2377 | -1.0546 | -0.4491 | 0.3539 | 0.7727 | ||||||||||
Grinnell | Lib Arts | 1244 | 67% | $22,301.00 | 65 | 73 | Grinnell | Lib Arts | -0.3048 | 2.1611 | -0.5018 | -0.6792 | -1.3754 | ||||||||||
Hamilton | Lib Arts | 1215 | 38% | $20,722.00 | 51 | 85 | Hamilton | Lib Arts | -0.7675 | -0.0076 | -0.6039 | -1.7124 | 0.2356 | ||||||||||
Harvard | University | 1370 | 18% | $46,918.00 | 90 | 90 | Harvard | University | 1.7056 | -1.5033 | 1.0902 | 1.1657 | 0.9069 | ||||||||||
Haverford | Lib Arts | 1285 | 35% | $19,418.00 | 71 | 87 | Haverford | Lib Arts | 0.3494 | -0.2320 | -0.6882 | -0.2364 | 0.5041 | ||||||||||
Johns Hopkins | University | 1290 | 48% | $45,460.00 | 69 | 86 | Johns Hopkins | University | 0.4292 | 0.7402 | 0.9959 | -0.3840 | 0.3699 | ||||||||||
Middlebury | Lib Arts | 1255 | 25% | $24,718.00 | 65 | 92 | Middlebury | Lib Arts | -0.1293 | -0.9798 | -0.3455 | -0.6792 | 1.1754 | ||||||||||
MIT | University | 1357 | 30% | $56,766.00 | 95 | 86 | MIT | University | 1.4981 | -0.6059 | 1.7270 | 1.5347 | 0.3699 | ||||||||||
Mount Holyoke | Lib Arts | 1200 | 61% | $23,358.00 | 47 | 83 | Mount Holyoke | Lib Arts | -1.0068 | 1.7124 | -0.4334 | -2.0076 | -0.0329 | ||||||||||
Northwestern | University | 1230 | 47% | $28,851.00 | 77 | 82 | Northwestern | University | -0.5281 | 0.6654 | -0.0782 | 0.2063 | -0.1671 | ||||||||||
Oberlin | Lib Arts | 1247 | 54% | $23,591.00 | 64 | 77 | Oberlin | Lib Arts | -0.2569 | 1.1889 | -0.4184 | -0.7530 | -0.8384 | ||||||||||
Occidental | Lib Arts | 1170 | 49% | $20,192.00 | 54 | 72 | Occidental | Lib Arts | -1.4854 | 0.8150 | -0.6382 | -1.4910 | -1.5097 | ||||||||||
Pomona | Lib Arts | 1320 | 33% | $26,668.00 | 79 | 80 | Pomona | Lib Arts | 0.9078 | -0.3816 | -0.2194 | 0.3539 | -0.4356 | ||||||||||
Princeton | University | 1340 | 17% | $48,123.00 | 89 | 93 | Princeton | University | 1.2269 | -1.5781 | 1.1681 | 1.0919 | 1.3097 | ||||||||||
Rice | University | 1327 | 24% | $26,730.00 | 85 | 88 | Rice | University | 1.0195 | -1.0546 | -0.2154 | 0.7967 | 0.6384 | ||||||||||
Smith | Lib Arts | 1195 | 57% | $25,271.00 | 65 | 87 | Smith | Lib Arts | -1.0866 | 1.4133 | -0.3097 | -0.6792 | 0.5041 | ||||||||||
Stanford | University | 1370 | 18% | $61,921.00 | 92 | 88 | Stanford | University | 1.7056 | -1.5033 | 2.0604 | 1.3133 | 0.6384 | ||||||||||
Swarthnore | Lib Arts | 1310 | 24% | $27,487.00 | 78 | 88 | Swarthnore | Lib Arts | 0.7483 | -1.0546 | -0.1664 | 0.2801 | 0.6384 | ||||||||||
U Michigan | University | 1195 | 60% | $21,853.00 | 71 | 77 | U Michigan | University | -1.0866 | 1.6376 | -0.5308 | -0.2364 | -0.8384 | ||||||||||
U of Chicago | University | 1300 | 45% | $38,937.00 | 74 | 73 | U of Chicago | University | 0.5887 | 0.5159 | 0.5740 | -0.0151 | -1.3754 | ||||||||||
U of Rochester | University | 1155 | 56% | $38,597.00 | 52 | 73 | U of Rochester | University | -1.7248 | 1.3385 | 0.5521 | -1.6386 | -1.3754 | ||||||||||
U Pennsylvania | University | 1280 | 41% | $30,882.00 | 87 | 86 | U Pennsylvania | University | 0.2696 | 0.2167 | 0.0531 | 0.9443 | 0.3699 | ||||||||||
U Va | University | 1218 | 37% | $19,365.00 | 77 | 88 | U Va | University | -0.7196 | -0.0824 | -0.6917 | 0.2063 | 0.6384 | ||||||||||
UCLA | University | 1142 | 43% | $26,859.00 | 96 | 61 | UCLA | University | -1.9322 | 0.3663 | -0.2070 | 1.6085 | -2.9865 | ||||||||||
UNC | University | 1109 | 32% | $19,684.00 | 82 | 73 | UNC | University | -2.4587 | -0.4563 | -0.6710 | 0.5753 | -1.3754 | ||||||||||
Vassar | Lib Arts | 1287 | 43% | $20,179.00 | 53 | 84 | Vassar | Lib Arts | 0.3813 | 0.3663 | -0.6390 | -1.5648 | 0.1014 | ||||||||||
Washington U (MO) | University | 1225 | 54% | $39,883.00 | 71 | 76 | Washington U (MO) | University | -0.6079 | 1.1889 | 0.6352 | -0.2364 | -0.9727 | ||||||||||
Washinton and Lee | Lib Arts | 1234 | 29% | $17,998.00 | 61 | 78 | Washinton and Lee | Lib Arts | -0.4643 | -0.6807 | -0.7801 | -0.9744 | -0.7042 | ||||||||||
Wellesley | Lib Arts | 1250 | 49% | $27,879.00 | 76 | 86 | Wellesley | Lib Arts | -0.2090 | 0.8150 | -0.1411 | 0.1325 | 0.3699 | ||||||||||
Wesleyan (CT) | Lib Arts | 1290 | 35% | $19,948.00 | 73 | 91 | Wesleyan (CT) | Lib Arts | 0.4292 | -0.2320 | -0.6540 | -0.0889 | 1.0412 | ||||||||||
Williams | Lib Arts | 1336 | 28% | $23,772.00 | 86 | 93 | Williams | Lib Arts | 1.1631 | -0.7555 | -0.4067 | 0.8705 | 1.3097 | ||||||||||
Yale | University | 1350 | 19% | $52,468.00 | 90 | 93 | Yale | University | 1.3865 | -1.4285 | 1.4491 | 1.1657 | 1.3097 | ||||||||||
Mean | 1263.10 | 0.38 | 30060.33 | 74.20 | 83.24 | ||||||||||||||||||
Std Dev | 62.68 | 0.13 | 15463.31 | 13.55 | 7.45 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started