Syntax :

=FORECAST.ETS.STAT( values, timeline, statistic_type, [seasonality], [data completion], [aggregation] )

Parameters :

• The function parameters are as follows:

values –

• An array of historical known values that correlate to a set of dates/times.

Timeline –

• An independent array of dates/times corresponding to each value.
  This must meet the following requirements:
  The timeline array and the values array must have the same size.
  Although 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.

statistic type –

• A numeric number that specifies which statistical value should be returned.
  This must be a number between 1 and 8, i.e.

[seasonality] –

• An optional input specifying the algorithm to be used to detect seasonality in data.
  If provided, this must be a positive integer between 0 and 8784, corresponding to:

[data completion] –

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

[aggregation] –

• An optional parameter that tells the algorithm how to aggregate data with the same timestamp.
  This can be any integer between 1 and 7 if provided.