Statistics unit 5 assignment | Statistics homework help


Assessment Unit 5 Calculating Confidence Intervals due Saturday


Evaluation Title: Assignment 5 Rubric

Instructions:: In this assignment,you will calculate confidence intervals for the quantitative variables in the Heart Rate database.


  1. Open the Heart Rate database 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 to construct 95% and 99% confidence intervals for all of the sorted quantitative variables. Please note that the statistic being used is the confidence interval of the means, which requires the use of the Standard Error of the mean (not the standard deviation of the mean)
  4. Create a Word document, using your calculated Excel results, to describe the expected value and range for each of the variables. Make certain you note and explain any differences in the means of the variables, and any effect of changing the level of confidence.

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

Estimated time to complete: 3 hours


Confidence intervals: Against all odds: Inside statistics [Video file]. (2013). Retrieved August 1, 2017, from