Difference between revisions of "Manuals/calci/MEDIAN"
Jump to navigation
Jump to search
(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...") |
|||
| Line 1: | Line 1: | ||
| − | + | =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 | + | 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 == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"><div> | <div id="2SpaceContent" class="zcontent" align="left"><div> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class="ssh1_f" | 45 |
| − | + | | class="sshl_f" | 2 | |
| − | + | | class="sshl_f" | | |
| − | |||
| − | | class=" | ||
| − | | class=" | ||
| | | | ||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | -20 | |
| − | + | | class="sshl_f" | 4 | |
| − | |||
| − | | class="sshl_f" | | ||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| | | | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | -30 | |
| − | + | | class="sshl_f" | TRUE | |
| − | | class="sshl_f" | 30 | ||
| − | | class="sshl_f" | | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| | | | ||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | 4 | |
| − | | class="sshl_f" | | + | | class="sshl_f" | 0.5 |
| − | | class="sshl_f | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class="sshl_f" | 5 |
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
| | | | ||
|} | |} | ||
| − | + | =MEDIAN(A1:A5) | |
| − | + | =MEDIAN(A1:A5) | |
| + | =MEDIAN(A1:A5) | ||
Revision as of 06:48, 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 |
=MEDIAN(A1:A5) =MEDIAN(A1:A5) =MEDIAN(A1:A5)