Data Setup: An extract of the HMGT400Hospital.CSV dataset 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 1: Run a logit model to explain the "being a member of a network" variable (system_member). The independent variable is Total Hospital Costs. And choose 0.95 Confidence level. In options select the Logit and Exponentiated Coefficient Table (not just Logit) and request for P-values. The exponentiated coefficients are the odds ratios. You may also request for the logistic curve or other plots or graphs you want, and request for the high-resolution graph format.

Logit Model 2: Run a logit model to explain the "being a member of a network" variable (system_member). The independent variables area Total Hospital Costs and Total Hospital Revenues. And choose 0.95 Confidence level. In options select the Logit and Exponentiated Coefficient Table (not just Logit) and request for P-values. You may also request for the logistic curve and high-resolution graph format

Logit Model 3: For model 3, add the Medicare-discharge-ratio and the Medicaid-discharge-ratio variables to your Model 2, as independent variables.

Here are the tables that the professor has requested. I was able to do table 1 and answer the question but requesting assistance with 2 and 3 quesetions.

Logit Model 2:

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

Intercept 0.22 0.05 0.0

Total Hospital Costs 0.00 0.00 0.00 1.00 1.00 -0.85

Total Hospital Revenue

0.00 0.00 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:

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

Intercept 0.97 0.17 0.0

Total Hospital Cost 0.00 0.00 0.00 1.00 1.00 -0.88

Total Hospital

Revenue 0.00 0.00 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?