Sheet1Starting WeightFinal WeightWeight Loss282282Determine for weight loss column280278.5Sample Mean:188179.5Null Population Mean:273267Sample Standard...

Please calculate the confidence intervals, conduct a hypothesis test, and make conclusions about the following data.You may input responses to the questions on the Excel sheet itself or submit a word document instead.

Sheet1 Starting WeightFinal WeightWeight Loss 282282Determine for weight loss column 280278.5Sample Mean: 188179.5Null Population Mean: 273267Sample Standard Deviation: 201194Sample Size: 180171Standard Error: 308302.5CI Lower Limit 219213.5CI Upper Limit 196193 181180Perform Hypothesis Test 195187T-Statistic: 248244T-critical Value(s) 276275.5Reject the Null Hypothesis? 213209 204203.5 270270 303293.5 263257 294293 277270 191189.5 184175 245242.5 198196.5 296287 196194.5 296295 239229 286285 232226 190190 218217.5 280272 314304.5 227223 285279 191191 188181 298290 296292.5 A company wants to (cheaply) test the effects of a weight loss drug they're developing. They claim that the drug will help any person who is overweight lose 5 pounds in a week. They decide to conduct a hypothesis test at the 99% significance level to further strengthen their claim. Thus they decide to compensate a group of 40 people who are overweight to take this drug for a week and come back for a weight in. They decided to proceed with a hypothesis test and they want to disprove the null hypothesis that their drug does not help people who are overweight with weight loss (that is, m=0) Part A: State the null hypothesis and alternative hypotheses for this particular test. Part B: Use the data given to determine the following statistical measures and find the confidence interval at 99% for the average weight loss in one week. Is a 5 pounds loss contained within this confidence interval? If so, does that mean that customers can expect to lose 5 pounds on this drug? Part C: Perform a hypothesis test! Which type of tailed-test will you use? Find the t-statistic for the data and determine whether to reject the null hypothesis. Hint: the critical value of the t-distribution with 39 degrees of freedom is approximately 2.426. If you have two critical values, separate them with commas and list your positive value first in the T-Critical Value(s) cell. Part D: Were you able to reject the null hypothesis at 99% significance? If so, interpret the significance of this rejection. Does it provide sufficient evidence to prove that their drug helps their customers lose 5 pounds in one week? If you think this is insufficient evidence, describe how you would change the experiment to make it more meaningful.