Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started