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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
 
(7 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:QUARTILE function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_PERCENTRANK_function
 +
|NextPage=Documentation/How_Tos/Calc:_RANK_function
 +
}}__NOTOC__
  
 
== QUARTILE ==
 
== QUARTILE ==
Line 9: Line 14:
 
: <tt>'''QUARTILE'''</tt> returns the value below which <tt>'''q'''</tt> quarters of the numbers in <tt>'''numberlist'''</tt> lie. <tt>'''q'''</tt> may be 0 (to return the minimum value), 1 (to return the value below which a quarter of values lie), 2 (to return the median value), 3 (to return the value below which three quarters of values lie) or 4 (to return the maximum value). <tt>'''numberlist'''</tt> is a range or array of numbers, not necessarily in order.
 
: <tt>'''QUARTILE'''</tt> returns the value below which <tt>'''q'''</tt> quarters of the numbers in <tt>'''numberlist'''</tt> lie. <tt>'''q'''</tt> may be 0 (to return the minimum value), 1 (to return the value below which a quarter of values lie), 2 (to return the median value), 3 (to return the value below which three quarters of values lie) or 4 (to return the maximum value). <tt>'''numberlist'''</tt> is a range or array of numbers, not necessarily in order.
  
−
: <tt>'''QUARTILE'''</tt> calculates a return value in the same way as <tt>* [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]]</tt>
+
: <tt>'''QUARTILE'''</tt> calculates a return value in the same way as <tt>[[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]]</tt>
  
 
=== Example: ===
 
=== Example: ===
Line 23: Line 28:
 
: returns <tt>'''6'''</tt>. The calculation is the same as for <tt>'''PERCENTILE({9; 3; 7; 8}; 0.25)'''</tt>.
 
: returns <tt>'''6'''</tt>. The calculation is the same as for <tt>'''PERCENTILE({9; 3; 7; 8}; 0.25)'''</tt>.
  
−
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
−
* [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]],
+
* [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]]
−
* [[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]],
+
* [[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]]
−
* [[Documentation/How_Tos/Calc: RANK function|RANK]],
+
* [[Documentation/How_Tos/Calc: RANK function|RANK]]
−
* [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]],
+
* [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]]
−
* [[Documentation/How_Tos/Calc: MAX function|MAX]],
+
* [[Documentation/How_Tos/Calc: MAX function|MAX]]
 
* [[Documentation/How_Tos/Calc: MIN function|MIN]]
 
* [[Documentation/How_Tos/Calc: MIN function|MIN]]
−
 
 
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
 
* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
−
 
 
* [[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 14:54, 2 February 2024



QUARTILE

Returns a specified quartile in a list of numbers.

Syntax:

QUARTILE(numberlist; q)

QUARTILE returns the value below which q quarters of the numbers in numberlist lie. q may be 0 (to return the minimum value), 1 (to return the value below which a quarter of values lie), 2 (to return the median value), 3 (to return the value below which three quarters of values lie) or 4 (to return the maximum value). numberlist is a range or array of numbers, not necessarily in order.
QUARTILE calculates a return value in the same way as PERCENTILE

Example:

QUARTILE(A2:A99; 3)

where cells A2:A99 contain scores from a test, returns the score below which 75% of the scores lie.

The next two examples illustrate the calculation, but are not intended to show practical application:

QUARTILE({3; 4; 9; 11; 12}; 2)

returns 9, the median value of the list.

QUARTILE({9; 3; 7; 8}; 1)

returns 6. The calculation is the same as for PERCENTILE({9; 3; 7; 8}; 0.25).


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