Practice free

FORECAST.ETS.CONFINT function

FORECAST.ETS.CONFINT returns the margin of the confidence interval around a FORECAST.ETS value, not the bounds. Add and subtract it from the forecast to draw a likely range.

Example

Practice this in the app

Syntax

FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])

Arguments in [square brackets] are optional.

target_date (required)
The date or number to forecast for.
values (required)
Historical values.
timeline (required)
Dates or numbers with a constant step.
confidence_level (optional)
Between 0 and 1; default 0.95.
seasonality (optional)
1 auto, 0 none, or season length.
data_completion (optional)
1 interpolate (default), 0 zeros.
aggregation (optional)
How to merge duplicate timestamps.

Returns: The half-width of the confidence interval around a FORECAST.ETS value.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=FORECAST.ETS.CONFINT(DATE(2025,1,1),Data!AF1:AF24,Data!AE1:AE24,0.95) 0 Working example
=FORECAST.ETS.CONFINT(DATE(2025,1,1),Data!AF1:AF24,Data!AE1:AE24) 0 Default confidence
=FORECAST.ETS.CONFINT(DATE(2025,1,1),Data!AF1:AF24,Data!AE1:AE24,0) 0 Confidence 0
=FORECAST.ETS.CONFINT(DATE(2025,1,1),Data!AF1:AF24,Data!AE1:AE24,0.5,0) 8.66938122 Confidence 0.5 no season
=FORECAST.ETS.CONFINT(8,Data!AH1:AH6,Data!AG1:AG6) 5.421558377 Duplicate timeline
=FORECAST.ETS.CONFINT(DATE(2025,1,1),Data!AF1:AF24,Data!AE1:AE24,1) #NUM! Confidence 1
=FORECAST.ETS.CONFINT(DATE(2025,1,1),Data!AF1:AF23,Data!AE1:AE24) #N/A Different sizes

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • It is the margin only, not the bounds.
  • Same timeline rules as FORECAST.ETS.

Where it works

Excel
FORECAST.ETS.CONFINT arrived in Excel 2016. Older versions do not have it. Same Mac availability caveat as FORECAST.ETS.
Google Sheets
No direct equivalent. No Sheets counterpart.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .