Difference between revisions of "Manuals/calci/MEDIANIF"
Jump to navigation
Jump to search
(Created page with "MEDIANIF") |
|||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
− | MEDIANIF | + | <div style="font-size:30px">'''MEDIANIF (Array,Condition,SumArray)'''</div><br/> |
+ | *<math>Array</math> is the set of values. | ||
+ | *<math>Condition</math> is the particular condition value. | ||
+ | |||
+ | ==Description== | ||
+ | *This function shows the median value of the given set which satisfies the given condition. | ||
+ | *The ""median"" is the ""middle"" value in the list of numbers. | ||
+ | *In <math>MEDIANIF (Array,Condition,SumArray)</math>,<math>Array</math> is the given set of values. | ||
+ | *<math>Condition</math> is the special condition which satisfies the median value. | ||
+ | *For a set of even numbers, MEDIAN calculates the average of the two numbers that are in the middle. | ||
+ | *If the array value contains numbers, they are arranged in ascending order and then median is calculated. | ||
+ | *If the array value 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. | ||
+ | |||
+ | ==Examples== | ||
+ | #MEDIANIF([12,87,13,10,9,13],">10") = 13 | ||
+ | #MEDIANIF([12,87,13,10,9,13],"<10") = 9 | ||
+ | #MEDIANIF([15,19,20,25,27,32],"<20") = 17 | ||
+ | #MEDIANIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],">1.06") = 1.1 | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|v=LZqQ4i-3WOk|280|center|Median If}} | ||
+ | |||
+ | ==See Also== | ||
+ | *[[Manuals/calci/MEDIAN| MEDIAN]] | ||
+ | *[[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 16:52, 29 November 2018
MEDIANIF (Array,Condition,SumArray)
- is the set of values.
- is the particular condition value.
Description
- This function shows the median value of the given set which satisfies the given condition.
- The ""median"" is the ""middle"" value in the list of numbers.
- In , is the given set of values.
- is the special condition which satisfies the median value.
- For a set of even numbers, MEDIAN calculates the average of the two numbers that are in the middle.
- If the array value contains numbers, they are arranged in ascending order and then median is calculated.
- If the array value 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.
Examples
- MEDIANIF([12,87,13,10,9,13],">10") = 13
- MEDIANIF([12,87,13,10,9,13],"<10") = 9
- MEDIANIF([15,19,20,25,27,32],"<20") = 17
- MEDIANIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],">1.06") = 1.1