Excel Function : FORECAST.ETS
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm
Microsoft Excel Reference Page
Syntax and Description of the FORECAST.ETS Excel Function
FORECAST.ETS function in Excel is used to return a future value based on historical data using an exponential smoothing (ETS) algorithm. The syntax of the FORECAST.ETS function is as follows: =FORECAST.ETS( known_y's, [known_x's], [new_x], [alpha], [beta], [gamma], [seasonality], [ trend], [damped] ) where: known_y's - The historical data (i.e. dependent variable). known_x's - The historical data (i.e. independent variable). new_x - The value for which we want to predict the dependent variable.
About FORECAST.ETS Excel Function
The FORECAST.ETS function forecasts future values using the exponential smoothing (ETS) algorithm.