Manuals/calci/MEDIAN

MEDIAN(n1,n2,...)

• Where n1,n2… are numerical values.

MEDIAN() calculates the middle value in the set of given values.

Description

MEDIAN(n1,n2,...)

For Example,

MEDIAN(10,30,50,70,90) returns 50.

MEDIAN(2,4,6,8) returns 5.

MEDIAN("TEST","TEN","TAKE","TELL","TRAIN") returns TAKE.

• Arguments can be numbers or arrays, names or references that contain numbers.
• For a set of even numbers, MEDIAN calculates the average of the two numbers that are in the middle.
• If the logical values and text representations are entered as a part of argument, they are counted.
• If the logical values and text representations are entered as a part of an array or reference, they are not counted.
• The cells with zero value are counted.

Examples

45	2
-20	4
-30	TRUE
4	0.5
5

=MEDIAN(A1:A5)
=MEDIAN(A1:A5)
=MEDIAN(A1:A5)