Have a Question?
Phone: +1 (888) 4279486
+1 (312) 2573777
Contact Us
MAD
Returns the sample median absolute deviation (MAD^{i}).
Syntax
MAD(X)
X
is the input data sample (a one dimensional array of cells (e.g. rows or columns)).
Remarks
 The input data series may include missing values (e.g. #N/A, #VALUE!, #NUM!, empty cell), but they will not be included in the calculations.

The median of absolute deviation (MAD) is defined as follows:
 In short, starting with the deviations from the data's median, the MAD is the median of their absolute values.
 The median absolute deviation (MAD) is a measure of statistical dispersion.
 Median absolute deviation (MAD) is a more robust estimator of scale than the sample variance or standard deviation.
 Median absolute deviation(MAD) is especially useful with distributions that have neither mean nor variance (e.g. the Cauchy distribution.)
 Median absolute deviation (MAD) is a robust statistic because it is less sensitive to outliers in a data series than standard deviation.
Examples
Example 1:
A  B  

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

=MAD($B$2:$B$30)  Median of absolute deviation (1) 
Files Examples
References
 Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0691042896
 Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0471690740