Moving Average

Calculates the moving average of a time series

Přistup k tutomu přikazej …

Z menijoweje lajsty:

Wubjerće Daty – Statistika – Wisaty přerězk…

Z powjercha z rajtarkami:

Wubjerće Daty – Statistika – Wisaty přerězk….

Wubjerće Statistika – Wisaty přerězk… w meniju Daty rajtarka Daty.


note

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


Daty

Input Range: The reference of the range of the data to analyze.

Results to: The reference of the top left cell of the range where the results will be displayed.

Zapodawanski wobłuk na aktualny datowy wobsah přitřihać

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.

Grouped By

Select whether the input data has columns or rows layout.

Dataju z přikładom wočinić:

Parametry

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

Přikład

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

#ND

#ND

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

#ND

#ND


Prošu podpěrajće nas!