CALCULATING CONFIDENCE INTERVAL

profileRhiastudent20
HRDATAWEEK3.xlsx
Home>Mathematics homework help>Statistics homework help>CALCULATING CONFIDENCE INTERVAL

Sheet1

Heart rate before and after exercise
M=0 F=1 Resting After Exercise Male female
0 55.0 65.0 0 1
0 67.7 79.4 0 1
0 80.3 93.4 0 1
0 85.2 97.7 0 1
0 86.3 99.7 0 1
0 76.6 83.7 0 1
0 94.4 101.9 0 1
0 86.4 100.6 0 1
0 83.4 97.4 0 1
0 89.8 97.4 0 1
0 88.7 97.1 0 1
0 78.4 87.2 0 1
0 67.0 79.9 0 1
0 85.0 100.0 0 1
0 86.2 95.9 0 1
0 83.9 93.9 0 1
0 78.1 87.2 0 1
0 64.0 70.7 0 1
0 72.8 86.7 0 1
0 65.0 75.0 0 1
0 80.2 83.3 0 1
0 78.2 86.0 0 1
0 62.0 88.0 0 1
0 75.5 84.4 0 1
0 82.7 89.1 0 1
0 87.7 95.1 0 1
0 76.0 88.7 0 1
0 73.4 82.7 0 1
0 80.1 94.6 0 1
0 77.6 84.6 0 1
0 76.6 86.4 0 1
0 85.6 96.2 0 1
0 74.2 82.1 0 1
0 79.0 91.6 0 1
0 74.6 86.7 0 1
0 88.8 98.8 0 1
0 82.1 85.6 0 1
0 77.6 80.6 0 1
0 77.9 83.8 0 1
0 72.0 93.9 0 1
0 81.6 90.3 0 1
0 91.2 100.6 0 1
0 80.3 88.0 0 1
0 76.7 91.8 0 1
0 88.4 103.0 0 1
0 75.2 86.5 0 1
0 75.2 84.9 0 1
0 73.1 71.9 0 1
0 77.0 84.7 0 1
0 59.0 68.2 0 1
0 84.9 96.0 0 1
0 87.5 105.9 0 1
0 75.6 84.3 0 1
0 84.0 90.4 0 1
0 78.2 94.0 0 1
0 86.6 90.6 0 1
0 84.9 95.1 0 1
0 78.8 90.4 0 1
0 69.4 82.6 0 1
0 78.3 91.1 0 1
0 76.9 92.3 0 1
0 84.2 87.9 0 1
0 76.3 85.9 0 1
0 86.3 99.7 0 1
0 72.3 80.9 0 1
0 81.8 93.8 0 1
0 92.8 99.8 0 1
0 74.8 90.2 0 1
0 91.7 99.2 0 1
0 71.0 87.0 0 1
0 96.1 100.2 0 1
0 82.5 95.1 0 1
0 81.9 97.5 0 1
0 89.7 94.8 0 1
0 81.4 100.9 0 1
0 74.8 94.0 0 1
0 88.1 102.1 0 1
0 69.2 81.4 0 1
0 78.8 90.9 0 1
0 85.3 94.2 0 1
0 74.8 81.3 0 1
0 77.7 89.9 0 1
0 78.0 89.8 0 1
0 80.5 95.3 0 1
0 75.4 84.8 0 1
0 81.5 84.2 0 1
0 73.9 85.2 0 1
0 69.4 74.1 0 1
0 89.4 96.7 0 1
0 70.9 82.0 0 1
0 82.9 90.2 0 1
0 60.1 79.0 0 1
0 74.5 75.6 0 1
0 92.3 102.2 0 1
0 87.7 98.0 0 1
0 78.9 89.7 0 1
0 79.8 81.5 0 1
0 85.5 97.4 0
0 87.3 94.1 0
0 77.8 97.8 0
0 71.0 80.1 0
0 70.0 90.7 0
0 74.8 83.7 0
1 69.2 79.4 total 103 97
1 80.5 87.4
1 89.4 99.2 Male 103
1 74.5 88.0 female 97
1 70.0 100.0
1 60.0 78.1
1 79.2 90.4
1 80.5 101.3
1 75.4 93.1
1 83.7 90.5
1 73.9 89.1
1 76.0 90.8
1 85.2 93.5
1 82.1 93.5
1 76.3 87.0
1 97.0 104.5
1 81.5 86.5
1 65.3 86.3
1 60.8 86.7
1 78.5 89.9
1 60.4 97.6
1 89.8 92.9
1 87.8 98.5
1 76.2 89.9
1 74.2 88.8
1 67.4 78.8
1 75.5 80.2
1 80.0 90.2
1 76.4 88.0
1 60.0 95.7
1 89.2 96.9
1 83.3 87.7
1 85.8 90.4
1 75.3 84.1
1 77.9 99.0
1 70.0 83.0
1 88.0 94.2
1 86.9 95.0
1 87.1 95.9
1 60.3 82.7
1 81.2 90.7
1 82.9 91.9
1 87.4 103.6
1 83.0 90.0
1 76.8 83.3
1 76.9 87.7
1 79.8 88.2
1 83.2 93.0
1 79.5 88.6
1 82.4 89.3
1 80.8 84.2
1 83.2 94.5
1 71.6 81.5
1 82.8 93.1
1 76.8 92.8
1 93.2 89.4
1 91.4 100.9
1 97.3 103.3
1 88.3 90.1
1 80.6 85.2
1 87.4 91.7
1 96.5 99.3
1 77.9 91.6
1 76.1 84.1
1 85.2 89.7
1 68.6 72.8
1 79.4 91.0
1 85.2 99.1
1 74.3 85.6
1 74.3 89.2
1 78.5 98.5
1 80.4 90.8
1 82.9 85.9
1 78.9 90.7
1 78.6 87.0
1 87.5 93.9
1 78.9 91.4
1 80.0 89.1
1 80.4 89.2
1 88.3 90.5
1 80.6 95.9
1 85.8 90.5
1 84.6 93.0
1 90.5 101.2
1 92.4 101.2
1 84.4 96.7
1 82.3 86.9
1 77.2 85.8
1 83.3 82.1
1 86.2 98.9
1 81.3 97.7
1 90.2 96.4
1 78.4 85.5
1 84.7 90.9
1 89.7 94.3
1 78.4 88.0
1 70.0 80.0

GENDER

Male female 103 97

sorted dada

Heart rate for male before exercise male heart rate after exercise
M=0 Resting M=0 After Exercise
0 55 0 65
0 67.7 0 79.368
0 80.3 0 93.352
0 85.2 0 97.668
0 86.3 0 99.692
0 76.6 0 83.744
0 94.4 0 101.896
0 86.4 0 100.576
0 83.4 0 97.356
0 89.8 0 97.432
0 88.7 0 97.108
0 78.4 0 87.156
0 67 0 79.892
0 85 0 100
0 86.2 0 95.908
0 83.9 0 93.876
0 78.1 0 87.2
0 64 0 70.66 Heart rate data after exercise for male
0 72.8 0 86.652
0 65 0 75 Mean 89.6412815534
0 80.2 0 83.268 Standard Error 0.8054563086
0 78.2 0 85.988 Median 90.236
0 62 0 88 Mode 99.692
0 75.5 0 84.42 Standard Deviation 8.1744887367
0 82.7 0 89.1 Sample Variance 66.8222661062
0 87.7 0 95.068 Kurtosis 0.1204345869
0 76 0 88.7 Skewness -0.5080104638
0 73.4 0 82.656 Range 40.9
0 80.1 0 94.58 Minimum 65
0 77.6 0 84.584 Maximum 105.9
0 76.6 0 86.444 Sum 9233.052
0 85.6 0 96.204 Count 103
0 74.2 0 82.128
0 79 0 91.56
0 74.6 0 86.664
0 88.8 0 98.792
0 82.1 0 85.564
0 77.6 0 80.584
0 77.9 0 83.836
0 72 0 93.904
0 81.6 0 90.344
0 91.2 0 100.608
0 80.3 0 87.952
0 76.7 0 91.828
0 88.4 0 102.956
0 75.2 0 86.468
0 75.2 0 84.868
0 73.1 0 71.904
0 77 0 84.68
0 59 0 68.16
0 84.9 0 96.016
0 87.5 0 105.9
0 75.6 0 84.304
0 84 0 90.36
0 78.2 0 93.988
0 86.6 0 90.644
0 84.9 0 95.116
0 78.8 0 90.392
0 69.4 0 82.596
0 78.3 0 91.072
0 76.9 0 92.296
0 84.2 0 87.928
0 76.3 0 85.892
0 86.3 0 99.692
0 72.3 0 80.932
0 81.8 0 93.812
0 92.8 0 99.752
0 74.8 0 90.232
0 91.7 0 99.228
0 71 0 87.04
0 96.1 0 100.224
0 82.5 0 95.1
0 81.9 0 97.496
0 89.7 0 94.848
0 81.4 0 100.876
0 74.8 0 94.032
0 88.1 0 102.104
0 69.2 0 81.428
0 78.8 0 90.892
0 85.3 0 94.152
0 74.8 0 81.332
0 77.7 0 89.868
0 78 0 89.82
0 80.5 0 95.32
0 75.4 0 84.836
0 81.5 0 84.16
0 73.9 0 85.176
0 69.4 male heart rate before exercise 0 74.096
0 89.4 0 96.696
0 70.9 Mean 79.1446601942 0 81.956
0 82.9 Standard Error 0.77287654 0 90.236
0 60.1 Median 78.8 0 79
0 74.5 Mode 74.8 0 75.58
0 92.3 Standard Deviation 7.8438401979 0 102.232
0 87.7 Sample Variance 61.5258290501 0 97.968
0 78.9 Kurtosis 0.4166866046 0 89.676
0 79.8 Skewness -0.4424347851 0 81.532
0 85.5 Range 41.1 0 97.42
0 87.3 Minimum 55 0 94.132
0 77.8 Maximum 96.1 0 97.752
0 71 Sum 8151.9 0 80.14
0 70 Count 103 0 90.7
0 74.8 0 83.732
female statistic before exercise
1 69.2 female hear rate after exercise
1 80.5 1 79.428
1 89.4 female heart rate before exercise 1 87.42
1 74.5 1 99.196
1 70.0 Mean 80.2979381443 1 87.98
1 60.0 Standard Error 0.8075446688 1 100
1 79.2 Median 80.5 1 78.1 female heart rate after exercise
1 80.5 Mode 70 1 90.428
1 75.4 Standard Deviation 7.9533926118 1 101.304 Mean 90.8466391753
1 83.7 Sample Variance 63.2564540378 1 93.12 Standard Error 0.6267467053
1 73.9 Kurtosis 0.6181082477 1 90.476 Median 90.472
1 76.0 Skewness -0.5329459896 1 89.076 Mode ERROR:#N/A
1 85.2 Range 37.3 1 90.812 Standard Deviation 6.1727391782
1 82.1 Minimum 60 1 93.468 Sample Variance 38.1027089622
1 76.3 Maximum 97.3 1 93.464 Kurtosis 0.0507027553
1 97.0 Sum 7788.9 1 86.992 Skewness -0.0694830796
1 81.5 Count 97 1 104.48 Range 31.656
1 65.3 1 86.46 Minimum 72.824
1 60.8 1 86.252 Maximum 104.48
1 78.5 1 86.672 Sum 8812.124
1 60.4 1 89.94 Count 97
1 89.8 1 97.592
1 87.8 1 92.932
1 76.2 1 98.452
1 74.2 1 89.908
1 67.4 1 88.828
1 75.5 1 78.816
1 80.0 1 80.22
1 76.4 1 90.2
1 60.0 1 87.976
1 89.2 1 95.716
1 83.3 1 96.928
1 85.8 1 87.672
1 75.3 1 90.372
1 77.9 1 84.052
1 70.0 1 99.036
1 88.0 1 83
1 86.9 1 94.22
1 87.1 1 94.996
1 60.3 1 95.864
1 81.2 1 82.712
1 82.9 1 90.708
1 87.4 1 91.936
1 83.0 1 103.616
1 76.8 1 90.02
1 76.9 1 83.312
1 79.8 1 87.696
1 83.2 1 88.232
1 79.5 1 92.988
1 82.4 1 88.58
1 80.8 1 89.316
1 83.2 1 84.172
1 71.6 1 94.488
1 82.8 1 81.544
1 76.8 1 93.052
1 93.2 1 92.812
1 91.4 1 89.4
1 97.3 1 100.876
1 88.3 1 103.332
1 80.6 1 90.072
1 87.4 1 85.204
1 96.5 1 91.716
1 77.9 1 99.26
1 76.1 1 91.636
1 85.2 1 84.124
1 68.6 1 89.668
1 79.4 1 72.824
1 85.2 1 91
1 74.3 1 99.1
1 74.3 1 85.612
1 78.5 1 89.212
1 80.4 1 98.54
1 82.9 1 90.836
1 78.9 1 85.936
1 78.6 1 90.676
1 87.5 1 87.024
1 78.9 1 93.9
1 80.0 1 91.376
1 80.4 1 89.1
1 88.3 1 89.236
1 80.6 1 90.5
1 85.8 1 95.904
1 84.6 1 90.472
1 90.5 1 92.964
1 92.4 1 101.2
1 84.4 1 101.216
1 82.3 1 96.696
1 77.2 1 86.932
1 83.3 1 85.848
1 86.2 1 82.072
1 81.3 1 98.908
1 90.2 1 97.692
1 78.4 1 96.368
1 84.7 1 85.456
1 89.7 1 90.9
1 78.4 1 94.348
1 70.0 1 87.956
1 80

Histogram

Resting After Exercise
55.0 65.0
67.7 79.4
80.3 93.4
85.2 97.7
86.3 99.7
76.6 83.7
94.4 101.9
86.4 100.6
83.4 97.4
89.8 97.4
88.7 97.1
78.4 87.2
67.0 79.9
85.0 100.0
86.2 95.9
83.9 93.9
78.1 87.2
64.0 70.7
72.8 86.7
65.0 75.0
80.2 83.3
78.2 86.0
62.0 88.0
75.5 84.4
82.7 89.1
87.7 95.1
76.0 88.7
73.4 82.7
80.1 94.6
77.6 84.6
76.6 86.4
85.6 96.2
74.2 82.1
79.0 91.6
74.6 86.7
88.8 98.8
82.1 85.6
77.6 80.6
77.9 83.8
72.0 93.9
81.6 90.3
91.2 100.6
80.3 88.0
76.7 91.8
88.4 103.0
75.2 86.5
75.2 84.9
73.1 71.9
77.0 84.7
59.0 68.2
84.9 96.0
87.5 105.9
75.6 84.3
84.0 90.4
78.2 94.0
86.6 90.6
84.9 95.1
78.8 90.4
69.4 82.6
78.3 91.1
76.9 92.3
84.2 87.9
76.3 85.9
86.3 99.7
72.3 80.9
81.8 93.8
92.8 99.8
74.8 90.2
91.7 99.2
71.0 87.0
96.1 100.2
82.5 95.1
81.9 97.5
89.7 94.8
81.4 100.9
74.8 94.0
88.1 102.1
69.2 81.4
78.8 90.9
85.3 94.2
74.8 81.3
77.7 89.9
78.0 89.8
80.5 95.3
75.4 84.8
81.5 84.2
73.9 85.2
69.4 74.1
89.4 96.7
70.9 82.0
82.9 90.2
60.1 79.0
74.5 75.6
92.3 102.2
87.7 98.0
78.9 89.7
79.8 81.5
85.5 97.4
87.3 94.1
77.8 97.8
71.0 80.1
70.0 90.7
74.8 83.7
69.2 79.4
80.5 87.4
89.4 99.2
74.5 88.0
70.0 100.0
60.0 78.1
79.2 90.4
80.5 101.3
75.4 93.1
83.7 90.5
73.9 89.1
76.0 90.8
85.2 93.5
82.1 93.5
76.3 87.0
97.0 104.5
81.5 86.5
65.3 86.3
60.8 86.7
78.5 89.9
60.4 97.6
89.8 92.9
87.8 98.5
76.2 89.9
74.2 88.8
67.4 78.8
75.5 80.2
80.0 90.2
76.4 88.0
60.0 95.7
89.2 96.9
83.3 87.7
85.8 90.4
75.3 84.1
77.9 99.0
70.0 83.0
88.0 94.2
86.9 95.0
87.1 95.9
60.3 82.7
81.2 90.7
82.9 91.9
87.4 103.6
83.0 90.0
76.8 83.3
76.9 87.7
79.8 88.2
83.2 93.0
79.5 88.6
82.4 89.3
80.8 84.2
83.2 94.5
71.6 81.5
82.8 93.1
76.8 92.8
93.2 89.4
91.4 100.9
97.3 103.3
88.3 90.1
80.6 85.2
87.4 91.7
96.5 99.3
77.9 91.6
76.1 84.1
85.2 89.7
68.6 72.8
79.4 91.0
85.2 99.1
74.3 85.6
74.3 89.2
78.5 98.5
80.4 90.8
82.9 85.9
78.9 90.7
78.6 87.0
87.5 93.9
78.9 91.4
80.0 89.1
80.4 89.2
88.3 90.5
80.6 95.9
85.8 90.5
84.6 93.0
90.5 101.2
92.4 101.2
84.4 96.7
82.3 86.9
77.2 85.8
83.3 82.1
86.2 98.9
81.3 97.7
90.2 96.4
78.4 85.5
84.7 90.9
89.7 94.3
78.4 88.0
70.0 80.0