Explore BrainMass

Explore BrainMass


    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!

    - 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 November 30, 2021, 3:49 am 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.