Home Â» How to Calculate Median Absolute Deviation in Excel

How to Calculate Median Absolute Deviation in Excel

The median absolute deviation is a way to measure the spread of values in a dataset.

The formula to calculate median absolute deviation, often abbreviated MAD, is as follows:

where:

• xi: The ith value in the dataset
• xm: The median value in the dataset

The following step-by-step example shows how to calculate the median absolute deviation of a given dataset in Excel.

Step 1: Enter the Data

First, weâ€™ll enter the values for a dataset:

Step 2: Calculate the Median

Next, weâ€™ll calculate the median of the dataset:

The median turns out to beÂ 16.

Step 3: Calculate the Absolute Difference Between Each Value & the Median

Next, weâ€™ll calculate the absolute difference between each value and the median:

Click on cell B2. Then hover over the bottom right corner of the cell until a little cross (+) appears.

Double click the cross to copy and paste this formula to all remaining cells in the column:

Step 4: Calculate the Median Absolute Deviation

Lastly, we will use the following formula to calculate the median absolute deviation of the dataset:

The median absolute deviation turns out to be 8.