In this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Data Set. Steps Open the Heart Rate

In this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Data Set.

Steps

Open the Heart Rate Excel Data Set 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.

Additional Instructions:

Your assignment should be typed into a Word or other word-processing document, formatted in APA style. The assignments must include

Running head

A title page with

Assignment name

Your name

Professor’s name

Course

Estimated time to complete: 3 hours

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit
Reviews

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

For this discussion, you will use a census website that posts information on variables observed in the city where you live.  Here is the website

For this discussion, you will use a census website that posts information on variables observed in the city where you live.  Here is the website address.  https://www.census.gov/acs/www/data/data-tables-and-tools/data-profiles/2017/Links to an external site. Links to an external site.After you open the website, you can enter the name of your state on the