Course Project - Phase 2 Inferential Statistics and Analytics homework

profileTwinage12
copy_of_dataset_option_2_2.xlsx

Names

Patient # Infectious Disease Age x-Xbar (x-xbar)sq
1 Yes 69 7.18 51.6003
2 Yes 35 -26.82 719.1336
3 Yes 60 -1.82 3.3003
4 Yes 55 -6.82 46.4669
5 Yes 49 -12.82 164.2669
6 Yes 60 -1.82 3.3003
7 Yes 72 10.18 103.7003
8 Yes 70 8.18 66.9669
9 Yes 70 8.18 66.9669
10 Yes 73 11.18 125.0669
11 Yes 68 6.18 38.2336
12 Yes 72 10.18 103.7003
13 Yes 74 12.18 148.4336
14 Yes 69 7.18 51.6003
15 Yes 46 -15.82 250.1669
16 Yes 48 -13.82 190.9003
17 Yes 70 8.18 66.9669
18 Yes 55 -6.82 46.4669
19 Yes 49 -12.82 164.2669
20 Yes 60 -1.82 3.3003
21 Yes 72 10.18 103.7003
22 Yes 70 8.18 66.9669
23 Yes 76 14.18 201.1669
24 Yes 56 -5.82 33.8336
25 Yes 59 -2.82 7.9336
26 Yes 64 2.18 4.7669
27 Yes 71 9.18 84.3336
28 Yes 69 7.18 51.6003
29 Yes 55 -6.82 46.4669
30 Yes 61 -0.82 0.6669
31 Yes 70 8.18 66.9669
32 Yes 55 -6.82 46.4669
33 Yes 45 -16.82 282.8003
34 Yes 69 7.18 51.6003
35 Yes 54 -7.82 61.1003
36 Yes 48 -13.82 190.9003
37 Yes 60 -1.82 3.3003
38 Yes 61 -0.82 0.6669
39 Yes 50 -11.82 139.6336
40 Yes 59 -2.82 7.9336
41 Yes 60 -1.82 3.3003
42 Yes 62 0.18 0.0336
43 Yes 63 1.18 1.4003
44 Yes 53 -8.82 77.7336
45 Yes 64 2.18 4.7669
46 Yes 50 -11.82 139.6336
47 Yes 69 7.18 51.6003
48 Yes 52 -9.82 96.3669
49 Yes 68 6.18 38.2336
50 Yes 70 8.18 66.9669
51 Yes 69 7.18 51.6003
52 Yes 59 -2.82 7.9336
53 Yes 58 -3.82 14.5669
54 Yes 69 7.18 51.6003
55 Yes 65 3.18 10.1336
56 Yes 61 -0.82 0.6669
57 Yes 59 -2.82 7.9336
58 Yes 71 9.18 84.3336
59 Yes 71 9.18 84.3336
60 Yes 68 6.18 38.2336
3709 4698.9833
61.82
Variance 78.3164
S. D 8.8496547328