FORECAST.ETS.STAT Function Explained
The FORECAST.ETS.STAT Function in Microsoft Excel is used to calculate a future value based on existing values using the Exponential Triple Smoothing (ETS) algorithm. It takes three arguments: the existing values, the number of periods into the future to forecast, and the confidence interval. It returns the forecasted value and its upper and lower bounds.
FORECAST.ETS.STAT Function Syntax
FORECAST.ETS.STAT(known_y's, [known_x's], [new_x's], [stat_type], [seasonality], [aggregation])
- known_y’s: The range of cells that contain the data that is already known.
- known_x’s: (Optional) The range of cells that contain the independent values that are already known.
- new_x’s: (Optional) The range of cells that contain the independent values for which you want to predict the corresponding values.
- stat_type: (Optional) The type of forecasting method to use. The default is “M” for multiplicative.
- seasonality: (Optional) The type of seasonality to use. The default is “A” for additive.
- aggregation: (Optional) The type of aggregation to use. The default is “M” for median.