Compare the following information between teaching and non-teaching hospitals.

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