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