Excel Function : FORECAST.ETS.STAT

Download now!

Excel Function : FORECAST.ETS.STAT

Category

Statistical

Description

Returns a statistical value as a result of time series forecasting

Microsoft Excel Reference Page

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

Syntax and Description of the FORECAST.ETS.STAT Excel Function

The syntax for the FORECAST.ETS.STAT function in Microsoft Excel is: FORECAST.ETS.STAT( known_y's, known_x's, new_x's, [stat], [seasonality], [data_completion], [aggregation] ) The FORECAST.ETS.STAT function returns a statistical forecast for a future value based on historical data. The function uses an exponential smoothing model to make predictions. Arguments known_y's - The historical data that you want to use to predict future values. This data can be in the form of a range of cells or an array. known_x's - The historical data that

About FORECAST.ETS.STAT Excel Function

The FORECAST.ETS.STAT function returns a forecast based on the exponential smoothing method with seasonal variations.