Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Macroeconomics

Authors: Paul Krugman, Robin Wells, Iris Au, Jack Parkinson

3rd Canadian edition

1319120083, 1319120085, 1319190111, 9781319190118, 978-1319120054

More Books

Students also viewed these Economics questions

Question

What is CDMA?

Answered: 1 week ago

Question

Explain and criticize the JamesLange theory of emotion.

Answered: 1 week ago