What are the main significant differences between teaching and non-teaching hospitals?
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
- Hospital beds
- Number of paid Employee
- Number of non-paid Employees
- Interns and Residents
- System Membership
- Total hospital cost
- Total hospital revenues
- Hospital net benefit
- Available Medicare days
- Available Medicaid days
- Total Hospital Discharge
- Medicare discharge
- Medicaid discharge
Use Excel for calculations (mandatory). Make sure to attach the plotted information
