Explore BrainMass
Share

Using ANOVA to Test Productivity Levels

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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 December 20, 2018, 1:51 am ad1c9bdddf
https://brainmass.com/statistics/analysis-of-variance/using-anova-test-productivity-levels-201603

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