Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 50

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_2

Step: 3

blur-text-image_3

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

Fundamentals Of Oil And Gas Accounting

Authors: Charlotte J. Wright, Rebecca A. Gallun

5th Edition

1593701373, 978-1593701376

More Books

Students also viewed these Accounting questions