Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Characteristics Mean St. Dev N Mean St. Dev p-value 1. Hospital beds 1505 376.596 560.908 1525 376.698 579.836 2 Number of paid Employee 1498 1237.276 1615.797 1515 1491.121 1961.637 3. Number of non-paid Employee 30 39.973 72.588 30 44.769 81.298 2168733 3045707 2147480 29414353 4. Total hospital cost 1505 22 22 1525 23 6 2287063 3233398 2299783 32127311 5. Total hospital revenues 1505 19 11 1525 91 4 6 Available Medicare days 1499 16739.16 19214.29 1516 17110.14 19765.74 7. Available Medicaid days 484 5301.199 9207.699 1501 5366.333 9340.373 8 Total Hospital Discharge 1500 9492.326 10898.6 1517 9544.051 10994.17 9. Medicare discharge 1499 3230.624 3388.957 1516 3598.248 3785.675 10. Medicaid discharge 1481 1130.727 1757.158 1498 1119.547 1740.423 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 may need to modify that for this analysis)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started