Need repair to assignment-Deliverable 7 - Statistical Analysis Report

profilejeffro401
Deliverable_07_Data_ma22.xlsx
Home>Mathematics homework help>Statistics homework help>Need repair to assignment-Deliverable 7 - Statistical Analysis Report

Names

Patient # Infectious Disease Age
1 Yes 69
2 Yes 35
3 Yes 60
4 Yes 55
5 Yes 49
6 Yes 60
7 Yes 72
8 Yes 70
9 Yes 70
10 Yes 73
11 Yes 68
12 Yes 72
13 Yes 74
14 Yes 69
15 Yes 46
16 Yes 48
17 Yes 70
18 Yes 55
19 Yes 49
20 Yes 60
21 Yes 72
22 Yes 70
23 Yes 76
24 Yes 56
25 Yes 59
26 Yes 64
27 Yes 71
28 Yes 69
29 Yes 55
30 Yes 61
31 Yes 70
32 Yes 55
33 Yes 45
34 Yes 69
35 Yes 54
36 Yes 48
37 Yes 60
38 Yes 61
39 Yes 50
40 Yes 59
41 Yes 60
42 Yes 62
43 Yes 63
44 Yes 53
45 Yes 64
46 Yes 50
47 Yes 69
48 Yes 52
49 Yes 68
50 Yes 70
51 Yes 69
52 Yes 59
53 Yes 58
54 Yes 69
55 Yes 65
56 Yes 61
57 Yes 59
58 Yes 71
59 Yes 71
60 Yes 68
Age
Mean 61.8166666667
Standard Error 1.1521269122
Median 61.5
Mode 69
Standard Deviation 8.9243366874
Sample Variance 79.6437853107
Kurtosis -0.0919374216
Skewness -0.6496259444
Range 41
Minimum 35
Maximum 76
Sum 3709
Count 60
Confidence Level(95.0%) 2.3054006263
Midrage 55.5 =(D74+D75)/2
MU 65
T 3.6676040039 =(D80-D65)*D69/SQRT(D77)
Df 59 =D77-1 T-Value 3.6676040039
Critical T 2.0009953781 =TINV(0.05,D82) Critical T 2.0009953781
P 0.0002636193 =TDIST(D81,D82,1) P-Value 0.0002636193
Upper Limit 64.122067293 =D78+D65
Lower Limit 59.5112660404 =D65-D78