FORECAST.ETS.SEASONALITY
Returns the length of the repetitive pattern Excel detects for the specified time series
Syntax
FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])
Parameters
- values: Required. The historical values
- timeline: Required. The independent array or range
- data_completion: Optional. How to handle missing points
- aggregation: Optional. The aggregation method
Example
=FORECAST.ETS.SEASONALITY(B2:B14, A2:A14)