# Documentation/Calc Functions/QUARTILE.EXC

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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.