How To… Forecast Using Exponential Smoothing in Excel 2013




About this tutorial:

Video duration: 6:22
Learn how to use exponential smoothing to forecast future needs in Excel 2013 for Time Series Analysis.

Exponential Smoothing forecasts demand in the next time period by taking into account the actual demand in the current period and the forecasted demand for the current time period.

Please visit (and subscribe to) my YouTube Channel to view methods of forecasting such as the Simple Moving Average and Weighted Moving Average methods.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

15 thoughts on “How To… Forecast Using Exponential Smoothing in Excel 2013

    M. Raed Al-Lulu

    (July 10, 2018 - 6:32 am)

    Remarkable as usual, Mr. Eugene.
    I like all your videos.

    Amit Srivastava

    (July 10, 2018 - 6:32 am)

    Any one can help me , How to measure alfa

    Farris Tayib

    (July 10, 2018 - 6:32 am)

    Eugene,
    Is there away to include lead time?.

    Sabrina High

    (July 10, 2018 - 6:32 am)

    I get it, thanks so much!

    Frank Huo

    (July 10, 2018 - 6:32 am)

    Helpful! Thanks from a industrial engineer

    Blake Seiner

    (July 10, 2018 - 6:32 am)

    Thank you!

    MacCarter Armstrong

    (July 10, 2018 - 6:32 am)

    this guy is wonderful. keep up, Eugene

    Ryan Putranda

    (July 10, 2018 - 6:32 am)

    this is Single Exponential Smoothing

    Nur Umara Yussof

    (July 10, 2018 - 6:32 am)

    this video is very helpful and very clear.however, i am wondering whether you have tutorials on EWMA ?

    Lacey Towers

    (July 10, 2018 - 6:32 am)

    How did you get the initial forecast of 65?

    Arslan Zaidi

    (July 10, 2018 - 6:32 am)

    thank you for the helpful video. Sir, I wanted to know that is it okay if I place the value of alpha as "0.08"?

    Evan Freethy

    (July 10, 2018 - 6:32 am)

    This is a helpful video, but your forecasted values via smoothing consistently underestimate the Actual Demand, is this an issue with alpha?

    Shivi Bhatia

    (July 10, 2018 - 6:32 am)

    Couple of questions- how did you decide on 0.6 as alpha value and how 65 was considered as the initial forecast

    Abolwafa27

    (July 10, 2018 - 6:32 am)

    I like all your videos Mr. Eugene.
    Accept my all respect and admire.

    Greg Gregosky football statistics

    (July 10, 2018 - 6:32 am)

    Thanks is very helpful

Leave a Reply

Your email address will not be published. Required fields are marked *