Explore BrainMass

Explore BrainMass

    Linear Regression for a Shampoo Company

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 March 4, 2021, 8:16 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.49

    ADVERTISEMENT