FORECAST.ETS.STAT

FORECAST.ETS.STAT(values, timeline, statistic_type [,seasonality] [,data_completion] [,aggregation])

Returns the statistical value for a future value.

values	The historical values.
timeline	The array or range of cells.
statistic_type	The number indicating which statistic to use: 1 = Alpha parameter of ETS algorithm 2 = Beta parameter of ETS algorithm 3 = Gamma parameter of ETS algorithm 4 = MASE metric 5 = SMAPE metric 6 = MAE metric 7 = RMSE metric 8 = Step Size detected
seasonality	(Optional) The number indicating whether to use seasonality: 1 - automatically detected uses positive whole numbers (default) 0 - no seasonality, therefore linear
data_completion	(Optional) The number indicating how to handle missing points: 1 - use the average of the neighbouring points (default) 0 - use zero for any missing points
aggregation	(Optional) The type of function to use: 1 = AVERAGE (default) 2 = COUNT 3 = COUNTA 4 = MAX 5 = MIN 6 = MEDIAN 7 = SUM

REMARKS

* ETS stands for Exponential Triple Smoothing.
* You can use the FORECAST.LINEAR function to return the future y-value along a linear trend using existing values.
* You can use the FORECAST.ETS function to return the future value based on historical values.
* You can use the FORECAST.ETS.CONFINT function to return the confidence interval for a future value.
* You can use the FORECAST.ETS.SEASONALITY function to return the length of the repetitive seasonality pattern.
* This function was added in Excel 2016.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	xx