HMGT 400 Research and Data Analysis in Health Care-Exercise
Dataset:HMGTHOSP.csv (Please download dataset from the class)
Required program: EXCEL (BONUS points for using RStudio or R Programming).
Author, Hossein Zare, PhD
Citation: Zare, H XXXXXXXXXXHMGT 400 Research and Data Analysis in Health Care-Exercise. UMGC.EDU
For each week exercise, Master RStudio codes (for BONUS point seekers) and a video will be posted.
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