Moving Average

Calculates the moving average of a time series

Selle käsu kasutamiseks...

Choose Data - Statistics - Moving Average


note

For more information on the moving average, refer to the corresponding Wikipedia article.


Andmed

Vahemik: ala, mis sisaldab andmeid, mida tuleb analĂĽĂĽsida.

Tulemused: viide lahtrivahemiku, kuhu tulemused väljastatakse, ülemisele vasakpoolsele lahtrile.

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.

RĂĽhmitamine

Vali, kas sisendandmed paiknevad veergudes või ridades.

Parameetrid

Interval: The number of samples used in the moving average calculation.

Näide

The following table has two time series, one representing an impulse function at time t=0 and the other an impulse function at time t=2.

A

B

1

1

0

2

0

0

3

0

1

4

0

0

5

0

0

6

0

0

7

0

0

8

0

0

9

0

0

10

0

0

11

0

0

12

0

0

13

0

0


Results of the moving average:

Column 1

Column 2

#N/A

#N/A

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/A

#N/A


Palun toeta meid!