Media móbil
Calcula a media móbil dunha serie temporal
For more information on the moving average, refer to the corresponding Wikipedia article.
Trim input range to actual data content
Check this box to allow trimming of the input range to the actual data content before computing moving-average. Trimming data ignores unused or empty cells after the last non-empty cell in the input range, thus reducing the computing load of the moving average to the actual data. This checkbox is enabled by default.
Parámetros
Intervalo: O número de mostras empregado no cálculo da media móbil.
Resultados da media móbil:
|
Columna 1 |
Columna 2 |
|---|---|
|
#N/D |
#N/D |
|
0.3333333333 |
0.3333333333 |
|
0 |
0.3333333333 |
|
0 |
0.3333333333 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
0 |
0 |
|
#N/D |
#N/D |