Documentation/Calc Functions/QUARTILE

Function name:
QUARTILE

Category:
Statistical Analysis

Summary:
Calculates the quartile of a set of data points. Quartiles describe the division of a data set into four intervals based on the values of the data. The lowest 25% of the values are smaller than the first or lower quartile (equivalent to the 25th percentile). The lowest 50% of the values are smaller than the second quartile and this is also known as the median (equivalent to the 50th percentile). The lowest 75% of the values are smaller than the third or upper quartile (equivalent to the 75th percentile).

Syntax:
QUARTILE(Data; Type)

Returns:
Returns a real number which is the requested quartile of the specified data set.

Arguments:
Data is an array or a reference to a range of cells representing the array of data in the sample.

Type is an integer value from the range {0,1,2,3,4} or a reference to the cell containing that number which represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)


 * If Type is a non-integer real number then the function uses the floor value, i.e. it is truncated to an integer. However, if the Type is less than 0 or greater than or equal to 5 then the function returns an error value.

Additional details:

 * Calc functions MIN, MEDIAN, and MAX will return the same value as QUARTILE for the value of Type equal to 0, 2, and 4, respectively.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/QUARTILE.EXC QUARTILE.EXC]

[[Special:MyLanguage/Documentation/Calc_Functions/QUARTILE.INC QUARTILE.INC]

[[Special:MyLanguage/Documentation/Calc_Functions/MAX MAX]

[[Special:MyLanguage/Documentation/Calc_Functions/MIN MIN]

[[Special:MyLanguage/Documentation/Calc_Functions/MEDIAN MEDIAN]

[[Special:MyLanguage/Documentation/Calc_Functions/PERCENTILE PERCENTILE]

[[Special:MyLanguage/Documentation/Calc_Functions/PERCENTRANK PERCENTRANK]

[[Special:MyLanguage/Documentation/Calc_Functions/RANK RANK]

ODF standard:
Section 6.18.64, part 2

Equivalent Excel functions:
QUARTILE