Excel Function : FORECAST.ETS.SEASONALITY

Download now!

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

https://support.office.com/en-us/article/FORECASTETSSEASONALITY-function-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.ets.seasonality

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.