confidence interval for the SLEEP variable
confidence interval for the SLEEP variable
First, find the mean.Under that column, in cell E37, type =AVERAGE(E2:E36).Under that in cell E38, type =STDEV(E2:E36).Now we can find the maximum error of the confidence interval.To find the maximum error, we use the “confidence” formula.In cell E39, type =CONFIDENCE.NORM(0.05,E38,35).The 0.05 is based on the confidence level of 95%, the E38 is the standard deviation, and 35 is the number in our sample.You then need to calculate the confidence interval by using a calculator to subtract the maximum error from the mean (x-E) and add it to the mean (x+E).
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..

