Please help me! I need to figure this problem out! I don't understand it at all! For
Fantastic news! We've Found the answer you've been seeking!
Question:
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 |
Posted Date: