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...") |
|||
| (12 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''MEDIAN ()'''</div><br/> |
| + | *Parameters are any set of numerical values. | ||
| + | **MEDIAN(), returns the median of the given numbers. | ||
| − | '''MEDIAN'''('' | + | == 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 <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 == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<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="sshl_f" | 5 |
| − | | class="sshl_f" | | + | | class="sshl_f" | 0 |
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| | | | ||
|} | |} | ||
| − | + | =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== | ||
| + | |||
| + | {{#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 14: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
See Also
References