UMGC HMGT400 2021 April Exercise 2 Latest
HMGT400 Research and Data Analysis in Healthcare
Exercise 2
Week 2, Exercise:
Use the dataset from week1 exercise and then answer the following questions:
Compare the following information between teaching and non-teaching hospitals.
What are the main significant differences between teaching and non-teaching hospitals? (use t-test)
Comparing hospital net-benefit, which hospital has better performance? To answer this question first compute the hospital net benefits with subtracting hospital costs and revenues and then use t-test to compare the significant differences between teaching and non-teaching hospitals.
Use a box-plot and compare hospitals-cost and hospital-revenues between teaching and non-teaching hospitals.
Write a short paragraph and describe your findings and their importance for the managerial decision-making. List a specific managerial function and the way the processed date will be used to meet the managerial objectives.
Table 2. Descriptive statistics between teaching and non-teaching hospitals, 2011 & 2012
|
|
|||||||
|
Hospital Characteristics |
Teaching |
Non-Teaching |
p-value |
||||
|
N |
Mean |
St. Dev |
N |
Mean |
St. Dev |
||
|
1. Hospital beds |
|
|
|
|
|
|
|
|
2. Number of paid Employee |
|
|
|
|
|
|
|
|
3. Number of non-paid Employees |
|
|
|
|
|
|
|
|
4. Interns 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 |
|
|
|
|
|
|
|
Use Excel for calculations (mandatory). Make sure to attach the plotted information
(BONUS points:Master RStudio script is available for this exercise (see the RStudio: working toward BONUS points module in week 2), modify as needed for the analysis)
Download data from here: HMGT400HOSP
Download codes for E2 from here:E2-Dplyr
Download codes for E2 from here:E2-no-dplyr
Download E2 question: All Exercises questions
-
Rating:
/5
Solution: UMGC HMGT400 2021 April Exercise 2 Latest