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 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 make 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.
4. do a Word document, and use your calculated results to explain what the confidence intervals tell us.
5. Compare the 99% and 95% intervals and explain why one is larger than the other even though we use the same sample mean value.