How To… Forecast Using Exponential Smoothing in Excel 2013

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.

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.

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)