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. (2017). HMGT 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 in a Microsoft Word document:
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 benefits, which hospital type has better performance?To answer this question first compute the hospital net benefits with subtracting hospital costs from revenues and then use t-test to compare the significant differences between teaching and non-teaching hospitals.
- Use a box-plot and compare hospital costs and hospital revenues between teaching and non-teaching hospitals.
- Write a short paragraph describing 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 Employees
|
|
|
|
|
|
|
|
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 Discharges
|
|
|
|
|
|
|
|
12. Medicare discharges
|
|
|
|
|
|
|
|
13. Medicaid discharges
|
|
|
|
|
|
|
|
Limit all figures to 2 decimal places max.
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 (csv file):HMGT400HOSP
Download data from here (xls file):HMGT400HOSPITAL.xls.xlsx
Download codes for E2 from here:E2-Dplyr
Download codes for E2 from here:
E2-no-dplyr