Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Spread Functions : Primitive Functions : MEDIAN
Q11555 - INFO: MEDIAN

MEDIAN (Primitive Spread Function) returns the number in the middle of the provided set of numbers; that is, half the numbers have values that are greater than the median, and half have values that are less than the median.

SYNTAX:

MEDIAN(value1,value2,...)

REMARKS:

Accepts up to 30 arguments. Each argument can be a cell or cell range, a float value, or an integer value. If there are an even number of arguments, the function calculates the average of the two numbers in the middle. 

EXAMPLES:

MEDIAN(A3,B5,C1,D4,E7)
MEDIAN(A1:A9)
MEDIAN(89,95,76,88,92)=89

Related Articles
Q11514 - INFO: AVERAGE
Q11562 - INFO: MODE
Q11581 - INFO: RANK

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 8/26/2008 5:21 PM.
Last Modified on 8/26/2008 10:00 PM.
Last Modified by No Author Name Available!.
Article has been viewed 3134 times.
Rated 3 out of 10 based on 2 votes.
Print Article
Email Article