The results shown below are mean productivity measurements (average number of assemblies completed per hour) for a random sample of workers at each of three plants. The research question is: Are the mean hourly productivity levels the same for workers in these three plants? Please compute the solution in an Excel document or another similar application.

Hourly Productivity of Assemblers in Plants

Plant Finished Units Produced Per Hour

A (9 workers) 3.6 5.1 2.8 4.6 4.7 4.1 3.4 2.9 4.5

B (6 workers) 2.7 3.1 5.0 1.9 2.2 3.2

C (10 workers) 6.8 2.5 5.4 6.7 4.6 3.9 5.4 4.9 7.1 8.4