Managerial Report with 5 steps

profilecoulxns4jz

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 ?

  • 8 years ago
  • 20
Answer(2)

Purchase the answer to view it

blurred-text
  • attachment
    alumnigiving_1.xlsx
  • attachment
    backup_of_backup_of_alumni_giving.zip

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    alumnigivingdatafile.xlsx