Explore BrainMass

Explore BrainMass

    Seasonal Forescasting in Excel

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

    For this assignment, our teacher gave us data for 144 periods and asks us... "use the best forecasting technique for forecast 12 periods into the future.

    State all relevant assumptions, and briefly describe the technique(s) you used."

    Now, I'm assuming this would be a seasonal forecast, but I'm not sure what technique to use.

    We have only covered the following topics so far: 1) Time series analysis: SimpleMovingAverage, Weightedmovingaverage, Exponential Smoothing 2) Differencing 3) Forecast errors: absolute deviation, mean absolute deviation (MAD), and tracking signal 4) Single linear regression 5) Seasonalized time series regression; and nonlinear seasonal forecasting Not sure, but 5 seems likely...I do not know how to set this up in Excel and what "assumptions" to make...can you show me how to run this in Excel? thanks.

    © BrainMass Inc. brainmass.com June 3, 2020, 5:04 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/seasonal-forescasting-in-excel-12847

    Attachments

    Solution Preview

    Please see the attachment.
    <br><br>
    <br><br>You can use Excel to do this analysis. In Excel, you click main menu and look for "Tools", then from "Tools" you can find "Data Analysis". Double ...

    Solution Summary

    This solution contains a detailed explanation of using Excel to do Seasonal Forescasting

    $2.19

    ADVERTISEMENT