Calculating Confidence Intervals

Open the Heart Rate Dataset in Excel and identify the quantitative variables
Make sure the data is sorted by category (e.g.male-at-rest, female at-rest, etc.)
Use the Data Analysis tools of Excel to construct 95% and 99% confidence intervals for all 8 categories of the
sorted quantitative variables. Excel will calculate the margin of error given as the “confidence interval” in the
output. Use this margin of error to create your 8 confidence intervals by both adding and subtracting it from the
sample mean (calculated in unit 3). This creates a range of values that is the confidence interval.
Create a Word document, and use your calculated results to explain what the confidence intervals tell us. What
do these confidence intervals tell us about our heart rate data? How would you interpret the 95% and 99%
intervals for resting heart rate?
Compare the 99% and 95% intervals and explain why one is larger than the other even though we use the
same sample mean value.