WorksheetFunction.Forecast_ETS (Excel)

Calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.

The predicted value is a continuation of the historical values in the specified target date, which should be a continuation of the timeline. You can use this function to predict future sales, inventory requirements, or consumer trends.

Forecast_ETS (Arg1, Arg2, ..., Arg6)

Dim dblArg1 As Double: dblArg1 = 
Dim dblForecast_ETS As Double
dblForecast_ETS = WorksheetFunction.Forecast_ETS(Arg1:=dblArg1, Arg2:=, Arg3:=)

Arguments

Arg1 (Double) - Target Date: the data point for which you want to predict a value. Target date can be date/time or numeric. See Remarks.

Arg2 - Values: the historical values, for which you want to forecast the next points

Arg3 - Timeline: the independent array or range of dates or numeric data. The values in the timeline must have a consistent step between them and can't be zero. See Remarks

Arg4 - Seasonality: A numeric value. See Remarks

Arg5 - Data completions: Although the timeline requires a constant step between data points, Forecast_ETS supports up to 30% missing data, and automatically adjusts for it. See Remarks

Arg6 - Aggregation: Although the timeline requires a constant step between data points, Forecast_ETS aggregates multiple points that have the same time stamp. See Remarks