Question: Exercise #1 : The attached dataset provides some information about hospitals in 2011 and 2012. Download the data, analyze it, then complete the descriptive table

Exercise #1:

The attached dataset provides some information about hospitals in 2011 and 2012. Download the data, analyze it, then complete the descriptive table below. Please use the following format to report your findings.

Table 1. Descriptive statistics between hospitals in 2011 & 2012

Hospital Characteristics

2011

2012

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. Total Hospital Cost ($)

5. Total Hospital Revenues ($)

6. Available Medicare Days

7. Available Medicaid Days

8. Total Hospital Discharges

9. Total Medicare Discharges

10. Total Medicaid Discharges

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

Based on your findings, in which year did hospitals havebetter performance? Please write a short paragraph describing your findings. Make sure to attach any plotted information.

(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!