Question: Exercise #2: Using the dataset from week 1 exercise, answer the following questions. Compare the following information between teaching and non-teaching hospitals using a t-test:

Exercise #2:

Using the dataset from week 1 exercise, answer the following questions.

Compare the following information between teaching and non-teaching hospitals using a t-test:

What are the main significant differences between teaching and non-teaching hospitals? (use t-test)

Comparing hospital net-benefit, which hospitals had better performance? (To answer this question, first compute the hospital net benefits by subtracting hospital costs from revenues, then use a t-test to compare the significant differences between teaching and non-teaching hospitals).

Use a box-plot to compare hospital-cost and hospital-revenues between teaching and non-teaching hospitals. Make sure to attach the plotted information.

Write a short paragraph describing your findings highlighting their importance for managerial decision-making. List a specific managerial function and the way the processed data can 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. Total Medicare Discharges

13. Total Medicaid Discharges

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

(Note: Master RStudio script is available for this exercise, but you may need to modify that for this analysis)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!