Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

Important: The function FORECAST.ETS.SEASONALITY is not available in Excel for the Web, iOS, or Android.

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.

Syntax

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

The FORECAST.ETS.SEASONALITY function syntax has the following arguments:

  • Values    Required. Values are the historical values, for which you want to forecast the next points.

  • Timeline    Required. The independent array or range of numeric data. The dates in the timeline must have a consistent step between them and can’t be zero. The timeline isn't required to be sorted, as FORECAST.ETS.SEASONALITY will sort it implicitly for calculations. If a constant step can't be identified in the provided timeline, FORECAST.ETS.SEASONALITY will return the #NUM! error. If timeline contains duplicate values, FORECAST.ETS.SEASONALITY will return the #VALUE! error. If the ranges of the timeline and values aren't of same size, FORECAST.ETS.SEASONALITY will return the #N/A error.

  • Data completion    Optional. Although the timeline requires a constant step between data points, FORECAST.ETS.SEASONALITY supports up to 30% missing data, and will automatically adjust for it. 0 will indicate the algorithm to account for missing points as zeros. The default value of 1 will account for missing points by completing them to be the average of the neighboring points.

  • Aggregation    Optional. Although the timeline requires a constant step between data points, FORECAST.ETS.SEASONALITY will aggregate multiple points which have the same time stamp. The aggregation parameter is a numeric value indicating which method will be used to aggregate several values with the same time stamp. The default value of 0 will use AVERAGE, while other options are SUM, COUNT, COUNTA, MIN, MAX, MEDIAN.

Download a sample workbook

Click this link to download a workbook with Excel FORECAST.ETS function examples

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Forecasting functions (reference)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.