FORECAST.ETS.SEASONALITY

Excel Functions

Get length of the seasonal pattern

Syntax

EXCEL

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

Arguments

Parameter	Description
`values`	Existing or historical values (y values).
`timeline`	Numeric timeline values (x values).
`data_completion`	[optional] Missing data treatment (0 = treat as zero, 1 = average). Default is 1.
`aggregation`	[optional] Aggregation behavior. Default is 1 (AVERAGE). See other options below.

Return Value

Season length in timeline units

Details

The FORECAST.ETS.SEASONALITY function returns the length in time of a seasonal pattern based on existing values and a timeline. FORECAST.ETS.SEASONALITY can be used to calculate the season length for numeric values like sales, inventory, expenses, etc. exhibit a seasonal pattern. If a pattern cannot be detected, FORECAST.ETS.SEASONALITY returns zero. In the example shown, the formula in cell H16 is: where C5:C16 contains existing values, and B5:B16 contains a timeline. With these inputs, the FORECAST.ETS.SEASONALITY function returns 4. The result is 4 because the values in C5:C16 represent quarterly sales data, and the length of the season is 1 year, which is 4 quarters. The chart to the right shows this data plotted in a scatter plot. The values argument contains the dependent array or ra

Examples

Example

In the example shown, the formula in cell H16 is: