/text/scalc/01/func_forecastetsadd.xhp

FORECAST.ETS.ADD function FORECAST.ETS.ADD function Calculates the additive forecast(s) (future values) based on the historical data using ETS or EDS algorithms. EDS is used when argument period_length is 0, otherwise ETS is used. FORECAST.ETS.ADD calculates with the model FORECAST.ETS.ADD(targets, values, timeline, [period_length], [data_completion], [aggregation]) =FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;1;TRUE();1) Returns 157.166666666667, the additive forecast for January 2014 based on Values and Timeline named ranges above, with one sample per period, no missing data, and AVERAGE as aggregation. =FORECAST.ETS.ADD(DATE(2014;1;1);Values;Timeline;4;TRUE();7) Returns 113.251442038722, the additive forecast for January 2014 based on Values and Timeline named ranges above, with period length of 4, no missing data, and SUM as aggregation.

See also: FORECAST.ETS.MULT, FORECAST.ETS.STAT.ADD, FORECAST.ETS.STAT.MULT, FORECAST.ETS.PI.ADD, FORECAST.ETS.PI.MULT, FORECAST.ETS.SEASONALITY, FORECAST, FORECAST.LINEAR