FORECAST.ETS.CONFINT Function Explained
The FORECAST.ETS.CONFINT Function in Microsoft Excel calculates a confidence interval for a forecast generated by the FORECAST.ETS function. It takes three arguments: the forecast, the confidence_level, and the seasonality. It returns an array of two values, the lower and upper bounds of the confidence interval.
FORECAST.ETS.CONFINT Function Syntax
FORECAST.ETS.CONFINT(known_y's, [known_x's], alpha, [new_x's], [statistic])
- known_y’s: An array or range of dependent values that are already known.
- known_x’s: An array or range of independent values that are already known. This argument is optional.
- alpha: The significance level used to calculate the confidence level. The confidence level equals 100*(1-alpha).
- new_x’s: An array or range of independent values that are to be forecasted. This argument is optional.
- statistic: A number specifying the type of confidence interval to be used. This argument is optional.