Difference between revisions of "Manuals/calci/MEDIAN"

From ZCubes Wiki
Jump to navigation Jump to search
Line 50: Line 50:
 
|- class="even"
 
|- class="even"
 
| class="sshl_f" | 5
 
| class="sshl_f" | 5
| class="sshl_f" |
+
| class="sshl_f" | 0
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
|
 
|}
 
|}
  
  =MEDIAN(A1:A5)
+
  =MEDIAN(A1:A5) : Calculates the median value in the range A1 to A5. Displays ''4'' as a result.
  =MEDIAN(A1:A5)
+
=MEDIAN(A2,A3,10) : Calculates the median value -20,-30 and 10. Displays ''-20'' as a result.
  =MEDIAN(A1:A5)
+
  =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.

Revision as of 07:01, 7 December 2013

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 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.