Spread Formula Reference
FORECAST.ETS.CONFINT
Formula Functions > Functions D to G > FORECAST.ETS.CONFINT

This function calculates confidence interval for predicted value at specified target date.

Syntax

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

Arguments

This function has the following arguments:

Argument Description
target_date Refers to the numeric data specifying the date to predict the value.
values Refers to the numeric data (array) specifying the historical values to forecast the value for.
timeline Refers to the numeric data (range,or array) specifying dates for the values.
confidence_level [Optional] Refers to the numeric data (between 0 and 1) specifying the confidence level for calculated confidence interval.
seasonality [Optional] Refers to the numeric data specifying the length of the season, or number of date periods.
data_completion [Optional] Refers to the numeric data specifying how the algorithm should handle missing points in the timeline.
aggregation [Optional] Refers to the numeric data specifying how the algorithm should aggregate values that have the same timestamp.

Data Types

Accepts numeric values.

Version Available

This function is available in product version 11.0 or later.