$4$ Files $23$:$37$ Mon $4.$ Mar

HMGT$400$Exercise$-$Modified$-7-6-20202$

Home

Insert

Draw

Layout

Review

View

Times New Roman

If you have chosen to work with Excel, please run above three models and complete the following tables.

Model $1$:

Run a linear model and predict the difference between hospital beds $($use the bed$-$tot$)$ and hospital net$-$benefit in teac hing hospitals?

$\backslash$table$[[$Hospital Characteristics,Coef.,ST$.$ ERR,T Stat,P$-$values,Lower $95\%,$Upper $95\%],[$Model$-1,,,,,,],[$Hospital beds,,,,,,$],[$R Square,,,,,,$]]$

Model $2$:

Run a linear model and predict the difference between hospital beds $($use the bed$-$tot$)$ and hospital net$-$benefit in non $-$teaching hospitals?

Use the results from model $1$ and model $2$ and compare the results between teaching and non$-$teaching hospitals.

$\backslash$table$[[$Hospital Characteristics,Coef.,ST$.$ ERR,T Stat,P$-$values,Lower $95\%,$Upper $95\%],[$Model$-2,,,,,,],[$Hospital beds,,,,,,$],[$R Square,,,,,,$]]$

Model $3$:

Now, include the ratio of ratio$-$Medicare$-$discharge and ratio$-$Medicaid$-$discharge in first model? How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net$-$benefit in teaching hospitals?

$\backslash$table$[[$Hospital Characteristics,Coef.,ST$.$ ERR,T Stat,P$-$values,Lower $95\%,$Upper $95\%],[$Model$-3,,,,,,],[$Hospital beds,,,,,,$],[$ratio$-$Medicare$-$discharge,,,,,,$],[$ratio$-$Medicaid$-$discharge,,,,,,$],[$R Square,,,,,,$]]$

Model $4$:

Now, include the ratio of ratio$-$Medicare$-$discharge and ratio$-$Medicaid$-$discharge in first model? How do you evaluate the impact of having higher Medicare and Medicaid patients on hospital net$-$benefit in non$-$teaching hospitals?

$\backslash$table$[[$Hospital Characteristics,Coef.,ST$.$ ERR,T Stat,P$-$values,Lower $95\%,$Upper $95\%],[$Model$-4,,,,,,],[$Hospital beds,,,,,,$],[$ratio$-$Medicare$-$discharge,,,,,,$],[$ratio$-$Medicaid$-$discharge,,,,,,$],[$R Square,,,,,,$]]$

Based on your finding please recommend $3$ policies to improve hospital performance, please make sure to use the final model for your recommendation.

HMGT $400$ Research and Data Analysis in Health Care$-$Exercise, page $5$