MD - Mean Absolute Difference

Returns the mean absolute difference of the input data series.

Syntax

MD(X)
X
is the input data sample (one/two dimensional array of cells (e.g. rows or columns))

Remarks

1. The input time series data may include missing values (e.g. #N/A, #VALUE!, #NUM!, empty cell), but they will not be included in the calculations.
2. The sample mean difference (MD) is computed as follows:

$$\Delta = \mathrm{MD} = \frac{\sum_{i=1}^n \sum_{j=1}^n \| x_i - x_j \|}{n \times \left ( n-1 \right )}$$
Where:
• $x_i$ is the value of the i-th non-missing observation
• $n$ is the number of non-missing observations in the sample
3. The mean absolute difference is the product of the sample mean and the relative mean difference (RMD) and so can also be expressed in terms of the Gini coefficient :

$$\mathrm{MD}= 2 \times G \times \bar{x}$$

Where:
• $\bar{x}$ is the arithmetic sample mean
• $G$ is the Gini Coefficient
4. Because of its ties to the Gini coefficient, the mean difference is also called the "Gini mean difference." It is also known as the "Absolute mean difference."
5. The sample mean difference is not dependent on a specific measure of central tendency like the standard deviation.
6. The mean difference of a sample is an unbiased and consistent estimator of the population mean difference.

Examples

Example 1:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A B
Date Data
1/1/2008 #N/A
1/2/2008 -1.28
1/3/2008 0.24
1/4/2008 1.28
1/5/2008 1.20
1/6/2008 1.73
1/7/2008 -2.18
1/8/2008 -0.23
1/9/2008 1.10
1/10/2008 -1.09
1/11/2008 -0.69
1/12/2008 -1.69
1/13/2008 -1.85
1/14/2008 -0.98
1/15/2008 -0.77
1/16/2008 -0.30
1/17/2008 -1.28
1/18/2008 0.24
1/19/2008 1.28
1/20/2008 1.20
1/21/2008 1.73
1/22/2008 -2.18
1/23/2008 -0.23
1/24/2008 1.10
1/25/2008 -1.09
1/26/2008 -0.69
1/27/2008 -1.69
1/28/2008 -1.85
1/29/2008 -0.98

Formula Description (Result)
=MD($B$2:$B$30) Mean difference (1.452)