Dataset:HMGTHOSP.csv (Please download dataset from the class.)
Required program: for all weeks EXCEL
Author, Hossein Zare, PhD
Citation: Zare, H. (2017). HMGT 400 Research and Data Analysis in Health Care-Exercise. UMGC.EDU
Copy Exercise # 1 from below or download the file for all week exercise from here: All Exercises File
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.
able 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)
Download data from here: HMGT400HOSP
https://statisticsbyjim.com/hypothesis-testing/t-t…
Dataset:HMGTHOSP.csv (Please download dataset from the class.) Required program:
Struggling With this or a similar assignment
Your academic success deserves originality. We don’t sell prewritten essays; each paper is custom-made, plagiarism-free, and AI-free. Order now for a unique paper.
Struggling With this or a similar assignment
Your academic success deserves originality. We don’t sell prewritten essays; each paper is custom-made, plagiarism-free, and AI-free. Order now for a unique paper.
Order Your Custom paper NowYour academic success deserves originality. We don’t sell prewritten essays; each paper is custom-made, plagiarism-free, and AI-free. Order now for a unique paper.