From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/scalc/01/func_forecastetsmult.xhp | 65 ++++++++++++++++++++++ 1 file changed, 65 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/func_forecastetsmult.xhp (limited to 'helpcontent2/source/text/scalc/01/func_forecastetsmult.xhp') diff --git a/helpcontent2/source/text/scalc/01/func_forecastetsmult.xhp b/helpcontent2/source/text/scalc/01/func_forecastetsmult.xhp new file mode 100644 index 000000000..49ea19fd5 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/func_forecastetsmult.xhp @@ -0,0 +1,65 @@ + + + + + + + FORECAST.ETS.MULT + /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. + + + + ORG.LIBREOFFICE.FORECAST.ETS.MULT +
+
+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 + +
+ + + -- cgit v1.2.3