MEDIAN Function Dictionary

Function Dictionary Function Examples Function Categories

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.
=MEDIAN(Range1,Range2,Range3... through to Range30)
No special formatting is needed.


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download