Excel Function : FORECAST.ETS

Download now!

Excel Function : FORECAST.ETS

Category

Statistical

Description

Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm

Microsoft Excel Reference Page

https://support.office.com/en-us/article/FORECASTETS-function-897a2fe9-6595-4680-a0b0-93e0308d5f6e#_forecast.ets

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.