Manuals/calci/MEDIAN

From ZCubes Wiki
Revision as of 21:39, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MEDIAN'''('''n1''',n2,...) where n1,n2… are numbers. </div> ---- <div id="1SpaceContent" class="zcontent" a...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
'