A clinical trial was conducted to test the effectiveness of the drug zopiclone for treating insomnia

in older subjects. Before treatment with zopiclone, subjects had a mean wake time of 102.8 min.

After treatment with zopiclone, the 26 subjects had a mean wake time of 98.9 min and a

standard deviation of 12.3 min.Assume that the 26 sample values appear to be from a

normally distributed population, and (a) test the claim that after treatment with zopiclone,

subjects have a mean wake time of different from 102.8 min.

b) What is the confidence interval used to support the decision of the hypothesis test?

c) Explain why, or why not, the confidence interval does, or does not, support the results of the hypothesis test.

(Please solve this only using google sheets functions and not manually)