1 files changed, 177 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/statistics_exposmooth.xhp b/helpcontent2/source/text/scalc/01/statistics_exposmooth.xhp
new file mode 100644
index 000000000..4ff6a3e1f
--- /dev/null
+++ b/helpcontent2/source/text/scalc/01/statistics_exposmooth.xhp
@@ -0,0 +1,177 @@
+<?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="exponentialsmooth" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Exponential Smoothing in Calc</title>
+<filename>/text/scalc/01/statistics_exposmooth.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id03001">
+<bookmark_value>Analysis toolpack;exponential smoothing</bookmark_value>
+<bookmark_value>exponential smoothing;Analysis toolpack</bookmark_value>
+<bookmark_value>Data statistics;exponential smoothing</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog" id="bm_id03002" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/exponentialsmoothingdialog/@@nowidget@@" id="bm_id03002" localize="false"/>
+<section id="exponentialsmoothing">
+    <h1 id="hd_id1000110"><variable id="exponentialsmoothingh1"><link href="text/scalc/01/statistics_exposmooth.xhp" name="Exponential Smoothing">Exponential Smoothing</link></variable></h1>
+<paragraph id="par_id1002120" role="paragraph" xml-lang="en-US"><ahelp hid="modules/scalc/ui/exponentialsmoothingdialog/ExponentialSmoothingDialog">Results in a smoothed data series</ahelp></paragraph>
+</section>
+<section id="howtoget">
+<paragraph id="par_id1002130" role="paragraph" xml-lang="en-US"><variable id="sam01">Choose <menuitem>Data - Statistics - Exponential Smoothing</menuitem></variable></paragraph>
+</section>
+<paragraph id="par_id1002140" role="paragraph" xml-lang="en-US">Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements.</paragraph>
+<note id="par_id1002150">For more information on exponential smoothing, refer to the <link href="https://en.wikipedia.org/wiki/Exponential_smoothing" name="English Wikipedia: Exponential smoothing">corresponding Wikipedia article</link>.</note><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/>
+<h2 id="hd_id1000120">Parameters</h2>
+<paragraph id="par_id1002160" role="paragraph" xml-lang="en-US"><emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/>
+<paragraph id="par_id1002170" role="paragraph" xml-lang="en-US">The resulting smoothing is below with smoothing factor as 0.5:</paragraph>
+<table id="Tabela9">
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002180" role="tablehead" xml-lang="en-US">Alpha</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002190" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
+</tablecell>
+<tablecell>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002200" role="tablehead" xml-lang="en-US">Column 1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002210" role="tablehead" xml-lang="en-US">Column 2</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002220" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002230" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002240" role="tablecontent" xml-lang="en-US" localize="false">1</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002250" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002260" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002270" role="tablecontent" xml-lang="en-US" localize="false">0</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002280" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002290" role="tablecontent" xml-lang="en-US" localize="false">0.5</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002300" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002310" role="tablecontent" xml-lang="en-US" localize="false">0.25</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002320" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002330" role="tablecontent" xml-lang="en-US" localize="false">0.125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002340" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002350" role="tablecontent" xml-lang="en-US" localize="false">0.0625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002360" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002370" role="tablecontent" xml-lang="en-US" localize="false">0.03125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002380" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002390" role="tablecontent" xml-lang="en-US" localize="false">0.015625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002400" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002410" role="tablecontent" xml-lang="en-US" localize="false">0.0078125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002420" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002430" role="tablecontent" xml-lang="en-US" localize="false">0.00390625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002440" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002450" role="tablecontent" xml-lang="en-US" localize="false">0.001953125</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002460" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002470" role="tablecontent" xml-lang="en-US" localize="false">0.0009765625</paragraph>
+</tablecell>
+</tablerow>
+<tablerow>
+<tablecell>
+<paragraph id="par_id1002480" role="tablecontent" xml-lang="en-US" localize="false">0.0002441406</paragraph>
+</tablecell>
+<tablecell>
+<paragraph id="par_id1002490" role="tablecontent" xml-lang="en-US" localize="false">0.0004882813</paragraph>
+</tablecell>
+</tablerow>
+</table>
+<section id="relatedtopics">
+<embed href="text/scalc/01/stat_data.xhp#otherstat"/>
+</section>
+</body>
+</helpdocument>