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