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
Click HERE for more HMGT 400 7380 weeks.
If you would like to order an original assignment, please contact info@prowriting.co or text (617) 299-6181. Kindly visit our original assignment website www.prowriting.co