# Median

> The middle value once the numbers are in order. Half sit below and half above.

**Field:** General Knowledge  
**Category:** Math & Statistics  
**Also known as:** Middle Value

## Think of it like

It is like lining kids up by height. The kid in the very middle is the median.

## Definition

The median is the middle value once the numbers are put in order. Half the values are below it and half are above. For 3, 5 and 40, the median is 5. With an even count, it sits halfway between the two middle values. One huge value hardly moves it. That makes it a good average for pay and house prices.

## Example

Five people earn 30,000, 32,000, 35,000, 38,000 and 900,000 a year. The median is 35,000, which fits most of them. The mean is 207,000, which fits no one.

## Example code

```excel
=MEDIAN(3, 5, 40)
5
```

Typed into a spreadsheet cell, it shows 5. The huge 40 does not pull the middle up.

## Why it matters

Pay, rent and house prices are usually given as a median. It shows the typical case when a few values are extreme.

## Common mistake

Forgetting to sort the numbers first. The middle of a list that is out of order means nothing.

## Three principles

- **Sort first.** Put the values in order.
- **Take the middle.** Average the two middle ones if the count is even.
- **Shrugs off extremes.** One giant value barely moves it.

## Related terms

- [Mean (Average)](https://learn.benibix.com/term/general/mean)
- [Mode (Statistics)](https://learn.benibix.com/term/general/mode)
- [Percentile](https://learn.benibix.com/term/general/percentile)
- [Outlier](https://learn.benibix.com/term/general/outlier)
- [Normal Distribution](https://learn.benibix.com/term/general/normal-distribution)

## Told apart from

- [Mean vs Median](https://learn.benibix.com/compare/mean-vs-median): People use the mean and the median as if they were the same average, and they are not. The mean adds up every value and shares it out, so one huge value drags it up. The median is the middle value once they are sorted, and a huge value barely moves it. For pay and house prices, the median shows the typical case.

## Taught in

- [Mean, Median and Mode](https://learn.benibix.com/learn/general-math/mean-median-and-mode): Statistics, 4/10

![Five dots on a number line from 0 to 16, at 2, 2, 4, 6 and 16. The two dots at 2 are stacked and marked mode. The dot at 4 is marked median. A triangle under the line at 6 is marked mean. A dashed arrow runs from the far dot at 16 to the mean, marked the 16 pulls the mean up.](https://learn.benibix.com/diagrams/gen-averages.svg)

---

Source: https://learn.benibix.com/term/general/median
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
