Documentation/Calc Functions/QUARTILE.EXC

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

QUARTILE.EXC

Category:

Statistical Analysis

Summary:

Returns a requested quartile of a supplied range of values, based on a percentile range of 0 to 1 exclusive.

Syntax:

QUARTILE.EXC(Data; Type)

Returns:

Arguments:

Data represents the range of data values for which you want to calculate the specified quartile.

Type An integer between 1 and 3, representing the required quartile. (if type = 1 or 3, the supplied array must contain more than 2 values)

Additional details:

The difference between QUARTILE.INC and QUARTILE.EXC is that the QUARTILE.INC function bases its calculation on a percentile range of 0 to 1 inclusive, whereas the QUARTILE.EXC function bases its calculation on a percentile range of 0 to 1 exclusive.

Examples:

=QUARTILE.EXC(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: