FORECAST.ETS.STAT.ADD /text/scalc/01/func_forecastetsstatadd.xhp
FORECAST.ETS.STAT.ADD function

FORECAST.ETS.STAT.ADD Function

Returns statistical value(s) that are results of the ETS/EDS algorithms. FORECAST.ETS.STAT.ADD calculates with the model FORECAST.ETS.STAT.ADD (values, timeline, stat_type, [period_length], [data_completion], [aggregation]) =FORECAST.ETS.STAT.ADD(Values;Timeline;3;1;TRUE();1) Returns 0.9990234375, the additive statistics based on Values and Timeline named ranges above, with beta smoothing, one sample per period, no missing data, and AVERAGE as aggregation. =FORECAST.ETS.STAT.ADD(Values;Timeline;2;1;TRUE();7) Returns 0.0615234375, the additive statistics based on Values and Timeline named ranges above, with gamma smoothing, no missing data, and SUM as aggregation. COM.MICROSOFT.FORECAST.ETS.STAT
See also: FORECAST.ETS.ADD , FORECAST.ETS.MULT , FORECAST.ETS.STAT.MULT , FORECAST.ETS.PI.ADD , FORECAST.ETS.PI.MULT, FORECAST.ETS.SEASONALITY, FORECAST, FORECAST.LINEAR