FORECASTING BOOTCAMP #4 Triple Exponential Smoothing in Excel (Holt - Winters method)

preview_player
Показать описание
This tutorial explains clearly the Triple Exponential Smoothing forecasting method.

If the Simple Exponential Smoothing was taking into account only the Level, the Double Exponential Smoothing added the Trend, now we take also into account the seasonality.

Clear explanation for the underlying math of this model.

Bibliography:

Data Science for Supply Chain Forecasting by Nicolas Vandeput

Business Analytics by Jeffrey D. Camm

#excel #statistics #regression #forecasting
Рекомендации по теме
Комментарии
Автор

Great tutorial. Could I have possibly stupid question please? How do I utilize this method for multiple items within single supplier?

dariuxk
Автор

Thank you so much for your video. Really appreciate your efforts. One clarification, in vedio 8:57 Formula in Excel says Previous quarter level Plus Previous quarter Trend, where as in screen shot of formula it says Current quarter level plus current quarter trend. which is correct. Can you please confirm.

abdulrahaman
Автор

In this, multiplicative method has been used then why trend has been computed using additive method. The equation used here is beta*((l(t)-l(t-1)) rather than beta*((l(t)/l(t-1))
Please suggest?

savitribhattar