Moving Average

Calculates the moving average of a time series

To access this command...

Choose Data - Statistics - Moving Average

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

Data

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

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

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 | 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:

Related Topics

• Sampling
• Descriptive Statistics
• Analysis of Variance (ANOVA)
• Correlation
• Covariance
• Exponential Smoothing
• Moving Average
• Regression Analysis
• Paired t-test
• F-test
• Z-test
• Chi-square test
• Fourier Analysis