Documentation/Calc Functions/QUARTILE.INC

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

QUARTILE.INC

Category:

Statistical Analysis

Summary:

Returns the quartile of a data set.

Syntax:

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

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.INC(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: