Exponential Smoothing
The Exponential Smoothing function is used to smooth out irregularities (peaks and valleys) to easily recognize trends.
The function uses the smoothing constant (α) which is associated with the Damping Factor (1- α). The larger the damping factor, the more the peaks and valleys are smoothed out. The smaller the damping factor, the closer the smoothed values are to the actual data points.
Settings | |
|---|---|
Damping Factor | The smoothing constant to apply. This can be a fixed number or a cell reference which contains the Damping Factor to apply. |
Standard Error | If set to Yes, a Standard Error column is added to the Placement. |
Place Formula | If set to Yes, the formulas for the smoothing as well as the Standard Error (if included) remain in the Placement. If set to No, only values appear in the Placement. |
Empty Cell Padding | If set to Yes, the values written to the Placement Cell start one row down or one column to the right (depending on Direction). Otherwise, values start at the Placement cell itself. |
Example
Smooth the trend of a temperature
 |
Base | |
|---|---|
Cell | $C$3 |
Direction | Down |
End | All cells are empty |
Placement | |
|---|---|
Cell | $D$3 |
Setting | Value |
|---|---|
Damping Factor | 0.3 |
Standard Error | No |
Place Formula | No |
Empty Cell Padding | Yes |