In: Statistics and Probability
Alumni donations are an important source of revenue for college and universities. If administrators could determine the factors that could lead to increases in the percentage of alumni who make a donation, they might be able to implement policies that could lead to increased revenues. Research shows that students who are more satisfied with their contact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower student-faculty ratios might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in the percentage of alumni who make a donation. Table 15.13 shows data for 48 national universities (America’s Best Colleges, Year 2000 Edition). The column labeled Graduation Rate is the percentage of students who initially enrolled at the university and graduated. The column labeled % of Classes Under 20 shows the percentage of classes offered with fewer than 20 students. The column labeled Student-Faculty Ratio is the number of students enrolled divided by the total number of faculty. Finally, the column labeled alumni Giving Rate is the percentage of alumni that made a donation to the university.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1. Use methods of descriptive statistics to summarize the data. 2. Develop an estimated simple linear regression model that can be used to predict the alumni giving rate, given the graduation rate. Discuss your findings. 3. Develop an estimated multiple linear regression model that could be used to predict the alumni giving rate using the Graduation Rate, % of Classes Under 20, and Student / Faculty Ratio as independent variables. Discuss your findings. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4. Based on the results in parts 2 and 3, do you believe another regression model may be more appropriate? Estimate this model, and discuss your results. 5. What conclusions and recommendations can you derive from your analysis? What universities are achieving a substantially higher alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student / Faculty Ratio? What universities are achieving a substantially lower alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student / Faculty Ratio? What other independent variables could be included in the model? Please show most of your work using Excel Data Analysis Toolpak. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1) summary :-
we use excel command to find summary as,
2) simple regression for dependent variable alumni giving rate and independent variable graduation rate
H0 : alumni giving rate independ on graduation rate.
H1: alumni giving rate depends on graduation rate.
Decision rule :-
i) if F calculated < Fcritical then accept null hypothesis H0 at level of significance 0.05
ii) if F calculated > Fcritical then reject null hypothesis H0 at level of significance 0.05
Result :-
F calculated (61.3388)> Fsignificant(5.23818E-10)
then reject null hypothesis H0 at level of significance 0.05
Interpritation :- alumni giving rate depends on graduation rate.
3) to develop an estimated multiple linear regression model that could be used to predict the alumni giving rate using the Graduation Rate, % of Classes Under 20, and Student / Faculty Ratio as independent variables.
H0 : graduation rate % of class under 20 and student/ faculty ratio does not affect on Alumini giving rate
H1: graduation rate % of class under 20 and student /faculty ratio does not affect on Alumini giving rate
the table is ,
for the model, from decision rule
Result :
F calculated (34.21255)> Fsignificant(1.43233E-11)
then reject null hypothesis H0 at level of significance 0.05
Conclusion :-
graduation rate % of class under 20 and student /faculty ratio does not affect on Alumini giving rate
4) 5) adjusted R2 of first simple regression model = 0.5621344
adjusted R2 of second multiple regression model = 0.679482
here, adjusted R2 (0.679482) > adjusted R2 ( 0.5621344)
Conclusion :- the second model is good