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...

1 answer below »

View more »
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
153 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

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30