I JUST NEED QUESTION 6! CAN YOU PLEASE DO OUT THE EXCEL FOR ME! HERE IS #5 WORK

ID: 3150519 • Letter: I

Question

I JUST NEED QUESTION 6!

CAN YOU PLEASE DO OUT THE EXCEL FOR ME!

HERE IS #5 WORK

1.Do exercise 8.131 on page 360 in the textbook

a.Obtain and interpret a 95% confidence interval for the additional sleep that would be obtained on average for all people using laevohysocyamine hydrobromide

Sample mean=xbar=(1.9+0.8+1.1+0.1+-0.1+4.4+5.5+1.6+4.6+3.4)/10 =23.3/10=2.33

sample variance=s^2=((1.9=2.33)^2 +(0.8-2.33)^2 +…+(3.4-2.33)^2))/10-1

((-0.43)^2+(-1.53)^2+…+(1.07)^2)/9

=36.081/9=4.009

sample standard deviation =s=s2=4.0090=2.0022492.0022

standard error (SE)=s/=0.6332

a=1-0.95=0.05

t(a/2,n-1)=2.2622

margin or error (ME)= t(a/2,n-1) xSE=1.4324

95% confidence interval is given by: xbar + & - =2.33 +&- 1.4324= (0.8976,3.7624)

95% CI is (0.8976, 3.7624)

interpretation: we are 95% confident that this confidence interval contains the true mean

b.Was the drug effective in increasing sleep?Explain your answer.

Yes the drug was effective since 0 is not in this interval

Explanation / Answer

Excel data analysis used

Column1

Mean

2.33

Standard Error

0.633166645

Median

1.75

Mode

#N/A

Standard Deviation

2.002248736

Sample Variance

4.009

Kurtosis

-1.421167166

Skewness

0.385805508

Range

5.6

Minimum

-0.1

Maximum

5.5

Sum

23.3

Count

Confidence Level(99.0%)

2.057687466

Lower limit

0.2723

Upper limit

4.3877