# Documentation/Calc Functions/PERCENTILE

From The Document Foundation Wiki

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

## Function name:

PERCENTILE

## Category:

Statistical Analysis

## Summary:

Returns the alpha-percentile of data values in an array.

## Syntax:

PERCENTILE(**Data**; **Alpha**)

## Returns:

## Arguments:

**Data** represents the array of data.

**Alpha** represents the percentage of the scale between 0 and 1.

## Additional details:

A percentile returns the scale value for a data series which goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data series. For Alpha = 25%, the percentile means the first quartile; Alpha = 50% is the MEDIAN.

## Examples:

=PERCENTILE(A1:A50;0.1) represents the value in the data set, which equals 10% of the total data scale in A1:A50.