Manuals/calci/MEDIAN

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

'

---