Research and Data Analysis in Health Care-ExerciseDataset:HMGTHOSP.csv (Please download dataset from the class.)Required program:for all weeks EXCEL 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 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 informationUse Excel for calculations (mandatory)

Research and Data Analysis in Health Care-Exercise Dataset:HMGTHOSP.csv (Please download dataset from the class.) Required program:for all weeks EXCEL Exercise # 1: The attached dataset, provides some...

Research and Data Analysis in Health Care-Exercise

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

Required program:for all weeks EXCEL

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. Make sure to attach the plotted information

Use Excel for calculations (mandatory)

hmgt400hospital-s20iuqnm.xlsx

Answered Same DayJul 03, 2021

Answer To: Research and Data Analysis in Health Care-Exercise Dataset:HMGTHOSP.csv (Please download dataset...

Bolla V V Satyanarayana answered on Jul 05 2021

152 Votes

Sample size(N):
Number of beds in the hospital in 2011:
Using Excel function:
=COUNTIFS(C3:C3032,"2011",F3:F3032,">0")
=1505
Number of beds in the hospital in 2012:
Using Excel function:
=COUNTIFS(C3:C3032,"2012",F3:F3032,">0")
=1525
Mean:
Mean Number Beds in the Hospital in 2011 :
Using Excel function:
=AVERAGEIFS(F3:F3032,C3:C3032,"2011")
=376.6086
Mean Number Beds in the Hospital in 2012 :
Using Excel function:
=AVERAGEIFS(F3:F3032,C3:C3032,"2012")
=376.8
Standard deviation:
Standard deviation of Number Beds in the Hospital in 2011 :
Using Excel function:
=STDEV(F1528:F3032)
=560.8998
Standard deviation of Number Beds in the Hospital in 2012 :
Using Excel function:
=STDEV(F3:F2027)
= 579.8365855
Test statistic value of T in Number of beds in Hospitals
Using Excel function
= ((C3038-F3038)/SQRT(((D3038^2/B3038) +(G3038^2/E3038))))
=-0.01
P-value in the Number of beds in the hospitals:
Using Excel function
=TDIST(ABS(H3038),(B3038+E3038-2),2)
=0.9926
Similarly, we find this all the characteristics of Hospitals
    Characteristics
    2011
    2012
    T-value
    P-value

    N
    Average or Mean
    Standard Deviation
    N
    Average or mean
    Standard deviation


    1.Number of Beds in the Hospital...

SOLUTION.PDF

Research and Data Analysis in Health Care-Exercise Dataset:HMGTHOSP.csv (Please download dataset from the class.) Required program:for all weeks EXCEL Exercise # 1: The attached dataset, provides some...

Answer To: Research and Data Analysis in Health Care-Exercise Dataset:HMGTHOSP.csv (Please download dataset...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment