Syntax :

=FORECAST.ETS.SEASONALITY( values, timeline, [data completion], [aggregation] )

Parameters :

• The function parameters are as follows:

values –

• An array of previously known values.

Timeline –

• An independent array of dates/times corresponding to each value.
  This must meet the following requirements:
  The timeline array must be the same length as the values array; however, the dates/times in the timeline must have a constant step length between them.
  Depending on the value of the [data completeness] option, up to 30% of points may be missing and dealt with.
  The timeline may contain duplicates, whose associated values will be aggregated according to the [aggregation] option.

          The timeline’s dates and times can be in any sequence.

[data completion] –

• An optional input that specifies how the algorithm should handle missing timeline points.
  If provided, the [data completion] parameter can have a value of 0 or 1, which means:

[aggregation] –

• An optional parameter that tells the algorithm how to aggregate data with the same timestamp.
  If provided, this can be any integer between 1 and 7, which means: