Question

Big Steel Company recorded an efficiency rating at each of its four manufacturing locations every day for a fourteen-day period (provided below). As a member of their evaluation team you are asked if the average efficiency is the same across all locations. Determine your hypotheses, run the appropriate test, and provide the appropriate conclusion to the director of your team.

Location 1	Location 2	Location 3	Location 4
87	81	83	69
75	89	78	99
89	62	73	62
98	71	79	66
94	90	89	99
89	89	73	71
90	86	76	62
99	78	72	82
83	68	92	87
87	92	85	62
60	73	74	81
97	65	76	100
85	73	94	76
94	93	92	75

Answer 1

Run Anova Single factor analysis to find the difference between the means.

Procedure tto run Anova Single factor analysis in excel:

Summary Output:

P-value = 0.10

P-value > α: The differences between the means are not statistically significant

If the p-value is greater than the significance level, you do not have enough evidence to reject the null hypothesis that the population means are all equal.