Exercise #4 If you have chosen to work with Excel, run the three linear regression models and complete the following tables using the dataset from week 1’s exercise. Medicare and Medicaid Discharge Ratios: Medicare Discharges ÷ Total Hospital Discharges; Medicaid Discharges ÷ Total Hospital Discharges Model 1: Run a linear model to predict the impact of number of hospital beds on hospital net-benefit in teaching hospitals. Hospital Characteristics Coef. ST. ERR T Stat P-values Lower 95% Upper 95% Hospital beds R Square Model 2: Run a linear model to predict the impact of number of hospital beds on hospital net-benefit in non-teaching hospitals. Hospital Characteristics Coef. ST. ERR T Stat P-values Lower 95% Upper 95% Hospital beds R Square Use the results
Exercise #4 If you have chosen to work with Excel, run the three linear regression models and complete the following tables using the dataset from...