Hide Assignment Information

Instructions

Linear Regression Model

Exercise 4 offers two versions: EXCEL (base) and RStudio (BONUS)

Use same dataset from week1 and submit results in a Microsoft Word document.

Track 2:Excel Track

Model 1. Run a linear model to predict the impact of difference in hospital beds (use total hospital beds column) on hospital net benefit inteachinghospitals.

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

Total Hospital Beds

R Squared

Model 2. Run a linear model to predict the impact of difference in hospital beds (use the total hospital beds column) on hospital net benefit innon-teachinghospitals.

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

Total Hospital Beds

R Squared

1. Use the results from model 1 and model 2 and compare the results betweenteachingandnon-teachinghospitals.

Model 3.Now, include the Medicare-discharge-ratio and Medicaid-discharge-ratio in the first model:Teaching Hospitals

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

Total Hospital Beds

Medicare-Discharge-Ratio

Medicaid-Discharge-Ratio

R Squared

Model 4.Now, include the Medicare-discharge-ratio and Medicaid-discharge-ratio in the second model:Non-Teaching Hospitals

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

Total Hospital Beds

Medicare-Discharge-Ratio

Medicaid-Discharge-Ratio

R Squared

1. How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net benefit inteaching hospitals?
2. How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net benefit innon-teaching hospitals?
3. Based on your finding(s), pleaserecommend 3 policiesto improve hospital performance. Please make sure to use the final model for your recommendation(s).