FORECAST.ETS.SEASONALITY
Season length detected by ETS.
- Excel: Differs in detail
- Google Sheets: No equivalent
- Returns: Number
Examples
=FORECAST.ETS.SEASONALITY(A1:A5, G1:G5) | A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | 10 | 1 | |||||
| 2 | 20 | 3 | |||||
| 3 | 30 | 5 | |||||
| 4 | 40 | 7 | |||||
| 5 | 50 | 9 |
Result 1
Syntax
FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])values- range required
timeline- range required
data_completion- number optional
aggregation- number optional
Errors
#VALUE!=FORECAST.ETS.SEASONALITY(A1:A3, 2)