Access over 20 million homework & study documents

search

Week 1 exercise 1

Content type
User Generated
Rating
Showing Page:
1/1
Exercise #1:
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
Mean
St. Dev
1. Hospital beds
1505
376.6086
560.8998
376.8
579.8366
0.9926
2. Number of paid Employee
1498
1237.2758
1615.7970
1491.1215
1961.6365
0.0001
3. Number of non-paid Employee
30
39.9730
72.5880
44.7698
81.2986
0.8095
4. Total hospital cost
1505
21687332
1.5422
304570722.1
908
214748022.89
294143535.9
8
0.8451
5. Total hospital revenues
1505
22870631
9.0132
323339811.4
229978390.5
321273113.6
0.9135
6. Available Medicare days
1499
16739.161
44
19214.29044
17110.14273
19765.73869
0.6013
7. Available Medicaid days
1484
5301.1988
9207.6992
5366.332805
9340.373488
0.8479
8. Total Hospital Discharge
1500
9492.3260
10898.5997
9544.050758
10994.16965
0.8968
9. Medicare discharge
1499
3230.6237
3388.9569
3598.247889
3785.675
0.0050
10. Medicaid discharge
1481
1130.7272
1757.1576
1119.547397
1740.423493
0.8615
Based on your findings in which years hospitals had better performance? Please write a short paragraph and describe
your findings.
Based on the findings above, hospitals had better financial performance in 2012. The average
hospital revenues increased from $228706319.0132 (S.D = 323339811.4) in 2011 to $
229978390.5 (S.D = 321273113.6) in 2012. In terms of effective treatment and discharge, the
hospitals also performed better in 2012. The average total number of hospital discharge increased
from 9492.3260 (S.D = 10898.5997) in 2011 to 9544.050758 (S.D = 9544.050758) in 2012. The
average hospital cost reduced from $216873321.5422 (S.D.= 304570722.1908 ) in 2011 to
$214748022.89 (S.D.= 294143535.98) in 2012.

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
Exercise #1: 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 2011 2012 Hospital Cha ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4