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
|