Excel Function : FORECAST.ETS.SEASONALITY
Category
Statistical
Description
Returns the length of the repetitive pattern Excel detects for the specified time series
Microsoft Excel Reference Page
Syntax and Description of the FORECAST.ETS.SEASONALITY Excel Function
? I don't know the syntax for the FORECAST.ETS.SEASONALITY function in Excel.
About FORECAST.ETS.SEASONALITY Excel Function
The FORECAST.ETS.SEASONALITY function returns the seasonality of the data, as a percentage of the overall trend. The function is useful for identifying whether a time series is seasonal, and if so, the size of the seasonality. The function takes three arguments: the data (a range of cells), the seasonality (the number of seasons in the data), and the type of seasonality (the type of seasonality to calculate). The function returns the seasonality of the data as a percentage of the overall trend.