/text/scalc/01/func_forecastetsstatmult.xhp

FORECAST.ETS.STAT.MULT function FORECAST.ETS.STAT.MULT Function Returns statistical value(s) that are results of the ETS/EDS algorithms. FORECAST.ETS.STAT.MULT calculates with the model FORECAST.ETS.STAT.MULT (values, timeline, stat_type, [period_length], [data_completion], [aggregation]) =FORECAST.ETS.STAT.MULT(Values;Timeline;5;1;TRUE();1) Returns 0.084073452803966, the multiplicative statistics based on Values and Timeline named ranges above, with symmetric mean absolute percentage error (SMAPE), one sample per period, no missing data, and AVERAGE as aggregation. =FORECAST.ETS.STAT.MULT(Values;Timeline;7;1;TRUE();7) Returns 15.8372533480997, the multiplicative statistics based on Values and Timeline named ranges above, with root mean squared error, no missing data, and SUM as aggregation.

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