Explore BrainMass
Share

Using ANOVA to Test Productivity Levels

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

© BrainMass Inc. brainmass.com August 18, 2018, 6:02 am ad1c9bdddf

Solution Preview

Please see the attached Excel to understand how the answer has been ...

Solution Summary

Using ANOVA to test productivity levels in excel is determined.

$2.19