FORECAST.ETS.CONFINT
Confidence interval for an ETS forecast.
- Excel: Differs in detail
- Google Sheets: No equivalent
- Returns: Number
Examples
=FORECAST.ETS.CONFINT(6, A1:A5, G1:G5, 0.95, 1) | A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | 10 | 1 | |||||
| 2 | 20 | 3 | |||||
| 3 | 30 | 5 | |||||
| 4 | 40 | 7 | |||||
| 5 | 50 | 9 |
Result 9.801251507360325
Syntax
FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])target_date- number required
values- range required
timeline- range required
confidence_level- number optional defaults to
0.95 seasonality- number optional
data_completion- number optional
aggregation- number optional
Errors
#VALUE!=FORECAST.ETS.CONFINT(DATE(2026,1,15), A1:A3, 2)