Question: Thank you! if possible pls explain the excel process in detail- not necessary though data set. The following results were obtained: SST =12,300;SSTR=4,510. (a) Set

Thank you! if possible pls explain the excel process in detail- not necessary though
data set. The following results were obtained: SST =12,300;SSTR=4,510. (a) Set up the ANOVA table for this problem. (Round your values for MSE and F to two decimal places, and your p-value to four decimal places.) (b) Use =0.05 to test for any significant difference in the means for the three assembly methods. State the null and alternative hypotheses. H0 : At least two of the population means are equal. Ha : At least two of the population means are different. H0:1=2=3Ha:1=2=3 H0:1=2=3 Ha: Not all the population means are equal. H0:1=2=3Ha:1=2=3 H0 : Not all the population means are equal. Ha:1=2=3 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 H0. There is not sufficient evidence to conclude that the means of the three assembly methods are not equal. Reject H0. There is sufficient evidence to conclude that the means of the three assembly methods are not equal. Reject H0. There is not sufficient evidence to conclude that the means of the three assembly methods are not equal. Do not reject H0. There is sufficient evidence to conclude that the means of the three assembly methods are not equal
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
