data management

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 1 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

Table of Contents Week 5: Quan!ta!ve Analysis and Health Services Research Exercise #4 Submission Folder

Exercise #4 Submission Folder

Instruc!ons

HM… RA Roosevelt Asamoah

Course Home Content Discussions Assignments ClasslistMy Tools Resources Help

Linear Regression Model

Exercise 4 offers two versions: EXCEL (base) and RStudio (BONUS)

Track 2 RStudio: If you have chosen to work with RStudio (1 % BONUS), please run the

following models and complete the following tables. See Track 1 below for EXCEL

1st Model:

Run a linear model and predict the difference between hospital beds (use the bed-tot) and hospital’s ownership on hospital net-benefit? Discuss your finding, do you think having higher beds has positive i mpact on the hospital net benefit? What about the ownership?

Model 1a

Hospital Characteris!cs Coef. St. Err

Hospital beds

Ownership

For-Profit

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 2 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

Non-for profit

Other

N

R-Squared

2nd Model:

Now, es!mate the impact of being a member of a hospital system on hospital net benefit.

And discuss your findings (not more than 2 lines). Is the result significant? Explain.

Model 2

Hospital Characteris!cs Coef. St. Err

Hospital beds

Ownership

For-Profit

Non-for profit

Other

Membership

System Membership

N

R-Squared

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 3 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

3rd Model:

Include the ra!o of ra!o-Medicare-discharge and ra!o-Medicaid-discharge in your model.

How do you evaluate the impact of having higher Medicare and Medicaid pa!ents on

hospital revenues?

Model 3

Hospital

Characteris!cs

Coef. St. Err

Hospital beds

Ownership

For-Profit

Non-for profit

Other

Membership

System Membership

Socio-Economic

Characteris!cs

Medicare discharge

ra!o

Medicaid discharge

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 4 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

ra!o

N

R-Squared

Based on your findings please recommend 3 policies to improve hospital performance.

Please make sure to use the final model for your recommenda!on.

Discuss your findings. Make sure to a"ach the plo"ed or graphed informa!on

Track 1 EXCEL: If you have chosen to work with Excel, please run the following four models

and complete the tables. Please use the Analysis ToolPak. Please eliminate any data rows

with missing values or impute the missing values before you run the Regression to avoid

errors. (The "Total hospital beds" variable has a few missing values).

Model 1:

Run a mul!ple linear regression model to explain/predict Net Hospital Benefits (Net Revenue). For your first

model, the dependent variable is Net Hospital Benefits and the independent or predictor variables are Total

Hospital Beds and whether the hospital is Teaching or not. Complete Table 1.

Table 1-Model 1-To explain/predict Net Hospital Benefits - 2011, 2012

Coef. ST.

ERR

T Stat P-

values

Lower

95%

Upper

95%

Intercept

Total Hospital beds

Teaching Hospital

Dummy

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 5 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

R Square=

Model 2:

Run a mul!ple linear regression model and explain/predict Net Hospital Benefits (Net Revenue). In the 2nd

model, the dependent variable is

Net Hospital Benefits and the independent or predictor variables are Total Hospital Beds and whether the

hospital is Non-Teaching or not. You may convert the Teaching Hospital column into a Non-Teaching column

by subtrac!ng 1 and changing the sign of the data. Complete Table 2.

Table 2-Model 2-To explain/predict Net Hospital Benefits - 2011, 2012

Coef. ST.

ERR

T Stat P-

values

Lower

95%

Upper

95%

Intercept

Total Hospital beds

Non-Teaching Hospital

Dummy

R Square=

Use the results from model 1 and model 2 to compare the results between teaching and

non-teaching hospitals.

Model 3:

Run a mul!ple linear regression model and explain/predict Net Hospital Benefits (Net Revenue). In the 3rd

model, the dependent variable is

Net Hospital Benefits and the independent or predictor variables are Total Hospital Beds, whether the hospital

is Teaching or not, Ra!o of Medicare Discharges, and Ra!o of Medicaid Discharges. Complete Table 3.

Table 3-Model 3-To explain/predict Net Hospital Benefits - 2011, 2012

Coef. ST.

ERR

T Stat P-

values

Lower

95%

Upper

95%

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 6 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

Intercept

Total Hospital beds

Teaching Hospital

Dummy

Ra!o of Medicare

discharges

Ra!o of Medicaid

discharges

R Square=

How do you evaluate the impact of having higher Medicare and Medicaid pa!ents on

hospital net-benefit in teaching hospitals?

Model 4:

Run a mul!ple linear regression model and explain/predict Net Hospital Benefits (Net Revenue). In the 4th

model, the dependent variable is

Net Hospital Benefits and the independent or predictor variables are Total Hospital Beds, whether the hospital

is Non-Teaching or not, Ra!o of Medicare Discharges, and Ra!o of Medicaid Discharges. Complete Table 4.

Table 4-Model 4-To explain/predict Net Hospital Benefits - 2011, 2012

Coef. ST.

ERR

T Stat P-

values

Lower

95%

Upper

95%

Intercept

Total Hospital beds

Non-Teaching Hospital

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 7 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

Submissions

No submissions yet. Drag and drop to upload your assignment below.

Drop files here, or click below!

Upload Record Audio Choose Exis!ng

You can upload files up to a maximum of 1 GB.

Task: Submit to complete this assignment Assessment

Dummy

Ra!o of Medicare

discharges

Ra!o of Medicaid

discharges

R Square=

How do you evaluate the impact of having higher Medicare and Medicaid pa!ents on

hospital net-benefit in non-teaching hospitals?

Based on your finding please recommend 3 policies to improve hospital performance. Please

make sure to use the final model for your recommenda!on.

Ac!vity Details

2/16/20, 10(23 PMExercise #4 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 8 of 8https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289785/View

Due February 16 at 11:59 PM

Exercise 4 and 5 start

2198 (Rubrics)

Last Visited Feb 16, 2020 7:47 AM