# Moving Average

Calculates the moving average of a time series

αα α«ααααααα α¬αααααα‘ααααα‘...

Choose Data - Statistics - Moving Average

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

### αααααͺααααα

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.

## 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.

#### Grouped By

Select whether the input data has columns or rows layout.

## Parameters

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

#### Example

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 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

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