=FORECAST.ETS.SEASONALITY(target_date, values, timeline, [seasonality], [data_completion], [aggregation])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single FORECAST.ETS.SEASONALITY formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
target_date:
The date for which you want to predict a value based on the historical data.
values:
The range of historical data points that you want to use for forecasting.
timeline:
The range of dates that corresponds to the historical data points in values.
seasonality:
An optional parameter that specifies the length of the seasonal pattern. If omitted, Excel automatically detects the seasonality.
data_completion:
An optional parameter that determines how to handle missing data points. If omitted, Excel assumes that missing data points should be interpolated.
aggregation:
An optional parameter that specifies the method of aggregating the data when there are multiple values for the same timestamp. If omitted, Excel uses the default aggregation method.
The FORECAST.ETS.SEASONALITY function in Excel is a powerful tool that helps you determine the length of a seasonal pattern in a time series dataset. This function is particularly useful for analyzing data that exhibits seasonal trends, allowing you to understand how often these patterns repeat over a specified time period.
In simpler terms, the FORECAST.ETS.SEASONALITY function helps you identify the seasonality of your data, making it easier to make predictions based on historical trends.
Imagine you are analyzing monthly sales data for a retail store, and you have the following data in an Excel spreadsheet:
| Month | Sales Amount |
|---|---|
| January | 500 |
| February | 600 |
| March | 700 |
| April | 800 |
| May | 900 |
| June | 1000 |
| July | 1100 |
| August | 1200 |
| September | 1100 |
| October | 1000 |
| November | 900 |
| December | 800 |
You want to find out the seasonal pattern length for the sales data.
To calculate the seasonality of the sales data, you would use the FORECAST.ETS.SEASONALITY formula as follows:
=FORECAST.ETS.SEASONALITY(B2:B13, A2:A13, 1)When you apply the formula, it calculates the length of the seasonal pattern in the sales data. The output would be:
| Seasonal Pattern Length |
|---|
| 12 |
Here, the seasonal pattern length is calculated as 12, indicating that the sales data exhibits a yearly seasonal trend.
The FORECAST.ETS.SEASONALITY function is particularly useful when you need to analyze time series data that has repeating patterns. It allows you to understand the frequency of these patterns, which can be crucial for making accurate forecasts and informed business decisions.
Understanding how to use the FORECAST.ETS.SEASONALITY function can significantly enhance your forecasting capabilities in Excel, enabling you to extract meaningful insights from your time series datasets.
Happy forecasting!
You have a dataset where Column A contains monthly sales figures for a product over the past three years, and you want to analyze the seasonal patterns in sales. By using the FORECAST.ETS.SEASONALITY function, you can determine the length of the seasonal cycle in your sales data. This helps in understanding how sales fluctuate throughout the year, allowing for better inventory management and marketing strategies tailored to peak sales periods, without needing to delve into complex time series analysis.
Beyond the FORECAST.ETS.SEASONALITY function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.