Hello!

I'm having trouble with this practice problem. I tried doing an Annova test (single and two factor) in Excel, but I obviously didn't get the right answer.

Part A

To test whether the mean time needed to mix a batch of material is the same for machines produced by three manufacturers, a chemical company obtained the following data on the time {in minutes) needed to mix the material. Mai-Future? l 2- 3- 1 9 27 20 27 26 1 8 24 32 24 26 27 1 8 (a) Use these data to test whether the popuiation mean times for mixing a batch of material differ for the three manufacturers. Use a = 0.05. State the null and alternative hypotheses. O HO: At least two of the population means are equal. Ha: At least two of the population means are different. 0 Hu:p]:p2#u3 \"a: #1 = \"2 = #3 0 Ho: Not all the population means are equal. \"a: \"1 = #2 = #3 O Ho:l'1=i'2=\"3 Ha: Not all the population means are equal. 0 Ho: #1:!'2:1'3 HE: 111 a: #2 3 #3 nd the value of the test statistic. (Round your answer to two decimal places.) 1151 x Find the p-value. (Round your answer to three decimal places.) p-Vaiue = 0.647 X State your conclusion. 0 Reject Ho' There is not sufcient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. 0 Do not reject H0. There is not sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. 0 Do not reject H0. There is sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. 0 Reject H0. There is sufficient evidence to conclude that the mean time needed to mix a batch of material is not the same for each manufacturer. (b) At the a = 0.05 level of signicance, use Fisher's LSD procedure to test for the equality of the means for manufacturers l and 3. Find the value of LSD. (Round your answer to two decimal places.) LSD = nd the pairwise absolute difference between sample means for manufacturers l and 3. |x.x3| = What conclusion can you draw after carrying out this test?I C) There is a signicant difference between the means for manufacturer 1 and manufacturer 3. 0 There is not a signicant difference between the means for manufacturer 1 and manufacturer 3