FORECAST.ETS.CONFINT
Returns a confidence interval for the forecast value at the specified target date
Syntax
FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])
Parameters
- target_date: Required. The data point for which you want to predict a confidence interval
- values: Required. The historical values
- timeline: Required. The independent array or range
- confidence_level: Optional. A numeric value between 0 and 1 (default 0.95)
- seasonality: Optional. The length of the seasonal pattern
- data_completion: Optional. How to handle missing points
- aggregation: Optional. The aggregation method
Example
=FORECAST.ETS.CONFINT(DATE(2025,1,1), B2:B14, A2:A14, 0.95)