Excel Function : FORECAST.ETS

Download now!

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.