Hi, I desperately need some help with the excel fuctions on how to get to compute these answers and help answering the questions that follow. Thank you in advance!

Starting Weight Final Weight Weight Loss A company wants to (cheaply) test the effects of a weight loss drug they're developing. They claim that the 282 282 Determine for weight loss column drug will help any person who is overweight lose 5 pounds in a week. They decide to conduct a hypothesis test 280 278.5 Sample Mean: at the 99% significance level to further strengthen their claim. Thus they decide to compensate a group of 40 188 179.5 Null Population Mean: people who are overweight to take this drug for a week and come back for a weight in. 273 267 Sample Standard Deviation: Sample Size: They decided to proceed with a hypothesis test and they want to disprove the null hypothesis that their drug 201 194 180 171 Standard Error: does not help people who are overweight with weight loss (that is, m=0) 308 302.5 CI Lower Limit 219 213.5 CI Upper Limit Part A: State the null hypothesis and alternative hypotheses for this particular test. 196 193 181 180 Perform Hypothesis Test 195 187 T-Statistic: Part B: Use the data given to determine the following statistical measures and find the confidence interval at 248 244 T-critical Value(s) 276 275.5 Reject the Null Hypothesis? 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? 213 209 204 203.5 270 270 303 293.5 Part C: Perform a hypothesis test! Which type of tailed-test will you use? Find the t-statistic for the data and 263 257 determine whether to reject the null hypothesis. Hint: the critical value of the t-distribution with 39 degrees of 294 293 freedom is approximately 2.426. If you have two critical values, separate them with commas and list your 277 270 positive value first in the T-Critical Value(s) cell. 191 189.5 184 175 245 242.5 198 196.5 Part D: Were you able to reject the null hypothesis at 99% significance? If so, interpret the significance of this 296 287 rejection. Does it provide sufficient evidence to prove that their drug helps their customers lose 5 pounds in 196 194.5 one week? If you think this is insufficient evidence, describe how you would change the experiment to make it 296 295 more meaningful. 239 229 286 285 232 226 190 190 218 217.5 280 272 314 304.5 227 223 285 279 191 191 188 181 298 290 296 292.5