目录

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

### 数据

「输入范围」: 要分析的数据范围的引用。

「结果输出到」: 显示结果的区域左上角的单元格的引用。

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

#### 分组条件

选择输入数据是否具有「列」或「行」布局。

## Parameters

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

#### 示例

下表有两个时间序列, 一个表示时间 t=0 的脉冲函数, 另一个表示时间 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

相关主题

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