FORECAST.ETS.CONFINT(target_date, values, timeline [,confidence_level] [,seasonality] [,data_completion] [,aggregation])

Returns the confidence interval for a future value.

target_dateThe date you want to predict.
valuesThe historical values.
timelineThe array or range of cells.
confidence_level(Optional) A number indicating a confidence level between 0 and 1 (exclusive).
seasonality(Optional) A number indicating whether to use seasonality:
1 - automatically detected uses positive whole numbers (default)
0 - no seasonality, therefore linear
data_completion(Optional) A 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)
4 = MAX
5 = MIN
7 = SUM


* Added in Excel 2016.
* ETS stands for Exponential Triple Smoothing.
* You can use the FORECAST.LINEAR function to
* You can use the FORECAST.ETS function to
* You can use the FORECAST.ETS.SEASONALITY function to
* You can use the FORECAST.ETS.STAT function to
* For the Microsoft documentation refer to


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