question below 72

HMGT 400 Research and Data Analysis in Health Care-Exercise

Dataset:HMGTHOSP.csv (Please download dataset from the class.)

Required program: for all weeks EXCEL (RStudio or R Programming for BONUS point seekers only).

Author, Hossein Zare, PhD

Citation: Zare, H. (2017). HMGT 400 Research and Data Analysis in Health Care-Exercise. UMUC.EDU

**For each exercise, Master RStudio relevant materials are posted (See the mini-module RStudio: Working toward the BONUS points

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
Hospital Characteristics	N	Mean	St. Dev	N	Mean	St. Dev	p-value
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.

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

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.