Research and Data Analysis in Health Care-Exercise
The attached dataset, provides some information about hospitals in 2011 and 2012, download the data and then complete the descriptive table. 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 Employee
|
|
|
|
|
|
|
|
|
3. Number of non-paid Employee
|
|
|
|
|
|
|
|
|
4. Total hospital cost
|
|
|
|
|
|
|
|
|
5. Total hospital revenues
|
|
|
|
|
|
|
|
|
6. Available Medicare days
|
|
|
|
|
|
|
|
|
7. Available Medicaid days
|
|
|
|
|
|
|
|
|
8. Total Hospital Discharge
|
|
|
|
|
|
|
|
|
9. Medicare discharge
|
|
|
|
|
|
|
|
|
10. Medicaid discharge
|
|
|
|
|
|
|
|
Based on your findings in which years hospitals had better performance? Please write a short paragraph and describe your findings.
(Note: Master RStudio script is available for this exercise, but you need to modify that for this analysis)
Attachment:- guideline Exercise.rar