Explore BrainMass

Explore BrainMass


    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

    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


    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.