Excel FunctionsLesson 95Free preview
MEDIAN
This lesson is part of Excel · All levels
Summary
MEDIAN is an Excel statistical function that returns the mean of a set of numbers after the data is sorted. If the data is even, the result is the average of the two middle values. The median is more resistant to extremes than the mean.
Key points
- MEDIAN takes the mean after the data is sorted
- The even-numbered data gives you an average of two middle values.
- Extreme values have not been very influential on the results of the MEDIAN
- Empty cells and text are ignored, not counted as zero
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.