Identify, analyze, and evaluate quantitative and qualitative healthcare data and information for effective decision making in various healthcare settings? Explain da
Assignment #4: Final
Target:
Identify, analyze, and evaluate quantitative and qualitative healthcare data and information for effective decision making in various healthcare settings
- Explain data to a health care audience in a clear, concise and persuasive manner, consistent with best practices in the field of health care management to inform or advocate change.
- Assess the ethical challenges in designing a research study in the use of human subjects to ensure compliance with national and local standards.
Updated: 3/14/2021
University of Maryland Global Campus (UMGC)
HMGT 400 Research and Data Analysis in Health- FINAL EXAM
Dataset: HMGTFINALEXAM.csv (Please download dataset from the class)
Required program: RStudio or R Programming.
Author, Hossein Zare, PhD
Citation: Zare, H. (2019). HMGT 400 Research and Data Analysis in Health Care. FINAL EXAM. UMGC.EDU
Question #1 (15 credits): [RStudio Users and Excel Users]
The FINAL EXAM dataset, provides some information about hospitals in 2011 and 2012, download the FINAL EXAM data and then complete the descriptive table. Please answer the following questions.
1. In term of hospital characters what are the significant difference between 2011 and 2012?
1. In term of socio-economic variables what are the significant difference between 2011 and 2012?
To report the “Per Capita Hospital Beds to Population”, you need to divide “total_hospital_beds/ tot_population)
1. Based on your findings in which years hospitals had better performance? How hospital performance related to hospital characteristics and socio-economic characteristics? Please write at least three main different movements between 2011 and 2012.
Table 1. Descriptive statistics between 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. Number of paid Employee |
|||||||
3. Number of non-paid Employee |
|||||||
4. Internes and Residents |
|||||||
5. System Membership |
|||||||
6. Total hospital cost |
|||||||
7. Total hospital revenues |
|||||||
8. Hospital net benefit |
|||||||
9. Available Medicare days |
|||||||
10. Available Medicaid days |
|||||||
11. Total Hospital Discharge |
|||||||
12. Medicare discharge |
|||||||
13. Medicaid discharge |
|||||||
Socio-Economic Variables |
|||||||
14. Per Capita Hospital Beds to Population |
|||||||
15. Percent of population under poverty |
|||||||
16. Percent of Female population under poverty |
|||||||
17. Percent of Male population under poverty |
|||||||
18. Median Household Income |
Question #2 (15 credits): [RStudio Users and Excel Users]
Use the final exam dataset and then answer the following questions:
1. Compare the following information between for-profit and non-for-profit hospitals.
1. What are the main significant differences between for-profit and non-for-profit hospitals? Which test is the best fit test? Why?
1. Use a box-plot and compare Hospital net benefit between for-profit and non-for-profit hospitals.
1. Show another scatter plot and compare hospital cost (x-axes) and revenue (y-axes) and discuss your findings?
1. Comparing hospital net-benefit which hospitals has better performance? To answer this question first compute the hospital net benefits with subtracting hospital costs and revenues and then use ttest to compare the significant differences between FP and NFP hospitals.
1. Overall, what are the main significant differences between for-profit and non-for-profit hospitals?
Table 2. Descriptive statistics between FP & NFP
For Profit |
Non-For-Profit |
p-value |
|||||
N |
Mean |
St. Dev |
N |
Mean |
St. Dev |
||
Hospital Characteristics |
|||||||
1. Hospital beds |
|||||||
2. Number of paid Employee |
|||||||
3. Number of non-paid Employee |
|||||||
4. Internes and Residents |
|||||||
5. System Membership |
|||||||
6. Total hospital cost |
|||||||
7. Total hospital revenues |
|||||||
8. Hospital net benefit |
|||||||
9. Available Medicare days |
|||||||
10. Available Medicaid days |
|||||||