Mean Absolute Deviation (MAD): How to Calculate It Step by Step

Mean Absolute Deviation: Step by step
Spread the love

The mean absolute deviation (MAD) tells you how far, on average, each value sits from the mean. It’s an intuitive measure of spread: a small MAD means the data is tightly clustered.

Quick answer

  1. Find the mean.
  2. Find each value’s distance from the mean (ignore minus signs).
  3. Average those distances.

Example: 2, 4, 6, 8 has mean 5; distances 3, 1, 1, 3; MAD = 8 ÷ 4 = 2.

Step-by-step example

Data: 3, 6, 6, 7, 8, 11, 15, 16.

Value Distance from mean (9)
3 6
6 3
6 3
7 2
8 1
11 2
15 6
16 7
  • First, the mean: 72 ÷ 8 = 9.
  • Next, add the distances: 30.
  • Finally, divide by the number of values: 30 ÷ 8 = 3.75.

So on average, each value is about 3.8 away from the mean.

Why absolute values?

Distances above and below the mean would cancel out if you kept the signs: they always add to zero. Taking the absolute value (see absolute value) keeps every distance positive.

MAD vs standard deviation

Mean absolute deviation Standard deviation
Method Averages the distances Averages squared distances, then square roots
Effect of outliers Moderate Larger, because squaring amplifies big gaps
Where used Intro statistics, forecasting error Most statistics and science

For this data set, the population standard deviation is 4.30, a little larger than the MAD of 3.75. See standard deviation.

In Excel or Google Sheets

=AVEDEV(A1:A8) returns the mean absolute deviation directly.

Median absolute deviation

Some fields use the median absolute deviation instead, which takes medians rather than means and resists outliers even more. Check which one your course or software means by “MAD”.

Frequently asked questions

What is mean absolute deviation?

The average distance of each value from the mean.

How do I calculate MAD?

Find the mean, take each value’s absolute distance from it, and average those distances.

What does a large MAD mean?

The values are spread far from the mean.

How do I calculate MAD in Excel?

Use =AVEDEV(range).

Related guides

Related guides

Leave a Reply

Your email address will not be published. Required fields are marked *