Calculate Confidence Intervals and Comparing Independence Means
You will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset. Attached below.
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.
Your assignment should be typed into a Word or other word processing document, formatted in APA style.