Manuals/calci/EXPONENTIALSMOOTHING
Jump to navigation
Jump to search
EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)
where,
Array - Input range should be one or more blocks.
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.
Exponential Smoothing schemes weight past observations using exponentially decreasing weights.
If DampingFactor < 0, EXPONENTIALSMOOTHING returns the #ERROR.
EXPONENTIAL SMOOTHING
Lets see an example in (Column3, Row3)
=EXPONENTIALSMOOTHING(R1C1:R6C2, 0.2, TRUE)
It returns the result in new sheet(5Sapce).
=EXPONENTIALSMOOTHING(R1C1:R3C2,-1, TRUE)
It returns the #ERROR(DampingFactor =-1).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 3 | 4 | 5 |
| Row2 | 7 | 8 | 9 | 128 |
| Row3 | 12 | 5 | 5Space | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 37 | 31 | #ERROR | 168 |
| Row6 | 6 | 8 | 1.619775 | 0.525322 |
| Input | Output |
|---|---|
| 1 | null |
| 7 | 1 |
| 12 | 5.800000000000001 |
| 17 | 10.760000000000001 |
| 37 | 15.752000000000002 |
| 6 | 32.7504 |
| 3 | 11.350080000000002 |
| 8 | 4.670016 |
| 5 | 7.334003200000001 |
| 18 | 5.466800640000001 |
| 31 | 15.493360128 |
| 8 | 27.8986720256 |