Please find attached the complete work.Kindly do ask in case of any doubtPallvee
MATH 221 Statistics for Decision Making
Week 6 iLab
• Data Simulation
• Confidence Intervals
• Normal Probabilities
Short Answer Writing Assignment
All answers should be complete sentences.
We need to find the confidence interval for the SLEEP variable. To do this, we need to
find the mean and then find the maximum error. Then we can use a calculator to find the
interval, (x – E, x + E).
First, find the mean. Under that column, in cell B38, type =AVERAGE (A2:A36).
Under that in cell A39, type =STDEV (A2:A36), For A40, type=COUNT (A2; A36),
Alpha B44=1-Confidence (95%) Now we can find the maximum error of the confidence
interval. To find the maximum error, we use the “confidence” formula. In cell B45, type
=CONFIDENCE (B44, B39, B40). Then we calculate the confidence interval by using
a calculator to subtract the maximum error from the mean (x-E) and add it to the mean
1. Give and interpret the 95% confidence interval for the hours of sleep a student gets.
A 95% confidence interval for the hours of sleep a student gets is (6.7, 7.7).
With 95% confidence, it can be said that the hours of sleep a student gets is between the
bounds of the confidence interval.
Then, you can go to cell E45 and type =CONFIDENCE (E44, B39, B40) to find the
maximum error for a 99% confidence interval. Again, you would need to use a calculator
to subtract this and add this to the mean to find the actual confidence interval.
2. Give and interpret the 99% confidence interval for the hours of sleep a student gets.
A 99% confidence interval for the hours of s...