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