Explore BrainMass
Share

Explore BrainMass

    Forecasting techniques -regression moving average

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

    Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units

    Quarter Quarter Demand Shown in Thousand (1000) units
    1 121
    2 132
    3 159
    4 160
    5 141
    6 166
    7 189
    8 199
    9 170
    10 190

    Make sure to include the equation for the linear regression calculation.
    Explain 5 factors that could affect forecast accuracy.

    © BrainMass Inc. brainmass.com October 9, 2019, 10:39 pm ad1c9bdddf
    https://brainmass.com/statistics/linear-regression/forecasting-techniques-regression-moving-average-227946

    Solution Preview

    Please see ** ATTACHED ** file(s) for complete solution and details!!

    Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units

    Quarter (X) Demand (Y)
    1 121
    2 132
    3 159
    4 160
    5 141
    6 166
    7 189
    8 199
    9 170
    10 190
    Demand Shown in Thousand (1000) units
    Make sure to include the equation for the linear regression calculation.

    1) Linear regression

    Linear regression equation is
    Y= a + b X

    where

    (X) ...

    Solution Summary

    Performs a linear regression, 8 month moving average & 3 month moving average forecasting techniques.

    $2.19