<?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">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">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>