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 first part of this paper is concerned with the variance of the smoothed error when the forecasting system being used is exponential smoothing. The expression ...
Crane, D. B., and James R. Crotty. "A Two-Stage Forecasting Model: Exponential Smoothing and Multiple Regression." Management Science 13, no. 8 (April 1966).
Efficient supply chain management relies on accurate demand forecasting. Typically, forecasts are required at frequent intervals for many items. Forecasting methods suitable for this application are ...