Managerial Report with 5 steps

Based on the data provided please complete the following:

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 part 2 and 3, do you believe another regression model maybe 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 class under 20, and student/faculty ratio? What other independent variables could be included in the model?

Attachment:- Alumnigiving.xlsx