InstructionsExercise #5For this week exercise, we need to try a few logit models (see this link for more information: londonessays.com you have chosen to work with Excel, please run above three models and complete the following tables.Model 1: Run a regression model and use being a member of network and find out its impact on hospital cost? (Model 1) Model 2: For the 2nd model run a regression model and use being a member of network and find out its impact on hospital cost and hospital revenue? (Model 2) Model 3: For the 3rd model run a regression model and use being a member of 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-Medica
id-discharge. Do you recommend keeping membership for a hospital? Why or why not?If you have decided to use RStudio:Model 1Run a logit model and use being a member of network and find out its impact on hospital ownership and hospital beds? (Model 1)Model 2Now, include hospital income and report the Coeff.? (Model 2)Model 3Now, 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 and discuss your findings? Do you recommend keeping membership for a hospital? Why or why not? (Model 3)Based on your finding please recommend 3 policies to improve hospital performance in FP, NFP hospitals, please make sure to use the final model for your recommendation.Download data: The data is the same data you have used for previous exercisesCodes: E5-codesQuestions: All exercises questions