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
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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
