Home › Functions › Statistical › FORECAST.ETS.SEASONALITY
fx
FORECAST.ETS.SEASONALITY
Statistical  ·  Since: Excel 2016  ·  9 languages

Returns the length of the repetitive pattern Excel detects for the specified time series. FORECAST.ETS.SEASONALITY can be used following FORECAST.ETS to identify which automatic seasonality was detected and used in FORECAST.ETS. While it can also be used independently of FORECAST.ETS, the functions are tied since the seasonality detected in this function is identical to the one used by FORECAST.ETS, considering the same input parameters that affect data completion.

🌐 Translations

English FORECAST.ETS.SEASONALITY
Deutsch PROGNOSE.ETS.SAISONALITÄT
Français PREVISION.ETS.CARACTERESAISONNIER
Español PRONOSTICO.ETS.ESTACIONALIDAD
Italiano PREVISIONE.ETS.STAGIONALITÀ
Português PREVISÃO.ETS.SAZONALIDADE
Nederlands VOORSPELLEN.ETS.SEASONALITY
Polski REGLINX.ETS.SEZONOWOŚĆ
Русский ПРЕДСКАЗ.ETS.СЕЗОННОСТЬ

📦 Availability

Excel versionAvailable
Excel 2007 ✗
Excel 2013 ✗
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

FORECAST.ETS.SEASONALITY(values,timeline,[data_completion],[aggregation])

Arguments

values (required)
timeline (required)
data_completion (optional)
aggregation (optional)

Related functions

Copied to clipboard