Explore BrainMass

Explore BrainMass


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

    1. The excel file closing stock prices provides data for four stocks over a 6 month period.

    A. Develop a spreadsheet module for forecasting each of the stock prices using simple moving average and simple exponential smoothing.
    B. Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. (You might consider using data tables to facilitate your search).

    © BrainMass Inc. brainmass.com June 4, 2020, 12:37 am ad1c9bdddf


    Solution Summary

    A moving average forecast and exponential smoothing forecast has been performed on stock prices in EXCEL. Further calculations for Forecast Accuracy Measures (Forecast Error, MAD, MSE, MAPD) has been shown in Excel for the two different Forecast techniques and the accuracy of the two forecasts has been compared using these calculations.