Difference between revisions of "Documentation/How Tos/Calc: MEDIAN function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{DISPLAYTITLE:MEDIAN function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_HARMEAN_function
 +
|NextPage=Documentation/How_Tos/Calc:_MODE_function
 +
}}__NOTOC__
  
 
== MEDIAN ==
 
== MEDIAN ==
Line 19: Line 24:
 
: returns <tt>'''7'''</tt>, which is the average of <tt>'''5'''</tt> and <tt>'''9'''</tt>, the two numbers in the middle.
 
: returns <tt>'''7'''</tt>, which is the average of <tt>'''5'''</tt> and <tt>'''9'''</tt>, the two numbers in the middle.
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
* [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]],
+
* [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]]
* [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]],
+
* [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]]
 
* [[Documentation/How_Tos/Calc: MODE function|MODE]]
 
* [[Documentation/How_Tos/Calc: MODE function|MODE]]
  
Line 28: Line 33:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Statistical functions]]

Latest revision as of 13:24, 2 February 2024



MEDIAN

Returns the median of a set of numbers.

Syntax:

MEDIAN(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.
MEDIAN returns the median (middle value) of the numbers. If the count of numbers is odd, this is the exact middle value. If the count of numbers is even, the average of the two middle values is returned.

Example:

MEDIAN(1; 5; 9; 20; 21)

returns 9, the number exactly in the middle.

MEDIAN(1; 5; 9; 20)

returns 7, which is the average of 5 and 9, the two numbers in the middle.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_MEDIAN_function&oldid=260018"
Views
Personal tools
Navigation
Tools