Excel Function : FORECAST.ETS.CONFINT
Category
Statistical
Description
Returns a confidence interval for the forecast value at the specified target date
Microsoft Excel Reference Page
Syntax and Description of the FORECAST.ETS.CONFINT Excel Function
The syntax for the FORECAST.ETS.CONFINT function in Microsoft Excel is: FORECAST.ETS.CONFINT( known_y's, known_x's, new_x's, [alpha], [seasonality], [trend], [damped]) Arguments known_y's - The known dependent y values. known_x's - The known independent x values. new_x's - The new x values for which we want to predict y. [alpha] - The significance level used to calculate the confidence level, a number between 0 and 1. The default value is 0.05, which corresponds to a 95% confidence
About FORECAST.ETS.CONFINT Excel Function
The FORECAST.ETS.CONFINT function returns the confidence interval for a forecast made with the FORECAST.ETS function.