# Based on the data provided please complete the following 1

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 findings4.Based on the results in part 2 and 3 , do you believe another regression model maybe more appropriate ? Estimate this model and discuss your results5. 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 ?Attachments: alumnigiving.xlsx