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

Returns the statistical value for a future value.

valuesThe historical values.
timelineThe array or range of cells.
statistic_typeThe 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

* Added in Excel 2016.
* 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.
* For the Microsoft documentation refer to support.microsoft.com

 A
1xx


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top