ISDS 361B Project.xlsx - Graduation Rate Graduation Rate of Classes Under 20 Student-Faculty Ratio Alumni Giving Rate 1 0.58-0.60 0.76 of Classes Under

ISDS 361B Project.xlsx - Graduation Rate Graduation Rate of...

This preview shows page 1 - 10 out of 30 pages.

Graduation Rate % of Classes Under 20 Student-Faculty Ratio Graduation Rate 1 % of Classes Under 20 0.58 1 Student-Faculty Ratio -0.60 -0.79 1 Alumni Giving Rate 0.76 0.65 -0.74
Alumni Giving Rate 1
SUMMARY OUTPUT Regression Statistics Multiple R 0.7559435914 R Square 57.15% Adjusted R Square 0.5621344245 Standard Error 8.894328114 Observations 48 ANOVA df SS MS F ignificance F Regression 1 4852.4618270788 4852.462 61.33888 5.24E-010 Residual 46 3639.0173395879 79.10907 Total 47 8491.4791666667 Coefficients Standard Error t Stat P-value Lower 95%Upper 95% Intercept -68.76 12.5826557253 -5.464759 1.82E-006 -94.08876 -43.43361 Graduation Rate 1.18 0.1507314789 7.831914 5.24E-10 0.877109 1.483923 RESIDUAL OUTPUT Observation dicted Alumni Giving R Residuals 1 31.5826771654 -6.5826771654 2 24.4995811694 8.5004188306 3 41.02680516 -1.02680516 Alumini giving rate = -68.76 + 1.1 4 31.5826771654 14.4173228346 Graduation Rate: slop 5 19.7775171721 8.2224828279 6 16.2359691741 14.7640308259 R-square 57.15% 7 36.3047411627 -9.3047411627 8 37.485257162 -6.485257162 9 38.6657731613 -3.6657731613 10 42.2073211593 10.7926788407 11 39.8462891607 5.1537108393 12 30.402161166 6.597838834 13 38.6657731613 -9.6657731613 14 45.7488691573 0.2511308427 15 36.3047411627 -9.3047411627 16 26.860613168 13.139386832 17 39.8462891607 4.1537108393 18 16.2359691741 -3.2359691741 19 37.485257162 -7.485257162 20 25.6800971687 -4.6800971687 21 43.3878371587 23.6121628413 22 39.8462891607 0.1537108393 23 39.8462891607 -5.8462891607 24 33.943709164 -4.943709164
25 16.2359691741 0.7640308259 26 29.2216451667 -11.2216451667 27 18.5970011727 -11.5970011727 28 18.5970011727 -9.5970011727 29 23.31906517 -10.31906517 30 25.6800971687 -17.6800971687 31 13.8749371754 -1.8749371754 32 30.402161166 5.597838834 33 10.3333891774 8.6666108226 34 22.1385491707 0.8614508293 35 29.2216451667 -16.2216451667 36 28.0411291674 -2.0411291674 37 42.2073211593 6.7926788407 38 37.485257162 3.514742838 39 20.9580331714 2.0419668286 40 13.8749371754 8.1250628246 41 9.1528731781 3.8471268219 42 39.8462891607 -11.8462891607 43 13.8749371754 -1.8749371754 44 17.4164851734 -4.4164851734 45 28.0411291674 2.9588708326 46 28.0411291674 9.9588708326 47 32.7631931647 0.2368068353 48 42.2073211593 7.7926788407
Lower 95.0% Upper 95.0% -94.08876 -43.43361 0.877109 1.483923 18 pe b is positive, so the alumini giving rate is expected to increase by 1.18 as graduation rate increases by 1 60 65 70 75 80 85 90 95 100 -20 -15 -10 -5 0 5 10 15 20 25 30 Graduation Rate Graduation Rate Residuals
60 65 70 75 80 85 90 95 100 0 10 20 30 40 50 60 70 80 Graduation Rate Line Fit Plot Alumni Giving Rate Predicted Alumni Giving Rate Graduation Rate Alumni Giving Rate
SUMMARY OUTPUT Regression Statistics Multiple R 0.836624531 R Square 0.6999406058 Adjusted R Square 0.6794820108 Standard Error 7.6097247806 Observations 48 ANOVA df SS MS F ignificance Regression 3 5943.5310723 1981.177 34.21255 1.43E-011 Residual 44 2547.9480944 57.90791 Total 47 8491.4791667 Coefficients Standard Error t Stat P-value Lower 95% Intercept -20.720 17.521365013 -1.182564 0.243333 -56.03213 Graduation Rate 0.748 0.1659599594 4.508213 4.80E-005 0.413712 % of Classes Under 20 0.029 0.1393213222 0.208444 0.835844 -0.251743 Student-Faculty Ratio -1.192 0.3867231042 -3.082336 0.003538 -1.9714 RESIDUAL OUTPUT Alumini giv Observation Predicted Alumni Giving Rate Residuals 1 28.51 -3.51 2 30.82 2.18 3 41.07 -1.07 4 41.19 4.81 R-square 5 25.42 2.58 6 25.12 5.88 P-Value 7 32.87 -5.87

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture