Difference between revisions of "Manuals/calci/MEDIANIF"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "MEDIANIF")
 
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
 +
 
 +
==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 ]]

Revision as of 13:08, 26 April 2017

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

  1. MEDIANIF([12,87,13,10,9,13],">10") = 13
  2. MEDIANIF([12,87,13,10,9,13],"<10") = 9
  3. MEDIANIF([15,19,20,25,27,32],"<20") = 17
  4. MEDIANIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],">1.06") = 1.1

See Also

References