NOTE: after finishing Exercise 5 the students may start on the Final Exam (see content in week 8). The final Exam format follows Exercise 1-5 with regard to data analysis. For this week exercise, we need to try a few logit models (see this link for more information:https://stats.idre.ucla.edu/r/dae/logit-regression/) Track 1 EXCEL:If you have chosen to work withExcel, please run above three models and complete the following tables.See Track 2 for RStudio below Model 1: Run a logit model and use being a member of a network and find out its impact on hospital cost? (Model 1) | Coef. | ST. ERR | T Stat | P-values | Lower 95% | Upper 95% | Model-1 | | | | | | | Hospital cost | | | | | | | N | | | | | | | AIC | | | | | | |
Model 2: For the 2ndmodel run a logit model and use being a member of the network and find out its impact on hospital cost and hospital revenue? (Model 2) | Coef. | ST. ERR | T Stat | P-values | Lower 95% | Upper 95% | Model-2 | | | | | | | Hospital cost | | | | | | | Hospital Revenue | | | | | | | N | | | | | | | AIC | | | | | | |
Model 3: For the 3rdmodel run a logit model and use being a member of the network and find out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge. | Coef. | ST. ERR | T Stat | P-values | Lower 95% | Upper 95% | Model-3 | | | | | | | Hospital cost | | | | | | | Hospital Revenue | | | | | | | Medicare discharge ratio | | | | | | | Medicaid discharge ratio | | | | | | | N | | | | | | | AIC | | | | | | |
Based on your finding please recommend 3 policies and discuss the impact of being on a network on hospital cost, hospital revenue and out its impact on ratio-Medicare-discharge and ratio-Medicaid-discharge. Do you recommend keeping membership for a hospital? Why or why not? Track 2 RStudio:If you chose to use Rstudio accomplish the following: - Run a logit model and use being a member of the network and find out its impact on hospital ownership and hospital beds. (Model 1)
Hospital Characteristics | Coef. | St. Err | p-value | Hospital beds | | | | Ownership | | | | For-Profit | | | | Non-for profit | | | | Other | | | | N | | | | AIC | | | |
2. Now, include hospital income and report the Coeff. (Model 2) Hospital Characteristics | Coef. | St. Err | p-value | Hospital beds | | | | Ownership | | | | For Profit | | | | Non-for profit | | | | Other | | | | Hospital Income | | | | N | | | | AIC | | | |
3.Now, include the ratio of ratio-Medicare-discharge and ratio-Medicaid-discharge in your model. And keep all variables you used for models 1, 2 & 3 to discuss your findings. Do you recommend keeping membership for a hospital? Why or why not? (Model 3) Hospital Characteristics | Coef. | St. Err | p-value | Hospital beds | | | | Ownership | | | | For-Profit | | | | Non-for profit | | | | Other | | | | Hospital Income | | | | Medicare discharge ratio | | | | Medicaid discharge ratio | | | | N | | | | AIC | | | |
Based on your finding pleaserecommend 3 policiesto improve hospital performance in FP, NFP hospitals, please make sure to use the final model for your recommendation. Make sure to attach the plotted information |