Explore BrainMass

Explore BrainMass

    Forecast

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

    - Calculate the 3-month moving average and MSE
    a. Exponentially smooth the data and MSE
    b. Explain which method produces better results and why
    c. Forecast the value for period 13 using the better method

    Month
    Yt
    1 80
    2 82
    3 84
    4 83
    5 83
    6 84
    7 85
    8 84
    9 82
    10 83
    11 84
    12 83

    © BrainMass Inc. brainmass.com June 3, 2020, 11:47 pm ad1c9bdddf
    https://brainmass.com/statistics/central-tendency/moving-average-forecast-exponentially-smoothing-and-mse-298486

    Attachments

    Solution Preview

    Dear student, please refer to the attachment for the workings and solutions.

    a) Refer to the attachment 'Solution.xlsx' for the ...

    Solution Summary

    A 3-Month Simple Moving Average Forecast and an Exponentially Smoothed Moving Average Forecast has been performed in EXCEL. Further calculations for Forecast Accuracy Measures (Forecast Error, MSE) has been shown in Excel for the two different Forecast techniques and the two forecasts has been compared using these calculations.

    $2.19

    ADVERTISEMENT