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
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
Get step-by-step solutions from verified subject matter experts
