Develop an estimated simple linear regression model

Assignment Help Microeconomics

Reference no: EM133736161

Question: Prepare a managerial report as described below. In the Excel data, add in four additional rows for Add in Park University, Donnelly College, <Instructor Last Name> University, and University of <Your Last Name> (WalterHobbs: I will add this information) but please predraft the data in the excel worksheet.

Use methods of descriptive statistics to summarize the data.

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

Develop an estimated multiple linear regression model that could be used to predict the alumni giving rate using Graduation Rate, % of Classes Under 20, and Student/ Faculty Ratio as independent variables. Discuss your findings.
Based on the results in parts (2) and (3), do you believe another regression model may be more appropriate? Estimate this model, and discuss your results.

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 Classes Under 20, and Student/ Faculty Ratio? What other independent variables could be included in the model?

Reference no: EM133736161

Questions Cloud

What was hezbelloah : What was Hezbelloah? What would it do? How did that impact Israeli elections? Why was that important?

Why should management be cautious about the unions : Management wants a wider wage spread, and the union wants a smaller wage spread. Why should management be cautious about the union's proposal (even though

Explore the relationships and collaborations with partners : Explore the relationships and collaborations with partners or stakeholders within the value chain. How do these partnerships contribute to value creation?

Identify patterns of development to western culture : Identify the three patterns of development to Western culture you found to be most monumental through the course material.

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. Describe and analyze

Essay on how context illuminates the meaning : Essay on how context illuminates the meaning of Amichai's poem, "God's Change, Prayers are Here to Stay." Your essay should draw on your close reading

Pestle forces that affect airline industry : Derive one to two PESTLE forces that affect the airline industry. You need to provide recent examples as well.

How did president coolidge try to convince american public : How did President Coolidge try to convince the American public that newspapers being a profitable business was not harmful to their presentation of the news?

Why the estimated coefficient on dry has the opposite sign : What is a good explanation for why the estimated coefficient on dry in part (III) has the opposite sign of the estimated coefficient on dry in part (I)?

User Account

All Pages