Question: Show work please so I can understand how to do it, use excel if possible and the Turkey method! To study the effect of temperature

Show work please so I can understand how to do it, use excel if possible and the Turkey method!


To study the effect of temperature on yield in a chemical process, five batches were produced at each of three temperature levels. The results follow. Temperature 50.C 60.C 70.C 35 29 24 24 31 28 36 33 29 38 22 30 27 30 34 Construct an analysis of variance table. (Round your values for MSE and F to two decimal places, and your p-value to four decimal places.) Source Sum Degrees Mean of Variation of Squares of Freedom F Square p-value Treatments Error TotalUse a 0.05 level of significance to test whether the temperature level has an effect on the mean yield of the process. State the null and alternative hypotheses. O Ho: Not all the population means are equal. Ha: Msoc = M60 C = M70.C O Ho: At least two of the population means are equal. Ha: At least two of the population means are different. O Ho: Msoc = H60.C = M70.C Ha: Not all the population means are equal. O Ho: M50 C = H60.C = M70.C O Ho: M50 C # M60.C $ 170.C Ha: M50.C = H60 C = H70. C Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to four decimal places.) p-value = State your conclusion. Do not reject Ho. There is not sufficient evidence to conclude that the mean yields for the three temperatures are not equal. Reject Ho. There is sufficient evidence to conclude that the mean yields for the three temperatures are not equal. O Reject Ho. There is not sufficient evidence to conclude that the mean yields for the three temperatures are not equal. Do not reject Ho. There is sufficient evidence to conclude that the mean yields for the three temperatures are not equal
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
