FORECAST.ETS.SEASONALITY Function Explained
The FORECAST.ETS.SEASONALITY Function in Microsoft Excel is used to forecast a series of data based on a specified exponential smoothing (ETS) model. It takes three arguments: the known_y's (the historical data points), the known_x's (the corresponding x-values for the historical data points), and the new_x's (the x-values for which you want to forecast the corresponding y-values). It returns the forecasted y-values for the given x-values.
FORECAST.ETS.SEASONALITY Function Syntax
FORECAST.ETS.SEASONALITY(x, seasonality, [data_completion], [aggregation])
- x: The time-series data to be forecasted.
- seasonality: The number of data points in a seasonal cycle.
- data_completion: (Optional) The method used to complete missing data points in the time-series.
- aggregation: (Optional) The method used to aggregate the data points in the time-series.