MEDIAN Function (Functions in Excel)

Value1	Value2	Value3	Value4	Value5	Median
20	50	10	30	40	30	=MEDIAN(C4:G4)
2000	1000	10	20	8000	1000	=MEDIAN(C6:G6)
10	20	40	40	40	40	=MEDIAN(C8:G8)
Value1	Value2	Value3	Value4		Median
20	40	30	10		25	=MEDIAN(C11:F11)
20	20	40	20		20	=MEDIAN(C13:F13)
What Does It Do ?
This function finds the median value of a group of values.
The median is not the average, it is the half way point where half the numbers in the group are
larger than it and half the numbers are less than it.
If there is no exact median number in the group, the two nearest the half way point are
added and their average is used as the median.
Syntax
=MEDIAN(Range1,Range2,Range3... through to Range30)
Formatting
No special formatting is needed.

Related Posts by Categories