MEDIAN

Posted on 24-01-2020 , by: admin , in , 0 Comments

median

Value1Value2Value3Value4Value5Median 
205010304030 =MEDIAN(C4:G4)
20001000102080001000 =MEDIAN(C6:G6)
102040404040 =MEDIAN(C8:G8)
Value2Value3Value4 Median 
403010 25 =MEDIAN(C11:F11)
20204020 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.

share:

Leave a comment