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 ?