/text/scalc/01/func_forecastetsmult.xhp

FORECAST.ETS.MULT function FORECAST.ETS.MULT Function Calculates the multiplicative 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.MULT calculates with the model FORECAST.ETS.MULT(targets, values, timeline, [period_length], [data_completion], [aggregation]) =FORECAST.ETS.MULT(DATE(2014;1;1);Values;Timeline;1;TRUE();1) Returns 131.71437427439, the multiplicative 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.MULT(DATE(2014;1;1);Values;Timeline;4;TRUE();7) Returns 120.747806144882, the multiplicative 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.ADD, FORECAST.ETS.STAT.ADD, FORECAST.ETS.STAT.MULT, FORECAST.ETS.PI.ADD, FORECAST.ETS.PI.MULT, FORECAST.ETS.SEASONALITY, FORECAST, FORECAST.LINEAR