SPSS part 4

profileee2939
1571686989176_excelspss.xlsx

Sheet1

Sr. NO Name College enrollment (Y) X1 = Average Annual Cost X2 = average salary X3 = a dummy variable X4=Graduation Rate X5=Students Paying Down Their Debt X6=Students Who Return After Their First Year X7=Size X8=Average Years to Graduation X9=Ratings of the college SUMMARY OUTPUT
1 Albany College of Pharmacy and Health Sciences 886 29761 124700 0 74% 87% 45% 2 4 5
2 St. Louis College of Pharmacy 448 30274 124100 1 72% 93% 24% 3 6 5 Regression Statistics
3 MCPHS University 3837 23345 85900 1 91% 56% 83% 3 6 5 Multiple R 0.44
4 Massachusetts Institute of Technology 4489 30874 110598 0 94% 20% 53% 2 4 4 R Square 0.20
5 Louisiana State University Health Sciences Center-Shreveport 28 28100 100242 0 85% 46% 16% 2 5 5 Adjusted R Square 0.02
6 Babson College 2342 40136 144030 1 88% 38% 70% 1 6 2 Standard Error 2683.41
7 Maine Maritime Academy 1018 41859 129129 1 27% 43% 64% 1 5 3 Observations 50
8 Stanford University 7056 41051 87859 1 85% 61% 57% 1 4 1
9 Georgetown University 7128 39849 79628 0 95% 58% 76% 3 6 4 ANOVA
10 University of the Sciences 1268 31148 115792 1 89% 12% 2% 3 6 2 df SS MS F Significance F
11 The University of Texas Health Science Center at Houston 709 33749 99834 0 66% 77% 5% 1 4 3 Regression 9 70369010.6173113 7818778.95747903 1.0858391763 0.3943404547
12 Phillips School of Nursing at Mount Sinai Beth Israel 178 35330 134026 0 68% 12% 83% 3 5 4 Residual 40 288027145.382689 7200678.63456722
13 Harvard University 7532 29117 140256 0 64% 39% 100% 2 6 5 Total 49 358396156
14 University of Maryland Baltimore 918 34661 110934 0 99% 72% 39% 2 5 2
15 Stevens Institute of Technology 3114 40317 96957 0 90% 25% 60% 2 6 5 Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
16 Oregon Health & Science University 776 31541 144063 0 65% 36% 60% 2 4 2 Intercept -1062.45 4614.98 -0.23 0.82 -10389.67 8264.77
17 Harvey Mudd College 844 35679 135546 0 97% 20% 85% 3 6 5 X1 = Average Annual Cost 0.15 0.08 1.82 0.08 -0.02 0.31
18 United States Merchant Marine Academy 954 39340 96345 0 71% 7% 85% 3 5 4 X2 = average salary -0.02 0.02 -1.17 0.25 -0.06 0.02
19 Bentley University 4203 37806 142079 0 76% 33% 79% 3 4 2 X3 = a dummy variable -1239.31 821.93 -1.51 0.14 -2900.49 421.88
20 Massachusetts Maritime Academy 1627 40971 75894 1 55% 27% 33% 3 4 3 X4=Graduation Rate 1002.34 2585.17 0.39 0.70 -4222.50 6227.17
21 Los Angeles County College of Nursing and Allied Health 208 26931 118678 0 91% 20% 39% 2 4 1 X5=Students Paying Down Their Debt 880.46 1524.48 0.58 0.57 -2200.63 3961.56
22 The University of Texas MD Anderson Cancer Center 321 28923 102726 0 91% 61% 90% 3 5 1 X6=Students Who Return After Their First Year 807.14 1483.95 0.54 0.59 -2192.05 3806.32
23 University of Pennsylvania 10660 36209 123572 0 62% 50% 6% 1 5 4 X7=Size -346.31 496.99 -0.70 0.49 -1350.76 658.14
24 California Institute of Technology 961 36378 117922 1 95% 13% 61% 3 6 4 X8=Average Years to Graduation 407.05 510.09 0.80 0.43 -623.88 1437.98
25 Rush University 107 27041 130982 1 93% 10% 91% 2 6 3 X9=Ratings of the college -299.91 291.97 -1.03 0.31 -889.99 290.18
26 Worcester Polytechnic Institute 4357 31640 107072 0 62% 36% 56% 3 4 5
27 Colorado School of Mines 4751 40432 130310 1 61% 27% 46% 1 5 3
28 Helene Fuld College of Nursing 480 27327 143629 0 80% 46% 44% 1 5 3
29 St Paul's School of Nursing-Staten Island 532 31582 105790 1 63% 46% 58% 1 6 5
30 Duke University 6552 41003 85966 1 95% 24% 31% 1 6 1
31 Cochran School of Nursing 120 36812 119290 1 82% 85% 67% 3 4 5
32 Medical University of South Carolina 303 31416 135243 1 71% 8% 39% 2 4 4
33 Carnegie Mellon University 6434 38462 107919 0 75% 33% 98% 2 4 2
34 Columbia University in the City of New York 8170 38810 117057 0 85% 49% 87% 3 5 3
35 Yale University 5742 33029 118650 1 94% 46% 32% 3 4 5
36 California State University Maritime Academy 1048 40833 133893 1 95% 75% 15% 3 6 4
37 SUNY Maritime College 1633 38791 140644 0 94% 91% 59% 3 5 3
38 Rensselaer Polytechnic Institute 6314 35945 98994 1 78% 87% 86% 3 5 1
39 Charles R Drew University of Medicine and Science 138 27327 81900 1 76% 47% 77% 2 4 2
40 Lehigh University 5057 34212 81900 1 75% 60% 31% 1 5 1
41 Miami Ad School-New York 110 29585 98899 1 65% 4% 29% 3 4 4
42 Miami Ad School-San Francisco 66 41478 95561 1 70% 40% 74% 2 5 5
43 Miami Ad School-Wynwood 146 31032 137375 0 66% 76% 83% 1 4 5
44 St Paul's School of Nursing-Queens 582 40645 103508 1 52% 56% 62% 3 5 5
45 Rose-Hulman Institute of Technology 2146 28489 122559 0 39% 31% 9% 3 6 3
46 Loma Linda University 1050 33516 116358 1 81% 79% 13% 2 5 5
47 Kettering University 1850 35618 113884 0 41% 19% 37% 1 5 5
48 Thomas Jefferson University 731 38488 102470 1 46% 4% 24% 1 5 5
49 DigiPen Institute of Technology 1019 35538 80200 1 73% 14% 20% 1 4 4
50 Texas Tech University Health Sciences Center 1597 28330 80300 0 85% 22% 42% 3 4 3