# 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

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...`