FORECAST.ETS applies an exponential triple smoothing (ETS) algorithm to create forecasts that can include trend and seasonal components. The syntax for the FORECAST.ETS is =FORECAST.ETS (target_date, ...
The ARIMA model equivalency to the additive version of Winters method is the ARIMA(0,1,p+1)(0,1,0) p model The moving-average form of the equation is For the additive version of Winters method (see ...
While there are formulas and tools for performing simple functions like addition, subtraction, multiplication, etc. in Excel, exponential calculations could be a little complicated. There is no ...