Answer the questions using both SPSS AND MS Excel.

Show all of your work in a single report.

Solve the following questions utilizing MS Excel and SPSS tests, do not calculate test statistics and p-values manually. Question 1: In a recent survey, college students were asked the amount of time (in hours) they spend weekly watching television and surfing on the Internet. The researchers were interested in determining whether the time spent on both activities was equal. They collected the following data: Do you have reason at the 0.05 significance level to believe that students spend the same amount of time watching television as they do on the Internet? Question 2: A study was conducted at the Department of Veterinary Medicine at Virginia Tech to determine if the "strength" of a wound from surgical incision is affected by the temperature of the knife. Eight dogs were used in the experiment. A "hot" and a "cold" incision was made on the abdomen of each dog, and the strength was measured. The resulting data appear below. a. Write an appropriate hypothesis to determine if there is a significant difference in strength between the hot and cold incisions. Test at a 0.03 level of significance. b. Test at a 0.08 level of significance. Question 3: To find out whether a new compound will have any effects on leukemia, 8 mice, all with an advanced stage of the disease, are selected. Five mice receive the treatment with the compound and 3 do not. Survival times, in years, from the time the experiment commenced are as follows: Testing at the 0.10 level of significance, did the compound have any effects? Assume the two populations to be normally distributed with unequal variances. \begin{tabular}{|c|c|c|} \hline Dog & Knife & Strength \\ \hline 1 & Hot & 5500 \\ \hline 1 & Cold & 8900 \\ \hline 2 & Hot & 11000 \\ \hline 2 & Cold & 8200 \\ \hline 3 & Hot & 11300 \\ \hline 3 & Cold & 9200 \\ \hline 4 & Hot & 9000 \\ \hline 4 & Cold & 6200 \\ \hline 5 & Hot & 10000 \\ \hline 5 & Cold & 10000 \\ \hline 6 & Hot & 7200 \\ \hline 6 & Cold & 5000 \\ \hline 7 & Hot & 530 \\ \hline 7 & Cold & 880 \\ \hline 8 & Hot & 1400 \\ \hline 8 & Cold & 490 \\ \hline \end{tabular} Solve the following questions utilizing MS Excel and SPSS tests, do not calculate test statistics and p-values manually. Question 1: In a recent survey, college students were asked the amount of time (in hours) they spend weekly watching television and surfing on the Internet. The researchers were interested in determining whether the time spent on both activities was equal. They collected the following data: Do you have reason at the 0.05 significance level to believe that students spend the same amount of time watching television as they do on the Internet? Question 2: A study was conducted at the Department of Veterinary Medicine at Virginia Tech to determine if the "strength" of a wound from surgical incision is affected by the temperature of the knife. Eight dogs were used in the experiment. A "hot" and a "cold" incision was made on the abdomen of each dog, and the strength was measured. The resulting data appear below. a. Write an appropriate hypothesis to determine if there is a significant difference in strength between the hot and cold incisions. Test at a 0.03 level of significance. b. Test at a 0.08 level of significance. Question 3: To find out whether a new compound will have any effects on leukemia, 8 mice, all with an advanced stage of the disease, are selected. Five mice receive the treatment with the compound and 3 do not. Survival times, in years, from the time the experiment commenced are as follows: Testing at the 0.10 level of significance, did the compound have any effects? Assume the two populations to be normally distributed with unequal variances. \begin{tabular}{|c|c|c|} \hline Dog & Knife & Strength \\ \hline 1 & Hot & 5500 \\ \hline 1 & Cold & 8900 \\ \hline 2 & Hot & 11000 \\ \hline 2 & Cold & 8200 \\ \hline 3 & Hot & 11300 \\ \hline 3 & Cold & 9200 \\ \hline 4 & Hot & 9000 \\ \hline 4 & Cold & 6200 \\ \hline 5 & Hot & 10000 \\ \hline 5 & Cold & 10000 \\ \hline 6 & Hot & 7200 \\ \hline 6 & Cold & 5000 \\ \hline 7 & Hot & 530 \\ \hline 7 & Cold & 880 \\ \hline 8 & Hot & 1400 \\ \hline 8 & Cold & 490 \\ \hline \end{tabular}