Description
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
Explanation & Answer
Attached.
Running head: CONFIDENCE INTERVALS
1
Confidence Intervals
Student’s Name
Institutional Affiliation
Course
Date
2
CONFIDENCE INTERVALS
Confidence Intervals
The confidence interval at 95% are tabulated as follows:
Count
mean
Interval of confidence at 95.% lower
Interval of Confidence at 95.% upper
error margin
t(df=106)
Count
mean
Interval of confidence at 95.% lower
Interval of Confidence at 95.% upper
error margin
t(df=92)
Male at Rest
109
80.375
79.041
81.731
1.344
1.981
Female at rest
91
81.771...