Statistical
Excel 2016
◉ 18 views
=FORECAST.ETS.SEASONALITY()
Returns the length of the repetitive pattern Excel detects for the specified time series.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])
Hover argument names in the table for details.
Output typeNumber
Popularity8 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =FORECAST.ETS.SEASONALITY() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
values |
Range | Required | Values are the historical values, for which you want to forecast the next points. |
timeline |
Range | 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 |
Number | Optional | 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 |
Number | 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. |
▣ Examples
Example 1
=FORECAST.ETS.SEASONALITY(B2:B49, A2:A49)
Example 2
=FORECAST.ETS(A50, B2:B49, A2:A49, FORECAST.ETS.SEASONALITY(B2:B49, A2:A49))
✦ Tips
- The function FORECAST.ETS.SEASONALITY is not available in Excel for the Web, iOS, or Android.
⚠ Common Errors
#NUM!
If a constant step can't be identified in the provided timeline, FORECAST.ETS.SEASONALITY will return the #NUM! error.
Fix: مطمئن شوید تاریخهای خط زمانی گام ثابتی دارند و مقدار صفر ندارند.
#VALUE!
If timeline contains duplicate values, FORECAST.ETS.SEASONALITY will return the #VALUE! error.
Fix: مقادیر تکراری را از خط زمانی حذف کنید.
#N/A
If the ranges of the timeline and values aren't of same size, FORECAST.ETS.SEASONALITY will return the #N/A error.
Fix: Make the two ranges the same size
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!