Develop an estimated simple linear regression model

Assignment Help Financial Management

Reference no: EM131208394

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

Reference no: EM131208394

Questions Cloud

Who was the audience and how did the audience affect : Consider any piece of writing Who was the audience, and how did the audience affect how you approached this piece of writing?

Write a review on an article from a magazine or newspaper : Write a 1 page review/commentary on an article from a magazine, newspaper, Wall Street Journal, etc. on the following topics. This should be a news item and not from a site defining a term or concept such as Wikipedia, etc.

Create and demonstrate an opengl based gui framework : 5CC509: Graphics - An OpenGL based GUI framework. One of the core requirements for building this new framework is to use OpenGL for platform independent rendering, so that a tighter UI integration with their 3D applications can be achieved. In this..

Was the victim the accuser or the accused : For our Unit 3 discussion, choose another court case where the victim was publically handled. Discuss your thoughts on the victims' expectations of the criminal justice system and whether or not the victim in your chosen case was handled appropria..

Develop an estimated simple linear regression model : Develop an estimated simple linear regression model that can be used to predict the alumni giving rate , given the graduation rate. Discuss your findings.

How will the terminal voltage change as the load power vary : how will the terminal voltage change as the load power factor varies from 0.9 PF lagging to 0.9 PF leading? Make a plot of the terminal voltage versus the load impedance angle.

What is the static stability limit of this generator : How close is the full-load condition of this generator to the static stability limit?

What is the origin and biblical bases for the death penalty : Is there a difference between the Old and New Testament approaches to the death penalty? Explain the U.S. Supreme Court's treatment of juveniles and the mentally ill in death penalty cases. Does the death penalty provide a valid punishment option in ..

What steps can this company take to diversify its portfolio : What steps can this company take to diversify its portfolio? Define diversification and its necessary in risk management? Discuss at least 5 steps to diversify the card business?

User Account

All Pages