WorksheetFunction.Forecast_ETS_STAT (Excel)

Returns a statistical value as a result of time series forecasting.

It isn't necessary to sort the timeline (Arg2), because Forecast_ETS_STAT sorts it implicitly for calculations. If Forecast_ETS_STAT can't identify a constant step in the timeline, it returns run-time error 1004. If the timeline contains duplicate values, Forecast_ETS_STAT also returns an error. If the ranges of the timeline and values aren't all of the same size, Forecast_ETS_STAT returns run-time error 1004. The statistic_type parameter (Arg3) indicates which statistic is requested by this function. The following optional statistics can be returned:

Forecast_ETS_STAT (Arg1, Arg2, ..., Arg6)

Dim dblArg3 As Double: dblArg3 = 
Dim dblForecast_ETS_STAT As Double
dblForecast_ETS_STAT = WorksheetFunction.Forecast_ETS_STAT(Arg1:=, Arg2:=, Arg3:=dblArg3)

Arguments

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

Arg2 - 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

Arg3 (Double) - Statistic_type: A numeric value between 1 and 8, indicating which statistic will be returned for the calculated forecast.

Arg4 - Confidence level: A numerical value between 0 and 1 (exclusive), indicating a confidence level for the calculated confidence interval. See Remarks

Arg5 - Data completions: Although the timeline requires a constant step between data points, Forecast_ETS_STAT 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_STAT aggregates multiple points that have the same time stamp. See Remarks