Data Setup: An extract of the HMGT400Hospital.CSV dataset was done by selecting the columns having the dependent variable "system_member", and the independent variables Total Hospital Costs, Total Hospital Revenue, Medicare Discharges, Medicaid Discharges, and Total Hospital Discharges. Create the Medicare Discharge ratio and the Medicaid Discharge ratio. Then as you would for all regressions, clean the data by deleting all rows (hospitals) that have missing values or #DIV/0! values. Be sure to state and describe in your report how you cleaned the data, indicating the number of hospitals you deleted and which variables had missing values or #DIV/0! Values.

Logit Model 2 Table:

Coefficient St. ERR P-value Exp (coeff) Exp (z SE) Exp (Std. coeff.)

Intercept 0.22 0.05 0.0

Total Hospital Costs -5.149e-09 1.741e-09 0.00 1.00 1.00 -0.85

Total Hospital Revenue

5.944e-09 1.64e-09 0.00 1.00 1.00 1.06

R-squared 0.02

What is the impact of hospital costs and hospital revenue on "being a member of a network"?

Logit Model 3 Table:

Coefficient St ERR P-value Exp (coeff) Exp (z SE) Exp (Std.coeff)

Intercept 0.97 0.17 0.0

Total Hospital Cost -5.346e-09 1739e-09 0.00 1.00 1.00 -0.88

Total Hospital

Revenue 5.8993e-09 1.6372e-09 0.00 1.00 1.00 1.05

Medicare discharge ratio -1.78 0.28 0.00 0.39 1.75 -0.10

Medicaid discharge ratio -1.66 0.43 0.00 0.19 2.30 -0.09

R-squared 0.03

What is the impact of hospital costs and hospital revenue, and each of the two ratios added in Model 3 on "being a member of a network"?

Based on your findings from the models, would you recommend that hospitals keep their system memberships?