# Learn How to Use Microsoft Excel FORECAST.ETS.SEASONALITY Function

Written by | 0 Comments | 348 Views

In this article, you will learn how to use Microsoft Excel FORECAST.ETS.SEASONALITY function and its prime function in Microsoft Excel. You will also get to know Microsoft Excel FORECAST.ETS.SEASONALITY function returns value and syntax.

Microsoft Excel FORECAST.ETS.SEASONALITY Function

The main purpose of the Microsoft Excel FORECAST.ETS.SEASONALITY function is to get the length of the seasonal pattern. That implies, with the help of FORECAST.ETS.SEASONALITY function you can able to return returns the length in time of a seasonal pattern based on existing values and a timeline. So, with the help of FORECAST.ETS.SEASONALITY function, you can able to get the length of the seasonal pattern.

Return Value of FORECAST.ETS.SEASONALITY Function

The return value will be the confidence interval value.

Syntax of FORECAST.ETS.SEASONALITY Function

=FORECAST.ETS.SEASONALITY(values, timeline, [data-completion], [aggregation])

Where the arguments:

• values: This is the existing or historical values (y values).
• timeline: This is the numeric timeline values (x values).
• data-completion: This is the Missing data treatment, where, 0 = treat as zero, 1 = average and default is 1 (optional).
• aggregation: This is the Aggregation behavior. Default is 1 AVERAGE (optional).

## How to Use Microsoft Excel FORECAST.ETS.SEASONALITY Function?

So we know that, Microsoft Excel FORECAST.ETS.SEASONALITY function you can able to get the length of the seasonal pattern. That implies, with the help of FORECAST.ETS.SEASONALITY function you can able to return returns the length in time of a seasonal pattern based on existing values and a timeline. So, with the help of FORECAST.ETS.SEASONALITY function, you can able to get the length of the seasonal pattern.