1 files changed, 159 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/statistics_movingavg.xhp b/helpcontent2/source/text/scalc/01/statistics_movingavg.xhp
new file mode 100644
index 0000000000..76f9ee6eef
--- /dev/null
+++ b/helpcontent2/source/text/scalc/01/statistics_movingavg.xhp
@@ -0,0 +1,159 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ -->
+
+<meta>
+<topic id="movingavgtopic" indexer="include" status="PUBLISH">
+<title id="tit">Moving Average in Calc</title>
+<filename>/text/scalc/01/statistics_movingavg.xhp</filename>
+</topic>
+</meta>
+<body>
+
+<bookmark branch="index" id="bm_id04001">
+<bookmark_value>Analysis toolpack;moving average</bookmark_value>
+<bookmark_value>moving average;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;moving average</bookmark_value>
+</bookmark>
+<bookmark branch="hid/modules/scalc/ui/movingaveragedialog/MovingAverageDialog" id="bm_id04002" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/movingaveragedialog/@@nowidget@@" id="bm_id04002" localize="false"/>
+<section id="movingaverage">
+<h1 id="hd_id1000130"><variable id="movingaverageh1"><link href="text/scalc/01/statistics_movingavg.xhp">Moving Average</link></variable></h1>
+<paragraph id="par_id1002500" role="paragraph"><ahelp hid="modules/scalc/ui/movingaveragedialog/MovingAverageDialog">Calculates the moving average of a time series</ahelp></paragraph>
+</section>
+<section id="howtoget">
+<paragraph id="par_id1002510" role="paragraph"><variable id="sam01">Choose <menuitem>Data - Statistics - Moving Average</menuitem></variable></paragraph>
+</section>
+<note id="par_id1002520">For more information on the moving average, refer to the <link href="https://en.wikipedia.org/wiki/Moving_average">corresponding Wikipedia article</link>.</note>
+<embed href="text/scalc/01/stat_data.xhp#data"/>
+<h2 id="hd_id251681484186482">Trim input range to actual data content</h2>
+<paragraph role="paragraph" id="par_id141681485134081">Check this box to allow trimming of the input range to the actual data content before computing moving-average. Trimming data ignores unused or empty cells after the last non-empty cell in the input range, thus reducing the computing load of the moving average to the actual data. This checkbox is enabled by default.</paragraph>
+<embed href="text/scalc/01/stat_data.xhp#grouped"/>
+<h2 id="hd_id1000140">Parameters</h2>
+<paragraph id="par_id1002530" role="paragraph"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
+<h2 id="hd_id1000171">Results of the moving average:</h2>
+<table id="Tabela10">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002540" role="tablehead">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002550" role="tablehead">Column 2</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002560" role="tablecontent">#N/A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002570" role="tablecontent">#N/A</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002580" role="tablecontent" localize="false">0.3333333333</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002590" role="tablecontent" localize="false">0.3333333333</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002600" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002610" role="tablecontent" localize="false">0.3333333333</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002620" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002630" role="tablecontent" localize="false">0.3333333333</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002640" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002650" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002660" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002670" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002680" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002690" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002700" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002710" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002720" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002730" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002740" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002750" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002760" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002770" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002780" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002790" role="tablecontent" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002800" role="tablecontent">#N/A</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002810" role="tablecontent">#N/A</paragraph>
+</tablecell>
+</tablerow>
+</table>
+<section id="relatedtopics">
+<embed href="text/scalc/01/stat_data.xhp#otherstat"/>
+</section>
+</body>
+</helpdocument>