(Solved): Can you solve this using excel and show the formulas A recent study found that 65 children who watc ...

A recent study found that 65 children who watched a commercial for potato chips featuring a celebrity endorser ate a mean of 36 grams of potato chips as compared to a mean of 27 grams for 55 children who watched a commercial for an alternative food snack. Suppose that the sample standard deviation for the children who watched the celebrity-endorsed commercial was 21.2 grams and the sample standard deviation for the children who watched the alternative food snack commercial was 12.8 grams. Complete parts (a) through (d) below. a. Assuming that the population variances are equal and $?=0.05$, is there evidence that the mean amount of potato chips eaten was significantly high for children who watched the celebrity-endorsed commercial? Let population 1 be the weights of potato chips eaten by children who watched the celebrity-endorsed commercial and let population 2 be the weights of potato chips eaten by children who watched the alternative food snack commercial. What are the correct null and alternative hypotheses? 'A. $\begin{array}{r}{H}_0:{?}_1?{?}_2?0\\ H_1:{?}_1?{?}_2>0\end{array}$ C. ${\mathrm{H}}_0:{?}_1?{?}_2?0$ ${\mathrm{H}}_1:{?}_1?{?}_2<0$ B. $\begin{array}{l}{H}_0:{?}_1?{?}_2?=0\\ H_1:{?}_1?{?}_2=0\end{array}$ D. $\begin{array}{l}{H}_0:{?}_1?{?}_2=0\\ H_1:{?}_1?{?}_2?=0\end{array}$ What is the test statistic? ${\mathrm{t}}_{\mathrm{STAT}}=2.75$ (Round to two decimal places as needed.) What is the corresponding p-value? $p$-value $=0.003$ (Round to three decimal places as needed.)