Manuals/calci/MEDIAN
Jump to navigation
Jump to search
MEDIAN(n1,n2,...) where n1,n2… are numbers.
It calculates the median of the given numbers.
· For even numbers in the set,MEDIAN calculates the average of the two numbers in the middle.
MEDIAN
Let’s see an example in (Column1 Row 1:Column1Row6)
MEDIAN (v1, v2,….)
i.e. =MEDIAN (C1R1:C1R6) is 35 (for even set)
=MEDIAN (C1R1:C1R5) is 30(for odd set)
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |||
Row1 | 10 | 35 | ||||
Row2 | 20 | 30 | ||||
Row3 | 30 | |||||
Row4 | 40 | |||||
Row5 | 50 | |||||
Row6 | 60 |