The median is a commonly-used mathematical measurement. It’s simply the middle number in a given dataset. It’s easy to find using a spreadsheet. Let’s learn how to find the median in Microsoft Excel.
How to Find the Median in Excel
Luckily for you, Excel has a MEDIAN function built in. It helps you quickly find the median number in even the largest sets of data. Let’s look at two examples.
Look at a list of five numbers like this: 25, 50, 75, 100, and 125. Visually, you can probably identify the median as 75, since it’s the middle value in a list with 5 total values (an odd number). However, you can have Excel do the math for you with the MEDIAN function.
Click into any empty cell in your workbook. Type an = sign, which tells Excel that you’re beginning to type a formula. Then, type MEDIAN(. So far, your formula reads:
=MEDIAN(
Finally, click and drag to highlight the range of data. Here, that’s A1:E1. Then, type ). Your formula to find the median is:
=MEDIAN(A1:E1)
Hit Enter on your keyboard, and Excel returns the median value: 75.
Now, imagine that you have a dataset with an even-numbered total of values. For example, 1, 2, 3, and 4. There’s not an obvious median value there, right?
Using the same steps as before, build the median formula in an empty cell. In this case, it reads:
=MEDIAN(A3:D3)
Hit Enter, and Excel returns your solution: 2.5.
2.5 is found by Excel automatically computing the average of the two center (middle) values in your data set. Here, of course, that math is (2+3 / 2 = 2.5).
As you can see, it’s easy to find the median in Excel. This is a quick and easy way to gain insights into your data by exploring where the centering point lies.