Explore BrainMass

Explore BrainMass

    Statistics

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

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 6:48 pm ad1c9bdddf
    https://brainmass.com/business/business-math/statistics-75724

    Solution Summary

    Excel file contains solution by both manual and excel method. It contains ANOVA analysis and calculate p -value

    $2.19

    ADVERTISEMENT