Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845