Calculate Confidence Intervals and Comparing Independence Means

You will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset. Attached below.

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 tools of 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 the Standard Error of the mean (not the standard deviation).

4. Create a Word document and use your calculated results to describe the expected value and range for each of the variables.

5. Make sure you note and explain any differences in the means of the variables, and any effect you observed after changing the level of confidence.

Part 2, you will use the confidence intervals calculated to determine if two means are the same.

Steps Comparing Two Independent Means

1. Using Part 1 above

2. Identify the means and confidence intervals for the resting heart rate for mean and women.

3. Use the 95% confidence intervals to determine if the resting male heart is the same as the resting female heart.

4. Repeat the comparison for the 99% confidence interval.

5. In a Word document, explain why you think the two means are or are not the same with a 95% level of confidence. Be certain to repeat your argument for a 99% level of confidence.

Additional Instructions:

Your assignment should be typed into a Word or other word processing document, formatted in APA style.

Students are often burdened with the task of writing essays. They need to master various academic topics, understand how to integrate facts and arguments, and organize all of this information in a clear and logical way. This is not an easy task for many students. But fear not! We’ve got your back. Here at MoreEssays.com, we offer professional academic help that can take on all these tasks on your behalf. All you need to do is fill out the ** Order** form with your paper’s details, and we will get started on it right away!

Click Here to get this paper done within your deadline