Difference between revisions of "Manuals/calci/MEDIAN"

 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=MEDIAN(n1,n2,...)=
+
<div style="font-size:30px">'''MEDIAN ()'''</div><br/>
 
+
*Parameters are any set of numerical values.
*Where n1,n2… are numerical values.
+
**MEDIAN(), returns the median of the given numbers.
 
 
MEDIAN() calculates the middle value in the set of given values.
 
  
 
== Description ==
 
== Description ==
 
+
MEDIAN()
MEDIAN(n1,n2,...)
+
*For Example,MEDIAN(10,30,50,70,90) ''returns 50''.
 
+
*MEDIAN(2,4,6,8) ''returns 5''.
For Example,
+
*MEDIAN("TEST","TEN","TAKE","TELL","TRAIN") ''returns TAKE''.
 
+
*Arguments can be numbers, logical values or arrays, names or references that contain numbers.
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.
 
*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 argument contains numbers, they are arranged in ascending order and then median is calculated.
*If the logical values and text representations are entered as a part of an array or reference, they are not counted.
+
*If the argument contains text, each text takes its positional value and then median is calculated.
 +
*Logical value TRUE is evaluated as '1' and FALSE is evaluated as '0'.
 
*The cells with zero value are counted.
 
*The cells with zero value are counted.
 +
 +
==ZOS==
 +
*The syntax is to calculate the median value in ZOS is <math>MEDIAN()</math>.
 +
**Parameters are any set of numerical values.
 +
*For e.g.,MEDIAN(10.01,10.21,10.2,10.4,10.5,10.7)
  
 
== Examples ==
 
== Examples ==
Line 59: Line 56:
 
  =MEDIAN(B1:B4) : Calculates the median value in the range B1 to B4. Displays ''1.5'' as a result. Here TRUE is considered as 1.
 
  =MEDIAN(B1:B4) : Calculates the median value in the range B1 to B4. Displays ''1.5'' as a result. Here TRUE is considered as 1.
 
  =MEDIAN(B1:B5) : Calculates the median value in the range B1 to B5. Displays ''TRUE'' as a result.
 
  =MEDIAN(B1:B5) : Calculates the median value in the range B1 to B5. Displays ''TRUE'' as a result.
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|h8EYEJ32oQ8|280|center|MEDIAN}}
 +
 +
== See Also ==
 +
 +
*[[Manuals/calci/AVERAGE | AVERAGE]]
 +
*[[Manuals/calci/MODE | MODE ]]
 +
 +
== References ==
 +
 +
*[http://en.wikipedia.org/wiki/Median Median]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 15:24, 8 August 2018

MEDIAN ()


  • Parameters are any set of numerical values.
    • MEDIAN(), returns the median of the given numbers.

Description

MEDIAN()

  • 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, logical values 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 argument contains numbers, they are arranged in ascending order and then median is calculated.
  • If the argument contains text, each text takes its positional value and then median is calculated.
  • Logical value TRUE is evaluated as '1' and FALSE is evaluated as '0'.
  • The cells with zero value are counted.

ZOS

  • The syntax is to calculate the median value in ZOS is  .
    • Parameters are any set of numerical values.
  • For e.g.,MEDIAN(10.01,10.21,10.2,10.4,10.5,10.7)

Examples

45 2
-20 4
-30 TRUE
4 0.5
5 0
=MEDIAN(A1:A5) : Calculates the median value in the range A1 to A5. Displays 4 as a result.
=MEDIAN(A2,A3,10) : Calculates the median value -20,-30 and 10. Displays -20 as a result.
=MEDIAN(B1:B4) : Calculates the median value in the range B1 to B4. Displays 1.5 as a result. Here TRUE is considered as 1.
=MEDIAN(B1:B5) : Calculates the median value in the range B1 to B5. Displays TRUE as a result.

Related Videos

MEDIAN

See Also

References