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

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.