🔢Median
Also known as Middle Value
The middle value once the numbers are in order. Half sit below and half above.
Think of it like
It is like lining kids up by height. The kid in the very middle is the median.
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.
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.
Definition
Example code
excel
=MEDIAN(3, 5, 40)
5Common mistake
Key takeaways
- 1Sort first. Put the values in order.
- 2Take the middle. Average the two middle ones if the count is even.
- 3Shrugs off extremes. One giant value barely moves it.