In this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset.
Steps
- Open the Heart Rate Dataset in Excel 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.
- 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
Expert Solution Preview
Introduction: Confidence intervals are a measure of the precision or uncertainty of an estimate. They provide a range of values within which we can be confident that the true value of a population parameter lies. In this assignment, we will be calculating confidence intervals for the quantitative variables in the Heart Rate Dataset and using this information to understand what these intervals tell us.
Answer:
To complete this assignment, students should follow the steps outlined in the prompt. First, they should open the Heart Rate Dataset in Excel and identify the quantitative variables. Once they have done this, they should sort the data by category (e.g. male-at-rest, female at-rest, etc.). Using the Data Analysis tools in Excel, they should construct 95% and 99% confidence intervals for all eight categories of the sorted quantitative variables.
Excel will calculate the margin of error given as the “confidence interval” in the output. Using this margin of error, students should create their eight confidence intervals by adding and subtracting it from the sample mean calculated in unit three. This creates a range of values that is the confidence interval.
Once they have their results, students should create a Word document and use their calculated confidence intervals to explain what they tell us. They should compare the 99% and 95% intervals and explain why one is larger than the other even though we use the same sample mean value.
In addition to the steps outlined in the prompt, students should also ensure that their assignment is typed into a Word or other word processing document and formatted in APA style. It should include a running head and a title page with the assignment name, their name, the professor’s name, and the course.