Get confidence interval for forecast value at given date
=FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])| Parameter | Description |
|---|---|
target_date |
The time or period for the prediction (x value). |
values |
Existing or historical values (y values). |
timeline |
Numeric timeline values (x values). |
confidence_level |
[optional] A number between 0 and 1 (exclusive). Default = 0.95. |
seasonality |
[optional] Seasonality calculation (0 = no seasonality, 1 = automatic, n = season length in timeline units). |
data_completion |
[optional] Missing data treatment (0 = treat as zero, 1 = average). Default is 1. |
aggregation |
[optional] Aggregation behavior. Default is 1 (AVERAGE). See other options below. |
In the example shown above, the formula in cell E13 is:
=FORECAST.ETS.CONFINT(B13,sales,periods,confidence)The forecast value in cell D13 is calculated with the FORECAST.ETS function like this:
=FORECAST.ETS(B13,sales,periods,4)The upper and lower range formulas in F13 and G13 are:
=D13+E13 // upper
=D13-E13 // lower