Statistic UNIT 6 Comparing Two Independent Means

profilejmjewett
HeartRateDataUnit4AutoRecovered.xlsx
Home>Mathematics homework help>Statistics homework help>Statistic UNIT 6 Comparing Two Independent Means

Heart rate

Heart rate before and after exercise After Exercise Resting
M=0 F=1 Resting After Exercise Bin Female Male Female Male five summary numbers Male and Female
0 85.9 87.5 68.0 Bin Frequency Bin Frequency Bin Frequency Bin Frequency Male Resting After Exercise
0 67.7 79.4 70.0 68.0 0 68.0 0 59.0 0 59.0 1 Resting After Exercise
0 80.3 93.4 72.0 70.0 0 70.0 1 61.0 0 61.0 0 Minimum 59 68.16 Mean 81.022 Mean 90.71698
0 85.2 97.7 74.0 72.0 0 72.0 2 63.0 0 63.0 0 Quartile 1 75.2 84.656 Standard Error 0.4753523739 Standard Error 0.4954399622
0 86.3 99.7 76.0 74.0 1 74.0 0 65.0 0 65.0 1 Median 80.1 90.352 Median 80.5 Median 90.45
0 76.6 83.7 78.0 76.0 0 76.0 2 67.0 1 67.0 0 Quartile 3 85.975 96.063 Mode 85.2 Mode 99.692
0 94.4 101.9 80.0 78.0 0 78.0 0 69.0 2 69.0 1 Maximum 96.1 106.664 Standard Deviation 6.7224977411 Standard Deviation 7.0065791393
0 86.4 100.6 82.0 80.0 1 80.0 3 71.0 1 71.0 8 five summary numbers Sample Variance 45.1919758794 Sample Variance 49.0921512358
0 83.4 97.4 84.0 82.0 2 82.0 8 73.0 1 73.0 4 Female Kurtosis 0.0744344943 Kurtosis 0.1967428015
0 89.8 97.4 86.0 84.0 4 84.0 7 75.0 4 75.0 11 Resting After Exercise Skewness -0.0548926259 Skewness -0.2773385386
0 88.7 97.1 88.0 86.0 8 86.0 11 77.0 11 77.0 11 Minimum 65.3 72.824 Range 38.3 Range 38.504
0 78.4 87.2 90.0 88.0 10 88.0 11 79.0 10 79.0 15 Quartile 1 77.9 87.69 Minimum 59 Minimum 68.16
0 71.3 79.9 92.0 90.0 12 90.0 4 81.0 16 81.0 7 Median 80.8 90.576 Maximum 97.3 Maximum 106.664
0 92.6 104.7 94.0 92.0 17 92.0 13 83.0 10 83.0 10 Quartile 3 85.8 94.615 Sum 16204.4 Sum 18143.396
0 86.2 95.9 96.0 94.0 10 94.0 7 85.0 8 85.0 6 Maximum 97.3 104.48 Count 200 Count 200
0 83.9 93.9 98.0 96.0 7 96.0 11 87.0 8 87.0 11 five summary numbers Male
0 78.1 90.1 100.0 98.0 5 98.0 11 89.0 8 89.0 9 Male and Female Resting After Exercise
0 64.0 70.7 102.0 100.0 6 100.0 6 91.0 4 91.0 6 Resting After Exercise
0 72.8 86.7 104.0 102.0 5 102.0 5 93.0 2 93.0 5 Minimum 59 68.16 Mean 80.3851851852 Mean 90.280037037
0 72.7 81.2 106.0 104.0 2 104.0 3 95.0 2 95.0 1 Quartile 1 76.6 86.186 Standard Error 0.6786230725 Standard Error 0.7524832548
0 80.2 83.3 106.0 1 106.0 2 97.0 2 97.0 1 Median 80.1 90.352 Median 80.1 Median 90.352
0 78.2 86.0 More 0 More 1 99.0 1 99.0 0 Quartile 3 85.825 95.753 Mode 74.8 Mode 99.692
0 70.6 90.2 More 0 More 0 Maximum 96.1 106.664 Standard Deviation 7.0524578444 Standard Deviation 7.8200353752
0 75.5 84.4 Sample Variance 49.7371616476 Sample Variance 61.1529532696
0 82.7 94.2 Kurtosis -0.2049871769 Kurtosis -0.1234035199
0 87.7 95.1 Skewness -0.1392970337 Skewness -0.2885778953
0 80.0 88.7 Range 37.1 Range 38.504
0 73.4 82.7 Minimum 59 Minimum 68.16
0 89.5 94.6 Maximum 96.1 Maximum 106.664
0 77.6 84.6 Sum 8681.6 Sum 9750.244
0 76.6 86.4 Count 108 Count 108
0 85.6 96.2 Female
0 74.2 82.1 Resting After Exercise
0 79.0 91.6
0 74.6 86.7 Mean 81.7695652174 Mean 91.2299130435
0 88.8 98.8 Standard Error 0.6535685041 Standard Error 0.6164208219
0 82.1 85.6 Median 80.8 Median 90.576
0 77.6 80.6 Mode 80.6 Mode ERROR:#N/A
0 77.9 83.8 Standard Deviation 6.2688088696 Standard Deviation 5.9125008183
0 88.1 93.9 Sample Variance 39.2979646441 Sample Variance 34.9576659264
0 81.6 90.3 Kurtosis 0.3909319173 Kurtosis 0.2749093787
0 91.2 100.6 Skewness 0.1815881685 Skewness -0.033821973
0 80.3 88.0 Range 32 Range 31.656
0 76.7 91.8 Minimum 65.3 Minimum 72.824
0 88.4 103.0 Maximum 97.3 Maximum 104.48
0 75.2 86.5 Sum 7522.8 Sum 8393.152
0 75.2 84.9 Count 92 Count 92
0 73.1 71.9
0 77.0 84.7
0 59.0 68.2
0 84.9 96.0
0 87.5 105.9
0 75.6 84.3
0 84.0 90.4
0 78.2 94.0
0 86.6 90.6
0 84.9 95.1
0 78.8 90.4
0 69.4 82.6
0 78.3 91.1
0 76.9 92.3
0 84.2 87.9
0 76.3 85.9
0 86.3 99.7
0 72.3 80.9
0 81.8 93.8
0 92.8 99.8
0 74.8 90.2
0 91.7 99.2
0 71.0 87.0
0 96.1 100.2
0 82.5 95.1
0 81.9 97.5
0 89.7 94.8
0 81.4 100.9
0 74.8 94.0
0 88.1 102.1
0 69.2 81.4
0 78.8 90.9
0 85.3 94.2
0 74.8 81.3
0 77.7 89.9
0 78.0 89.8
0 80.5 95.3
0 75.4 84.8
0 81.5 84.2
0 73.9 85.2
0 69.4 74.1
0 89.4 96.7
0 70.9 82.0
0 82.9 90.2
0 89.6 106.7
0 74.5 75.6
0 92.3 102.2
0 87.7 98.0
0 78.9 89.7
0 79.8 81.5
0 85.5 97.4
0 87.3 94.1
0 77.8 97.8
0 71.0 80.1
0 82.5 90.7
0 74.8 83.7
0 69.2 79.4
0 80.5 87.4
0 89.4 99.2
0 74.5 88.0
0 85.5 92.0
1 76.6 88.2
1 79.2 90.4
1 80.6 101.3
1 75.5 93.1
1 83.9 90.5
1 73.9 89.1
1 76.8 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 80.8 86.7
1 78.5 89.9
1 86.3 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 94.9 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 79.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 100.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 92.0
1 85.2 99.2
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 93.5
1 80.6 95.9
1 85.8 90.5
1 84.6 93.0
1 80.5 91.8
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 101.6
1 89.7 94.3
1 78.4 88.0
1 79.9 88.5

Resting: Male

Frequency 59.0 61.0 63.0 65.0 67.0 69.0 71.0 73.0 75.0 77.0 79.0 81.0 83.0 85.0 87.0 89.0 91.0 93.0 95.0 97.0 99.0 More 1 0 0 1 0 1 8 4 11 11 15 7 10 6 11 9 6 5 1 1 0 0

Bin

Frequency

Resting : Female

Frequency 59.0 61.0 63.0 65.0 67.0 69.0 71.0 73.0 75.0 77.0 79.0 81.0 83.0 85.0 87.0 89.0 91.0 93.0 95.0 97.0 99.0 More 0 0 0 0 1 2 1 1 4 11 10 16 10 8 8 8 4 2 2 2 1 0

Bin

Frequency

After Exercise: Male

Frequency 68.0 70.0 72.0 74.0 76.0 78.0 80.0 82.0 84.0 86.0 88.0 90.0 92.0 94.0 96.0 98.0 100.0 102.0 104.0 106.0 More 0 1 2 0 2 0 3 8 7 11 11 4 13 7 11 11 6 5 3 2 1

Bin

Frequency

After Exercise: Female

Frequency 68.0 70.0 72.0 74.0 76.0 78.0 80.0 82.0 84.0 86.0 88.0 90.0 92.0 94.0 96.0 98.0 100.0 102.0 104.0 106.0 More 0 0 0 1 0 0 1 2 4 8 10 12 17 10 7 5 6 5 2 1 0

Bin

Frequency

Sheet1