A company manufactures printers and fax machines at plants located in Atlanta, Dallas, and Seattle. To measure how much employees at these plants know about quality management, a random sampleof 6 employees was selected from each plant and the employees selected were given a quality awareness examination. The examination scores for these 18 employees are shown in the following table.The sample means, sample variances, and sample standard deviations for each group are also provided. Managers want to use these data to test the hypothesis that the mean examination score is thesame for all three plants.Plant 1Plant 2Plant 3AtlantaDallasSeattle847260747463827461777568726876858168Sample797466meanSamplevariance29.618.035.6Samplestandard5.444.245.97deviationSet up the ANOVA table for these data. (Round your values for MSE and F to two decimal places, and your p-value to four decimal places.)SourceSumDegreesof FreedomMeanFp-valueof Variationof SquaresSquareTreatmentsErrorTotalTest for any significant difference in the mean examination score for the three plants. Use = 0.05. Test for any significant difference in the mean examination score for the three plants. Use a = 0.05.State the null and alternative hypotheses.Hoi H1# Hz # H3Hai H1 = Hz = H3Ho: Not all the population means are equal.Hai H1 = H2 = H3Ho: At least two of the population means are equal.H: At least two of the population means are different.Ho: H1 = H2 = H3Ha: H1# Hz# H3Ho: H1 = H2 = H3H: Not all the population means are equal.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 means for the three plants are not equal.Do not reject Ho. There is sufficient evidence to conclude that the means for the three plants are not equal.Reject Ho. There is sufficient evidence to conclude that the means for the three plants are not equal.Reject Ho. There is not sufficient evidence to conclude that the means for the three plants are not equal.Submi+ AngO O O O

Question

Accepted Answer

Use EXCEL to obtain the ANOVA table.
 
Follow the instruction to obtain the values for table in…