Run a linear model and predict the difference between hospital beds (use the bed-tot) and hospital’s ownership on hospital net-benefit?

Linear Regression Model

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

Track 1 RStudio: If you have chosen to work with RStudio (1 % BONUS), please run the following models and complete the following tables. See Track 2 below for EXCEL

1st Model:

Run a linear model and predict the difference between hospital beds (use the bed-tot) and hospital’s ownership on hospital net-benefit? Discuss your finding, do you think having higher beds has positive impact on the hospital net benefit? What about the ownership?

2nd Model:

Now, estimate the impact of being a member of a system on hospital net benefit. And discuss your finding (nor more than 2 lines). Is the result significant? Explain.

3rd Model:

Now, include the ratio of ratio-Medicare-discharge and ratio-Medicaid-discharge in your model. How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital revenues?

Based on your finding please recommend 3 policies to improve hospital performance. Please make sure to use the final model for your recommendation.

Download Data from here: The data is the same of E1, E2 and E3

Download codes from here:

E4-codes-dplyr

E4-codes-no-dplyr