Excel Function : FORECAST.ETS.STAT

Download now!

Excel Function : FORECAST.ETS.STAT




Returns a statistical value as a result of time series forecasting

Microsoft Excel Reference Page


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.