Documentation/Calc Functions/QUARTILE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

QUARTILE

Category:

Statistical Analysis

Summary:

Returns the quartile of a data set.

Syntax:

QUARTILE(Data; Type)

Returns:

Arguments:

Data represents the array of data in the sample.

Type represents the type of quartile. (0 = MIN, 1 = 25%, 2 = 50% (MEDIAN), 3 = 75% and 4 = MAX.)

Additional details:

Examples:

=QUARTILE(A1:A50;2) returns the value of which 50% of the scale corresponds to the lowest to highest values in the range A1:A50.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: