Question
SUMMARY OUTPUT Regression Statistics Multiple R 0.755943591 R Square 0.571450713 Adjusted R Square 0.562134424 Standard Error 5.695484298 Observations 48 ANOVA df SS MS F Significance
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.755943591 | |||||||
R Square | 0.571450713 | |||||||
Adjusted R Square | 0.562134424 | |||||||
Standard Error | 5.695484298 | |||||||
Observations | 48 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 1989.743763 | 1989.743763 | 61.33887894 | 5.23818E-10 | |||
Residual | 46 | 1492.172904 | 32.43854139 | |||||
Total | 47 | 3481.916667 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 65.87257569 | 1.987163571 | 33.14904554 | 9.30808E-34 | 61.87262289 | 69.8725285 | 61.87262289 | 69.8725285 |
Percentage of Alumni who donated to the University | 0.484068588 | 0.061807188 | 7.83191413 | 5.23818E-10 | 0.359657172 | 0.608480005 | 0.359657172 | 0.608480005 |
Summarize the data utilizing appropriate descriptive statistics
A. is there a connection between the graduation rate and the % of alumni that give back? Create a regression model and explain the information.
B. Make a regression model utilizing all the independent variables (graduation rate, percentage of classes with class size below 25, faculty to student ratio) while having the same dependent variable as in the previous question.
C. Based on the results in (A) and (B), do you believe another regression model may be more appropriate? Estimate this model, and infer your results.
University Graduation Rate (%) State % of Classes Under 25 Percentage of Alumni who - Faculty- Student Ratio 0.077 0.095 0.105 Mode Median Mean 89 80.5 80.042 65 59.5 55.729 13 29 29.271 7 29 77 48 0.043 0.333 0.290 67 60 44.75 59.50 66.3 174.074 13.194 0.074 0.095 0.125 0.003 0.054 18.75 29.0 38.5 180.670 13.441 % of alumni who donated Faculty-Student Ratio of Alumni who donato Graduation Rate %) % of Classes Under 25 Mean Standard Err Median Mode Standard De Sample Varia Kurtosis Skewness Range Minimum Maximum Sum Count 80.0417Mean 1.2423 Standard Err 80.5000 Median 89.0000 Mode 8.6072 Standard De 74.0833 Sample Varia - 1.1039 Kurtosis -0.2823 Skewness 31 Range 63 Minimum 94 Maximum 3842 Sum 48 Count 55.7292 Mean 1.9043 Standard Err 59.5000 Median 65.0000 Mode 13.1937 Standard De 174.0740 Sample Varia -0.9566 Kurtosis -0.5006 Skewness 48 Range 29 Minimum 77 Maximum 2675 Sum 48 Count 0.1051 Mean 29.2708 0.0078 Standard Er 1.9401 0.0955 Median 29.0000 0.0769 Mode 13.0000 0.0537 Standard De 13.4413 0.0029 Sample Vari: 180.6698 6.5361 Kurtosis -0.0719 2.0916 Skewness 0.3701 0.2899 Range 60 0.0435 Minimum 7 0.3333 Maximum 67 5.0450 Sum 1405 48.0000 Count NY Measures of spread MIN 63 MAX 94 Range 31 Quartiles: ISL 72.75 2nd 80.50 3rd 88.0 Variance 74.083 Standard Deviation 8.607 Graduatio % of Faculty Percentag State n Rate Classes Student e of (%) - Under 25 - Ratia Alumni MA 82 39 0.077 25 MA 76 68 0.125 33 RI 90 60 0.125 40 CA 82 65 0.333 16 PA 72 67 0.100 28 OII 69 52 0.125 31 VA 86 45 0.083 27 NY 87 69 0.143 31 88 72 0.077 35 NII 91 61 0.100 53 NC 89 68 0.125 45 GA 81 65 0.143 37 DC 88 54 0.100 29 MA 94 73 0.125 46 MD 86 64 0.111 27 PA 78 55 0.091 10 MA 89 OS 0.167 44 NY 69 63 0.077 13 IL 87 66 0.125 30 PA 77 32 0.053 21 NJ 92 68 0.200 67 TX 89 62 0.125 40 CA 89 69 0.143 MA 84 67 0.111 29 1.A 69 56 0.083 17 CA 80 58 0.059 18 71 32 (1.053 7 CA 71 42 0.050 9 CA 75 11 0.056 13 CA 77 48 0.053 8 CA 67 15 0.050 12 IL 81 65 0.250 36 FL 6-1 31 0.043 19 IL 74 29 0.067 23 MI 80 S1 0.067 13 NC 79 40 0.063 26 IN 91 53 0.077 49 PA 87 65 0.143 41 NY 73 63 0.100 23 CA 67 53 0.077 22 IX 63 39 0.048 13 VA 89 0.077 28 67 37 0.083 12 WI 70 37 0.077 13 IN 79 68 0.111 31 NC 79 59 0.091 38 MO 83 73 0.143 33 CT 91 77 0.113 50 University Graduation Rate (%) State % of Classes Under 25 Percentage of Alumni who - Faculty- Student Ratio 0.077 0.095 0.105 Mode Median Mean 89 80.5 80.042 65 59.5 55.729 13 29 29.271 7 29 77 48 0.043 0.333 0.290 67 60 44.75 59.50 66.3 174.074 13.194 0.074 0.095 0.125 0.003 0.054 18.75 29.0 38.5 180.670 13.441 % of alumni who donated Faculty-Student Ratio of Alumni who donato Graduation Rate %) % of Classes Under 25 Mean Standard Err Median Mode Standard De Sample Varia Kurtosis Skewness Range Minimum Maximum Sum Count 80.0417Mean 1.2423 Standard Err 80.5000 Median 89.0000 Mode 8.6072 Standard De 74.0833 Sample Varia - 1.1039 Kurtosis -0.2823 Skewness 31 Range 63 Minimum 94 Maximum 3842 Sum 48 Count 55.7292 Mean 1.9043 Standard Err 59.5000 Median 65.0000 Mode 13.1937 Standard De 174.0740 Sample Varia -0.9566 Kurtosis -0.5006 Skewness 48 Range 29 Minimum 77 Maximum 2675 Sum 48 Count 0.1051 Mean 29.2708 0.0078 Standard Er 1.9401 0.0955 Median 29.0000 0.0769 Mode 13.0000 0.0537 Standard De 13.4413 0.0029 Sample Vari: 180.6698 6.5361 Kurtosis -0.0719 2.0916 Skewness 0.3701 0.2899 Range 60 0.0435 Minimum 7 0.3333 Maximum 67 5.0450 Sum 1405 48.0000 Count NY Measures of spread MIN 63 MAX 94 Range 31 Quartiles: ISL 72.75 2nd 80.50 3rd 88.0 Variance 74.083 Standard Deviation 8.607 Graduatio % of Faculty Percentag State n Rate Classes Student e of (%) - Under 25 - Ratia Alumni MA 82 39 0.077 25 MA 76 68 0.125 33 RI 90 60 0.125 40 CA 82 65 0.333 16 PA 72 67 0.100 28 OII 69 52 0.125 31 VA 86 45 0.083 27 NY 87 69 0.143 31 88 72 0.077 35 NII 91 61 0.100 53 NC 89 68 0.125 45 GA 81 65 0.143 37 DC 88 54 0.100 29 MA 94 73 0.125 46 MD 86 64 0.111 27 PA 78 55 0.091 10 MA 89 OS 0.167 44 NY 69 63 0.077 13 IL 87 66 0.125 30 PA 77 32 0.053 21 NJ 92 68 0.200 67 TX 89 62 0.125 40 CA 89 69 0.143 MA 84 67 0.111 29 1.A 69 56 0.083 17 CA 80 58 0.059 18 71 32 (1.053 7 CA 71 42 0.050 9 CA 75 11 0.056 13 CA 77 48 0.053 8 CA 67 15 0.050 12 IL 81 65 0.250 36 FL 6-1 31 0.043 19 IL 74 29 0.067 23 MI 80 S1 0.067 13 NC 79 40 0.063 26 IN 91 53 0.077 49 PA 87 65 0.143 41 NY 73 63 0.100 23 CA 67 53 0.077 22 IX 63 39 0.048 13 VA 89 0.077 28 67 37 0.083 12 WI 70 37 0.077 13 IN 79 68 0.111 31 NC 79 59 0.091 38 MO 83 73 0.143 33 CT 91 77 0.113 50Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started