Business is very good for a chemical company. In fact, it is so good that workers are averaging more than 40 hours per week at each of the chemical company's five plants. However, management is not certain whether there is a difference between the five plants in the average number of hours worked per week per worker. Random samples of data are taken at each of the five plants. The data are analyzed using Excel. The results follow. Explain the design of the study and determine whether there is an overall significant difference between the means at a = .05? Why or why not? What are the values of the means? What are the business implications of this study to the chemical company?
SUMMARY
|
Groups
Plant 1
|
Count
11
|
Sum
636.5577
|
Average
57.87
|
Variance
63.5949
|
|
|
Plant 2
|
12
|
601.7648
|
50.15
|
62.4813
|
|
|
Plant 3
|
8
|
491.7352
|
61.47
|
47.4772
|
|
|
Plant 4
|
5
|
246.0172
|
49.20
|
65.6072
|
|
|
Plant 5
|
7
|
398.6368
|
56.95
|
140.3540
|
|
|
ANOVA
|
|
|
|
|
|
|
Source of Variation
|
SS
|
df
|
MS
|
F
|
P-value F crit
|
|
Between Groups
|
900.0863
|
4
|
225.0216
|
3.10
|
0.026595 2.62
|
|
Within Groups
|
2760.136
|
38
|
72.63516
|
|
|
|
Total
|
3660.223
|
42
|
|
|
|