.

MEDIAN Function Dictionary

Function Dictionary Function Examples Function Categories

MEDIAN              
 
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.

.

Popular posts from this blog

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

TAMIL NADU Seventh MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD | TAMIL NADU 7TH MATHEMATICS, SCIENCE AND SOCIAL SCIENCE BOOK FREE DOWNLOAD