Problem: Suppose a firm evaluates the productivity of the three shifts of workers who work in their factory. Each shift's performance is measured on the amount of output that is produced during the shift - day, evening, or swing shift. Based on these ratings presented in the table below, produce an ANOVA analysis in Excel (see the example of a 1-way ANOVA in Course Materials), and determine if the average amount of output for any shift is different than the others.
Please show all calculations (especially the calculations of the variances for each shift (how the resultant variance number is derived), and also show the calculations how the P-value is determined - whether by formula or by charts.
Day Evening Swing
6 5 5
8 8 6
9 7 5
8 7 7
8 6 5
9 7 6
7 7 5
8 8 5
7 6 6
7 5 5