Instructions

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 with Excel, please run above three models and complete the following tables.

Model 1: Run a logit model and use being a member of a network and find out its impact on hospital cost? (Model 1)

Model 2: For the 2nd model 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)

Model 3: For the 3rd model 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.

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?