Difference between revisions of "Manuals/calci/EXPONENTIALSMOOTHING"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''EXPONENTIALSMOOTHING'''(Array, DampingFactor, NewTableFlag) where, '''Array '''- Input range should be one...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)=
  
−
'''EXPONENTIALSMOOTHING'''(Array, DampingFactor, NewTableFlag)
+
*where, <math>Array</math> is the input array or reference to the cells containing array
 +
*<math>DampingFactor</math> is a corrective factor that minimizes the instability of data
 +
*<math>NewTableFlag</math> is a logical value that decides whether to display the output in the same worksheet or a new space cube.
  
−
where,
+
EXPONENTIALSMOOTHING() predicts a value based on the forecast for the earlier data points, by adjusting the instability in earlier data points.
  
−
'''Array '''- Input range should be one or more blocks.
+
== Description ==
  
−
'''DampingFactor''' - is a corrective factor that minimizes the instability of data. '''NewTableFlag''' - is the TRUE or FALSE.If set as TRUE,the result in new sheet.If NewTableFlag is omitted, it assumed to be FALSE.
+
EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)
  
−
</div>
+
*Exponential Smoothing is a technique that can be applied to a set of data, either to produce smoothed data for presentations, or to make forecasts.
−
----
+
*<math>Array</math> should be array of numbers.
−
<div id="1SpaceContent" class="zcontent" align="left">Exponential Smoothing schemes weight past observations using exponentially decreasing weights.</div>
+
*<math>DampingFactor</math> is the exponential smoothing constant referred as '''&alpha;'''. Value of '''&alpha;''' should be greater than '0'.
−
----
+
*If <math>DampingFactor</math> &lt; 0, Calci displays #NULL error message.
−
<div id="7SpaceContent" class="zcontent" align="left">
+
*Smaller the damping factor, more smoother are the projections.
 +
*If <math>DampingFactor</math> is omitted, Calci assumes it to be '0.3'.
 +
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
 +
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet.
 +
<font color="blue">Need to check the functionality of NewTableFlag after next release</font>
  
−
If DampingFactor &lt; 0, EXPONENTIALSMOOTHING returns the #ERROR.
+
== Examples ==
 +
Consider the following table with Columns A as data point and Column B as array input for MOVINGAVERAGE() function.
  
−
</div>
+
<div id="2SpaceContent" class="zcontent" align="left">
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
EXPONENTIAL SMOOTHING
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class="sshl_f" | '''Period'''
 +
| class=" " | '''Array Input'''
 +
| class=" " |
  
−
</div></div>
+
|- class="odd"
−
----
+
| class="sshl_f" |
−
<div id="8SpaceContent" class="zcontent" align="left">
+
| class=" " |
 +
| class=" " |
  
−
Lets see an example in (Column3, Row3)
+
|- class="even"
 +
| class="sshl_f" | 0
 +
| class=" " |0
 +
| class=" " |
  
−
<nowiki>=EXPONENTIALSMOOTHING(R1C1:R6C2, 0.2, TRUE)</nowiki>
+
|- class="odd"
 +
| class="sshl_f" | 1
 +
| class=" " |45.5
 +
| class=" " |
  
−
It returns the result in new sheet(5Sapce).
+
|- class="even"
 +
| class="sshl_f" | 2
 +
| class=" " |60
 +
| class=" " |
  
−
<nowiki>=EXPONENTIALSMOOTHING(R1C1:R3C2,-1, TRUE)</nowiki>
+
|- class="odd"
 +
| class="sshl_f" | 3
 +
| class=" " |200
 +
| class=" " |
  
−
It returns the #ERROR(DampingFactor =-1).
 
−
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
 
|- class="even"
 
|- class="even"
 +
| class="sshl_f" | 4
 +
| class=" " |160
 
| class=" " |
 
| class=" " |
−
| Column1
+
 
−
| Column2
 
−
| class="  " | Column3
 
−
| Column4
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
 
−
| class=" " | 1
 
−
| class=" " | 3
 
−
| class="  " | 4
 
 
| class="sshl_f" | 5
 
| class="sshl_f" | 5
 +
| class=" " |300
 +
| class=" " |
 +
 
|- class="even"
 
|- class="even"
−
| class=" " | Row2
+
| class="sshl_f" | 6
−
| class=" " | 7
+
| class=" " |340
−
| class=" " | 8
+
| class=" " |
−
| class=" " | 9
+
 
−
| class="sshl_f" | 128
 
 
|- class="odd"
 
|- class="odd"
−
| Row3
+
| class="sshl_f" | 7
−
| class=" " | 12
+
| class=" " |310
−
| class=" " | 5
+
| class=" " |
−
| class="sshl_f" | 5Space
+
 
−
| class="sshl_f    " | 15
 
 
|- class="even"
 
|- class="even"
−
| Row4
+
| class="sshl_f" | 8
−
| class=" " | 17
+
| class=" " |500
−
| class=" " | 18
+
| class=" " |
−
| class="sshl_f  " | 10000
+
 
−
| class="  " | 20
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row5
+
| class="sshl_f" | 9
−
| class=" " | 37
+
| class=" " |566
−
| class=" " | 31
+
| class=" " |
−
| class="sshl_f" | #ERROR
+
 
−
| 168
 
 
|- class="even"
 
|- class="even"
−
| Row6
+
| class="sshl_f" | 10
−
| class=" " | 6
+
| class=" " |610
−
| class=" " | 8
+
| class=" " |
−
| class=" SelectTD1 ChangeBGColor SelectTD1" |
+
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>1.619775
 
−
| 0.525322
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
=EXPONENTIALSMOOTHING(B1:B10,0.2,TRUE) returns the following table:
−
----
+
 
 
<div id="5SpaceContent" class="zcontent" align="left">
 
<div id="5SpaceContent" class="zcontent" align="left">
  
 
{| class="SpreadSheet blue"
 
{| class="SpreadSheet blue"
−
|+ <br />EXPONENTIAL SMOOTHING
+
|+ <br />EXPONENTIALSMOOTHING
 
|- class="even"
 
|- class="even"
 
! Input
 
! Input
 
! Output
 
! Output
 
|- class="odd"
 
|- class="odd"
−
| 1
+
| 0
 
| null
 
| null
 
|- class="even"
 
|- class="even"
−
| 7
+
| 45.5
−
| 1
+
| 0
 
|- class="odd"
 
|- class="odd"
−
| 12
+
| 60
−
| 5.800000000000001
+
| 36.4
 
|- class="even"
 
|- class="even"
−
| 17
+
| 200
−
| 10.760000000000001
+
| 55.28
 
|- class="odd"
 
|- class="odd"
−
| 37
+
| 160
−
| 15.752000000000002
+
| 171.056
−
|- class="even"
 
−
| 6
 
−
| 32.7504
 
 
|- class="odd"
 
|- class="odd"
−
| 3
+
| 300
−
| 11.350080000000002
+
| 162.21120000000002
 
|- class="even"
 
|- class="even"
−
| 8
+
| 340
−
| 4.670016
+
| 272.44224
 
|- class="odd"
 
|- class="odd"
−
| 5
+
| 310
−
| 7.334003200000001
+
| 326.488448
 
|- class="even"
 
|- class="even"
−
| 18
+
| 500
−
| 5.466800640000001
+
| 313.2976896
 
|- class="odd"
 
|- class="odd"
−
| 31
+
| 566
−
| 15.493360128
+
| 462.65953792
−
|- class="even"
+
| class="odd"
−
| 8
+
| 610
−
| 27.8986720256
+
| 545.331907584
 
|}
 
|}
  
−
</div>
+
== See Also ==
−
----
+
 
 +
*[[Manuals/calci/HISTOGRAM | HISTOGRAM]]
 +
*[[Manuals/calci/MOVINGAVERAGE | MOVINGAVERAGE]]
 +
 
 +
== References ==
 +
 
 +
*[http://en.wikipedia.org/wiki/Exponential_smoothing Exponential Smoothing]

Revision as of 17:07, 10 January 2014

EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)

  • where, is the input array or reference to the cells containing array
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DampingFactor} is a corrective factor that minimizes the instability of data
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} is a logical value that decides whether to display the output in the same worksheet or a new space cube.

EXPONENTIALSMOOTHING() predicts a value based on the forecast for the earlier data points, by adjusting the instability in earlier data points.

Description

EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)

  • Exponential Smoothing is a technique that can be applied to a set of data, either to produce smoothed data for presentations, or to make forecasts.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} should be array of numbers.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DampingFactor} is the exponential smoothing constant referred as α. Value of α should be greater than '0'.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DampingFactor} < 0, Calci displays #NULL error message.
  • Smaller the damping factor, more smoother are the projections.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DampingFactor} is omitted, Calci assumes it to be '0.3'.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} is TRUE, the result is displayed on new zspace sheet.

Need to check the functionality of NewTableFlag after next release

Examples

Consider the following table with Columns A as data point and Column B as array input for MOVINGAVERAGE() function.

Period Array Input
0 0
1 45.5
2 60
3 200
4 160
5 300
6 340
7 310
8 500
9 566
10 610 
=EXPONENTIALSMOOTHING(B1:B10,0.2,TRUE) returns the following table:

EXPONENTIALSMOOTHING
Input Output
0 null
45.5 0
60 36.4
200 55.28
160 171.056
300 162.21120000000002
340 272.44224
310 326.488448
500 313.2976896
566 462.65953792 class="odd" 610 545.331907584

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/EXPONENTIALSMOOTHING&oldid=197177"