1. What are the main significant differences between teaching and non-teaching hospitals? (use 2 sample t-test assuming equal variances)
2. Comparing hospital net-benefit, which hospital has better performance? To answer this question, first insert a new column into the spreadsheet, then compute the hospital net benefits by subtracting hospital costs from revenues (i.e., Total Hospital Revenue - Total Hospital Cost). Use the 2 sample t-test to compare the significant differences between teaching and non-teaching hospitals.
3. Using a box-plot, compare hospital-cost and hospital-revenues between teaching and non-teaching hospitals.
4. Write short paragraph describing your findings and their importance for the managerial decision-making. List a specific managerial function and the way the analyzed data 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

Round mean and st.dev figures to nearest whole number. Use 2 decimal places for p values.

Use Excel for calculations (mandatory). Make sure to attach the plotted information

Maryland and Virginia