Run the simple linear regression analysis to develop an estimated equation that could be used to predict
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

Run the simple linear regression analysis to develop an estimated equation that could be used to predict

Case (Operations Management Application): This case study involves Alumni in the Case 4 folder. The file contains important source of revenue for colleges and universities. If administrators could determine the factors that influence increases in the percentage of alumni who make a donation (alumni giving rate), they might be able to implement policies that could lead to increased revenue. Research shows that students who are more satisfied with their contact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower student-faculty ratios might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in the percentage of alumni who make a donation. The managerial report should contain such as:


1. Run the simple linear regression analysis to develop an estimated equation that could be used to predict the alumni-giving rate by choosing graduation rate, % of classes under 20 students, or student/faculty ratio as the independent variable. Indicate the one with the highest R 2 .


2. Use the multiple linear regression analysis to develop an estimated regression equation that could be used to predict the alumni-giving rate given the graduation rate, % of classes under 20 students, and the student-faculty ratio. Is it a better fit compared with your answer in (1)? Any multicollinearity exists? Please show the correlation coefficients to comment.


3. What conclusion and recommendation can you derive from F and t-tests in (2)?


4. With the multiple linear regression equation in (2), what will be the alumni-giving rate with the graduation rate as 80%, 50% of classes with fewer than 20 students, and student-faculty ratio as 15?


5. Any possible modification you suggest for a better-fit multiple linear regression model? Adding or dropping independent variable(s)? Change to any nonlinear model? Explain your suggestion.

Hint
Model 1:Alumni Giving Rate (%) = 51.906-1.938*Student/Faculty RatioR^2 = 0.543Model 2:Alumni Giving Rate (%) =-5.71699 + 0.62976*% of Classes Under 20R^2 = 0.4186model 1 with the dependent variable as Alumni Giving Rate (%) and the independent variable as Student/Faculty Ratio has a higher value of the coefficient of determination (R^2) as compared to model 2....

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.