Spread.NET 18 Formula Reference
In This Topic
    FORECAST.ETS.SEASONALITY
    In This Topic

    This function calculates length of repetitive pattern detected for specified timeline.

    Syntax

    FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])

    Arguments

    This function has the following arguments:

    Argument Description
    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.
    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.