Xlminer analysis toolpak linear regression

Research Analysis And Management

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

Table of Contents Week 6: Qualita!ve Analysis in Health Services Research Exercise #5 Submission Folder

Exercise #5 Submission Folder

Instruc!ons

HM… RA Roosevelt Asamoah

Course Home Content Discussions Assignments ClasslistMy Tools Resources Help

For this week's exercise, we need to try a few logit models (see this link for more informa!on:

h"ps://stats.idre.ucla.edu/r/dae/logit-regression/)

Track 1 EXCEL: Please run the three models (using the usual HMGT400Hospital.CSV

dataset) and complete the tables. Use Excel Online with the XLMiner Analysis ToolPak add-in

(FREE) and data uploaded to OneDrive. You can insert the ToolPak by clicking "Insert", then

"Office Add-ins" and then select the Data Analy!cs add-in called "XLMiner Analysis ToolPak"

(not the visualiza!on app). Create an extract of our class data file and upload the data extract

to OneDrive.

Logit Model 1: Run a logit model to explain the "being a member of a network" variable

(system_member). What is the impact of hospital costs on determining the "being a member

of a network" variable? Or what is the rela!onship between "being a member of a network"

and hospital costs (Logit Model 1)

Coeff.ST.

ERR

P-

Value

Odds

Ra!o

Lower

95%

Upper

95%

Intercept

Total Hospital cost

N

javascript:void(0);
https://learn.umuc.edu/d2l/le/content/441862/Home?itemIdentifier=D2L.LE.Content.ContentObject.ModuleCO-17289747
https://learn.umuc.edu/d2l/le/content/441862/navigateContent/210/Previous?pId=17289747
https://learn.umuc.edu/d2l/le/content/441862/navigateContent/210/Next?pId=17289747
https://learn.umuc.edu/d2l/home/441862
https://learn.umuc.edu/d2l/lp/ouHome/defaultHome.d2l
https://learn.umuc.edu/d2l/home/441862
https://learn.umuc.edu/d2l/le/content/441862/Home
https://learn.umuc.edu/d2l/le/441862/discussions/List
https://learn.umuc.edu/d2l/lms/dropbox/dropbox.d2l?ou=441862
https://learn.umuc.edu/d2l/lms/classlist/classlist.d2l?ou=441862
https://stats.idre.ucla.edu/r/dae/logit-regression/
2/19/20, 4)04 PMExercise #5 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

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

Logit Model 2: What is the impact of hospital costs and hospital revenue on determining the

"being a member of a network" variable? Or what is the rela!onship between "being a

member of a network" and hospital costs and hospital revenue (Logit Model 2)

Coeff.ST.

ERR

P-

value

Odds

Ra!o

Lower

95%

Upper

95%

Intercept

Total Hospital cost

Total Hospital

Revenue

N

Logit Model 3: For the 3rd model, add the Medicare-discharge-ra!o and the Medicaid-

discharge-ra!o and their impact on determining the "being a member of a network" variable?

Or what is the rela!onship between "being a member of a network" and hospital costs and

hospital revenue, and the Medicare-discharge-ra!o and the Medicaid-discharge-ra!o? (Logit

Model 3)

Coeff.ST.

ERR

P-

values

Odds

ra!o

Lower

95%

Upper

95%

Intercept

Total Hospital cost

Total Hospital Revenue

Medicare discharge

ra!o

Medicaid discharge

2/19/20, 4)04 PMExercise #5 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

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

ra!o

N

Based on your findings please recommend 3 policies and discuss the impact of being on a

network on hospital cost, hospital revenue and out its impact on ra!o-Medicare-discharge

and ra!o-Medicaid-discharge. Do you recommend keeping a membership for a hospital?

Why or why not?

Please a"ach any plo"ed or graphed informa!on you want to use to make your case.

NOTE: A"er comple!ng Exercise 5 students may start on the Final Exam (see content in

week 8). The final Exam format follows Exercises 1 to 5 with regard to the data analysis. So

go back and review the examples I emailed to you, and my feedback.

======================================

Track 2 RStudio: If you chose to use Rstudio accomplish the following:

1. Run a logit model and use being a member of the network and find out its impact on

hospital ownership and hospital beds. (Model 1)

Hospital Characteris!csCoef. St. Err p-

value

Hospital beds

Ownership

For-Profit

Non-for profit

Other

2/19/20, 4)04 PMExercise #5 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

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

N

AIC

2. Now, include hospital income and report the Coeff. (Model 2)

Hospital

Characteris!cs

Coef. St. Err p-

value

Hospital beds

Ownership

For Profit

Non-for profit

Other

Hospital Income

N

AIC

3.Now, include the ra!o of ra!o-Medicare-discharge and ra!o-Medicaid-discharge in your

model. And keep all variables you used for models 1, 2 & 3 to discuss your findings. Do you

recommend keeping membership for a hospital? Why or why not? (Model 3)

Hospital

Characteris!cs

Coef. St. Err p-

value

Hospital beds

Ownership

2/19/20, 4)04 PMExercise #5 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

Page 5 of 6https://learn.umuc.edu/d2l/le/content/441862/viewContent/17289786/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.

For-Profit

Non-for profit

Other

Hospital Income

Medicare discharge

ra!o

Medicaid discharge

ra!o

N

AIC

Based on your findings please recommend 3 policies to improve hospital performance in FP,

NFP hospitals, please make sure to use the final model for your recommenda!on. Make sure

to a"ach the plo"ed or graphed informa!on

2/19/20, 4)04 PMExercise #5 Submission Folder - HMGT 400 6381 Research and Data Analysis in Health Care (2202)

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

Due February 23 at 11:59 PM

Task: Submit to complete this assignment Assessment

Exercise 4 and 5 start

2198 (Rubrics)

Last Visited Feb 17, 2020 10:34 PM

Ac!vity Details

https://learn.umuc.edu/d2l/le/content/441862/navigateContent/210/Previous?pId=17289747
https://learn.umuc.edu/d2l/le/content/441862/navigateContent/210/Next?pId=17289747
javascript:void(0);
javascript:void(0);