Explore BrainMass

Explore BrainMass

    Linear Regression for a Shampoo Company

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

    Management of a shampoo company introduced a new 13.5 ounce pack and used an existing machine with some modifications to fill it. To check the consistency, the following data was used.

    a. using 5 day moving average, what will the data for the 21st day be?
    b. Using Linear Regression, what will the 21st day be?

    Day Data
    1 13.00
    2 14.10
    3 14.20
    4 12.80
    5 13.10
    6 14.00
    7 12.90
    8 13.60
    9 13.20
    10 13.70
    11 13.30
    12 14.00
    13 14.10
    14 13.10
    15 14.10
    16 13.60
    17 14.30
    18 14.40
    19 13.80
    20 13.80

    © BrainMass Inc. brainmass.com June 3, 2020, 8:52 pm ad1c9bdddf
    https://brainmass.com/statistics/linear-regression/156690

    Solution Summary

    This solution shows step-by-step calculations in an Excel file to determine the 21st day using the 5-day moving average and linear regression. A graphical display is included for the linear regression.

    $2.19

    ADVERTISEMENT