Spread.NET 17 Formula Reference
In This Topic
    FORECAST.ETS.CONFINT
    In This Topic

    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.