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.

ORG.LIBREOFFICE.FORECAST.ETS.MULT