SOLUTION: HMGT 400 UMGC Research and Data Analysis in Health Final Exam


University of Maryland Global Campus (UMGC)

HMGT 400 Investigation and Axioms Analysis in Health- FINAL EXAM

Dataset: HMGTFINALEXAM.csv (Please downadmonish axiomsset from the tabulate)

Required program: RStudio or R Programming.

Author, Hossein Zare, PhD

Citation: Zare, H. (2019). HMGT 400 Investigation and Axioms Analysis in Sanity Care. FINAL EXAM. UMGC.EDU

Question #1 (15 credits): [RStudio Users and Excel Users]

The FINAL EXAM axiomsset, provides some advice environing hospitals in 2011 and 2012, downadmonish the FINAL EXAM axioms and then consummate the pictorial table. Delight solution the aftercited doubts.

  • In tidings of hospital characters what are the telling variety betwixt 2011 and 2012?
  • In tidings of socio-economic waverings what are the telling variety betwixt 2011 and 2012?
  • Based on your judgments in which years hospitals had rectify enterprise? How hospital enterprise cognate to hospital characteristics and socio-economic characteristics? Delight transcribe at lowest three ocean unanalogous movements betwixt 2011 and 2012.

To narration the “Per Capita Hospital Beds to Population”, you insufficiency to binder-apart “total_hospital_beds/ tot_population)

Table 1. Pictorial statistics betwixt hospitals in 2011 & 2012

2011

2012

p-value

N

Mean

St. Dev

N

Mean

St. Dev

Hospital Characteristics

1. Hospital beds

100

150

0.004

2. Calculate of hired Employee

3. Calculate of non-hired Employee

4. Internes and Residents

5. Classification Membership

6. Total hospital absorb

7. Total hospital produces

8. Hospital net avail

9. Available Medicare days

10. Available Medicaid days

11. Total Hospital Discharge

12. Medicare acquit

13. Medicaid acquit

Socio-Economic Variables

14. Per Capita Hospital Beds to Population

15. Percent of population lower indigence

16. Percent of Female population lower indigence

17. Percent of Male population lower indigence

18. Median Household Income


Question #2 (15 credits): [RStudio Users and Excel Users]

Use the developed exam axiomsset and then solution the aftercited doubts:

  • Compare the aftercited advice betwixt for-profit and non-for-profit hospitals.
  • What are the ocean telling varietys betwixt for-profit and non-for-profit hospitals? Which touchstone is the best fit touchstone? Why?
  • Use a box-contrive and assimilate Hospital net avail betwixt for-profit and non-for-profit hospitals.
  • Show another disseminate contrive and assimilate hospital absorb (x-axes) and produce (y-axes) and examine your judgments?
  • Comparing hospital net-avail which hospitals has rectify enterprise? To solution this doubt foremost value the hospital net avails after a while subtracting hospital absorbs and produces and then use ttouchstone to assimilate the telling varietys betwixt FP and NFP hospitals.
  • Overall, what are the ocean telling varietys betwixt for-profit and non-for-profit hospitals?

Table 2. Pictorial statistics betwixt FP & NFP

For Profit

Non-For-Profit

p-value

N

Mean

St. Dev

N

Mean

St. Dev

Hospital Characteristics

1. Hospital beds

2. Calculate of hired Employee

3. Calculate of non-hired Employee

4. Internes and Residents

5. Classification Membership

6. Total hospital absorb

7. Total hospital produces

8. Hospital net avail

1.5

1.75

0.03

9. Available Medicare days

10. Available Medicaid days

11. Total Hospital Discharge

12. Medicare acquit

13. Medicaid acquit

Socio-Economic Variables

14. Per Capita Hospital Beds to Population

15. Percent of population lower indigence

16. Percent of Female population lower indigence

17. Percent of Male population lower indigence

18. Median Household Income

Question #3 (15 credits): [RStudio Users and Excel Users]

The axiomsset provides Herfindahl–Hirschman Proordeal for sanity protection dispense, delight use the herf_ins wavering and solution the aftercited doubts:

For this application you do not insufficiency to value the HHI, but if you enjoy any doubts, delight do not stammer to ask me, but try to understand past environing this you achieve insufficiency that to narration your judgments.

Please reovercome for the tabulate application you used the herf_cat as a hospital Herfindahl protest. For this doubt mould unquestioning to use herf_ins as Herfindahl proordeal for protection dispense.

Use the developed exam axiomsset and then solution the aftercited doubts:

  • In a condensed passage teach the Herfindahl proordeal you can use the relation granted in the tabulate application or any other extract.
  • Compare the aftercited advice betwixt hospitals located in lofty, calm and low competitive sanity protection dispenses?
    • 2.1. What are the ocean telling varietys betwixt hospitals in unanalogous dispenses? (use Anova touchstone)
    • 2.2. What is the application of nature in lofty-competitive sanity protection dispense on hospital produces and absorb?
    • 2.3. Do you apprehend nature in lofty-competitive dispense has confident application on net hospital avails?
    • 2.4. What environing the calculate of Medicare and Medicaid acquit? Do you apprehend hospitals in loftyer alienative dispense past likely to confirm past Medicare and Medicaid patients?
    • 2.5. What is the application of other waverings?

(Note: to solution to the terminal doubt, delight value the kinsman-Medicare-acquit and kinsman-Medicaid-acquit foremost and then run 2 ttest) lofty vs. calm and lofty vs. low competitive dispense), delight prop your judgments after a while box-plot).

Table 3. Comparing hospital characteristics and dispense, 2011 and 2012

High Competitive Market

Moderate Competitive Market

Low Competitive

Market

ANOVA/Chi-Sq (results)

Hospital Characteristics

N

Mean

STD

N

Mean

STD

N

Mean

STD

1. Hospital beds

2. Calculate of hired Employee

3. Calculate of non-hired Employee

4. Internes and Residents

5. Classification Membership

6. Total hospital absorb

7. Total hospital produces

8. Hospital net avail

9. Available Medicare days

10. Available Medicaid days

11. Total Hospital Discharge

12. Medicare acquit-ratio

13. Medicaid acquit-ratio

Socio-Economic Variables

14. Per Capita Hospital Beds to Population

15. Median Household Income

Question #4 (Credits 20)- [RStudio Users]

Linear Retreat Pattern

If you enjoy clarified to composition after a while RStudio, delight run the aftercited pattern and consummate the aftercited tables.

1st Model:

Run a direct pattern and prophesy the variety betwixt hospital beds (use the bed-tot) and hospital’s tenure on hospital net-benefit? Examine your judgment, do you apprehend having loftyer beds has confident application on the hospital net avail? What environing the tenure?
 

Model 1a

Hospital Characteristics

Coef.

St. Err

p-value

Hospital beds

Ownership

For Profit

Non-for profit

Ref.

Ref.

Ref.

Other

N

R-Squared

 

2nd Model:

Now, appreciate the application of nature a constituent of a classification on hospital net avail? And examine your judgment (nor past than 2 lines)? Is it telling?

Model 2

Hospital Characteristics

Coef.

St. Err

p-value

Hospital beds

Ownership

For Profit

Non-for profit

Other

Membership

System Membership

N

R-Squared

3nd Model:

Now, enclose the kinsman of kinsman-Medicare-acquit and kinsman-Medicaid-acquit in your pattern? How do you evaluate the application of having loftyer Medicare and Medicaid patients on hospital produces?

Model 3

Hospital Characteristics

Coef.

St. Err

p-value

Hospital beds

Ownership

For Profit

Non-for profit

Other

Membership

System Membership

Socio-Economic Characteristics

Medicare acquit kinsman

Medicaid acquit kinsman

N

R-Squared

Based on your judgment delight applaud 3 policies to ameliorate hospital enterprise, delight mould unquestioning to use the developed pattern for your applaudation.

Discuss your judgments.

Question #4 (Credits 20)- [Excel Users]

Linear Retreat Pattern

If you enjoy clarified to composition after a while Excel, delight run the patterns and consummate the aftercited tables.

Model 1:

Run a direct pattern and prophesy the variety betwixt hospital beds (use the bed-tot) and hospital net-avail in instruction hospitals?
Y(benefit), B0+B1(beds)

Hospital Characteristics

Coef.

ST. ERR

T Stat

P-values

Lower 95%

Upper 95%

Model-1

Hospital beds

N

R Square

 

Model 2:

Run a direct pattern and prophesy the variety betwixt hospital beds (use the bed-tot) and hospital net-avail in non-instruction hospitals?

Use the results from pattern 1 and pattern 2 and assimilate the results betwixt instruction and non-instruction hospitals.

Hospital Characteristics

Coef.

ST. ERR

T Stat

P-values

Lower 95%

Upper 95%

Model-2

Hospital beds

N

R Square

Model 3:

Now, enclose the kinsman of kinsman-Medicare-acquit and kinsman-Medicaid-acquit in foremost pattern? How do you evaluate the application of having loftyer Medicare and Medicaid patients on hospital net-avail in instruction hospitals?

Hospital Characteristics

Coef.

ST. ERR

T Stat

P-values

Lower 95%

Upper 95%

Model-3

Hospital beds

ratio-Medicare-discharge

ratio-Medicaid-discharge

N

R Square

Model 4:

Now, enclose the kinsman of kinsman-Medicare-acquit and kinsman-Medicaid-acquit in foremost pattern? How do you evaluate the application of having loftyer Medicare and Medicaid patients on hospital net-avail in non-instruction hospitals?

Hospital Characteristics

Coef.

ST. ERR

T Stat

P-values

Lower 95%

Upper 95%

Model-4

Hospital beds

ratio-Medicare-discharge

ratio-Medicaid-discharge

N

R Square

Based on your judgment delight applaud 3 policies to ameliorate hospital enterprise, delight mould unquestioning to use the developed pattern for your applaudation.

Question #5 (Credits 20) [RStudio Users]

If you enjoy clarified to composition after a while RStudio, delight run three patterns and consummate the aftercited tables.

Model 1: Run a logit pattern and use nature a constituent of netcomposition and confront out its application on hospital beds and hospital tenure? (Model 1)

Hospital Characteristics

Coef.

St. Err

p-value

Hospital beds

Ownership

For Profit

Non-for profit

Other

N

AIC

Model 2: Now, enclose hospital produce and narration the Coeff.? (Model 2)

Hospital Characteristics

Coef.

St. Err

p-value

Hospital beds

Ownership

For Profit

Non-for profit

Other

Hospital produce

N

AIC

Model 3: Now, enclose the kinsman of kinsman-Medicare-acquit and kinsman-Medicaid-acquit in your pattern? And binder all waverings you used for patterns 1, 2 & 3 and examine your judgments? Do you applaud bindering constituentship for a hospital? Why or why not? (Model 3)

Hospital Characteristics

Coef.

St. Err

p-value

Hospital beds

Ownership

For Profit

Non-for profit

Other

Hospital produce

Medicare acquit kinsman

Medicaid acquit kinsman

N

AIC

Based on your judgment delight applaud 3 policies to ameliorate hospital enterprise in FP, NFP hospitals, delight mould unquestioning to use the developed pattern for your applaudation.

Question #5 (Credits 20)- [Excel users]

If you enjoy clarified to composition after a while Excel, delight run balancehead three patterns and consummate the aftercited tables.

Model 1: Run a retreat pattern and use nature a constituent of netcomposition and confront out its application on hospital absorb? (Model 1)

Coef.

ST. ERR

T Stat

P-values

Lower 95%

Upper 95%

Model-1

Hospital absorb

N

R Square

Model 2: For the 2nd pattern run a retreat pattern and use nature a constituent of netcomposition and confront out its application on hospital absorb and hospital produce? (Model 2)

Coef.

ST. ERR

T Stat

P-values

Lower 95%

Upper 95%

Model-2

Hospital absorb

Hospital Revenue

N

R Square

Model 3: For the 3rd pattern run a retreat pattern and use nature a constituent of netcomposition and confront out its application on kinsman-Medicare-acquit and kinsman-Medicaid-discharge.

Coef.

ST. ERR

T Stat

P-values

Lower 95%

Upper 95%

Model-3

Hospital absorb

Hospital Revenue

Medicare acquit kinsman

Medicaid acquit kinsman

N

R Square

Based on your judgment delight applaud 3 policies and examine the application of nature on a netcomposition on hospital absorb, hospital produce and out its application on kinsman-Medicare-acquit and kinsman-Medicaid-discharge. Do you applaud bindering constituentship for a hospital? Why or why not?

Question 6: (15 credits) [RStudio Users and Excel Users]]

1. Delight adduce a investigation doubt for the con-balance using cosmical matter investigation.

2. Teach the variety betwixt the investigation regularity involving cosmical matters and the investigation regularity not involving cosmical matters.

3. Examine holy implications excluded cosmical matter investigation studies.

4. Teach the governance of the cosmical matter investigation studies balance the axioms and the regularity.

5. Provide examples of the consequences for not meeting IRB (Institutional Review Board) protocol requirements.

LINK to DATA: https://drive.google.com/file/d/0B1N15WfHIN43c3RhcnRlcl9maWxl/view?usp=sharing, https://docs.google.com/document/d/1ePoFxp8nXMgOlNO4vHnWWVe4KZll_5R_riC7bSLjdC0/edit?usp=sharing, https://drive.google.com/file/d/1lguv1FDlVyF5xWKAT_TCvxQF6WDKNCxe/view?usp=sharing, https://drive.google.com/file/d/1pGOnhP0VK5hjLMntb...