Descriptive statistics between hospitals in 2011 & 2012
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 Employees
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. Make sure to attach the plotted information
Use Excel for calculations (mandatory)
(BONUS points: Use Master RStudio script is available for this exercise, but you need to modify that for this analysis)
Download data from here: HMGT400HOSP
Download RStudio script from here:E1-Codes
Download RStudio script from here (If you were not able to load the DPLYR package use this scrip):E1-Codes-No-Dplyr
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
