In this assignment, calculate confidence intervals for the quantitative variables in the Heart Rate Dataset.

Steps

1. Open the Heart Rate Dataset in Excel and identify the quantitative variables
2. Make sure the data is sorted by category (e.g.male-at-rest,female at-rest,etc.)
3. Use the Data Analysis toolsof Excel to construct 95%and 99%confidence intervals for all of the sorted quantitative variable.Please note that the statistic being used in the confidence interval of the means, which requires the use of theStandard Errorof the mean (not the standard deviation).
4. use your calculated results to describe the expected value and range for each of the variables.
5. Makesure you note and explain any differences in the means of the variables, and any effect you observed after changing the level of confidence.

Heart rate before and after exercise M=0 F=1 Resting After Exercise 0 85.9 87.5 0 67.7 79.4 0 80.3 93.4 0 85.2 97.7 0 86.3 99.7 0 76.6 83.7 0 94.4 101.9 0 86.4 100.6 0 83.4 97.4 0 89.8 97.4 0 88.7 97.1 0 78.4 87.2 0 71.3 79.9 0 92.6 104.7 0 86.2 95.9 0 83.9 93.9 0 78.1 90.1 0 64.0 70.7 0 72.8 86.7 0 72.7 81.2 0 80.2 83.3 0 78.2 86.0 0 70.6 90.2 0 75.5 84.4 0 82.7 94.2 0 87.7 95.1 0 80.0 88.7 0 73.4 82.7 0 89.5 94.6 0 77.6 84.6 0 76.6 86.4 0 85.6 96.2 0 74.2 82.1 0 79.0 91.6 0 74.6 86.7 0 88.8 98.8 0 82.1 85.6 0 77.6 80.6 0 77.9 83.8 0 88.1 93.9 0 81.6 90.3 0 91.2 100.6 0 80.3 88.0 0 76.7 91.8 0 88.4 103.0 0 75.2 86.5 0 75.2 84.9 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

One Population Statistics Hypothesis test calculator Sample Statistic x-mean 15 enter enter 15 Hypothetical Value Sample Size n 150 enter Sample Standard Deviation 2 enter 0 Difference between sample value and Hypothetical value Standard Error of Statistic SE 0.1633 0.0000 z-score 50% p-value lower (Probability the mean is more than Hypothetical Value) z-score CL 50% p-value upper (Probaility the mean is less than Hypothetical value) 1.645 90% 1.0000 Two-tailed test p-value 1.96 95% 2.576 99% Confidence Intervals using z-scores CL 90% upper 15.27 z 1.645 lower 14.73 CL 95% upper 15.32 z 1.96 lower 14.68 CL 99% upper 15.42 z 2.576 lower 14.58