Instructions In this assignment, you will calculate cont dence Intervals for the quantitative varkat in the Heart Rate Steps 1. Open the Heart Rate Excel Dataset In Read Me First and identify the quantitative variables 2. Make sure the data is sorted by category feig male-at rest, female at rest, etc ) 3. Use the Data Analysis took of Excel to construct 95% and 97% confidence interval for all 8 Categories of the sorted quantitative variable. Excel will calculate the margin of error given at the "confidence interval" in the output. Use this margin of error to create your B confidence Interval by both adding and subtracting it from the sample mean icalculated in unit 3. This creates a range of values that is the confidence interval. 4. Create a Word document, and use your calculated newits to coplin what the confidence interich tell us. What do these confidence interval tell us about our heart rate data? How would you interpret the $5% and $7% Intervals for resting heart rate! 5. Compare the $7 and 95% Intervals and explain why one is larger than the other even though we use the way urgh main walur. Additional Instructions Your antonment should be typed into a Word or Aford in APA