Documentation/Calc Functions/PERCENTILE.INC

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

PERCENTILE.INC

Category:

Statistical Analysis

Summary:

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

Syntax:

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

The difference between PERCENTILE.INC and PERCENTILE.EXC is that, in the PERCENTILE.INC function the value of alpha is within the range 0 to 1 inclusive, and in the PERCENTILE.EXC function, the value of alpha is within the range 0 to 1 exclusive.

Examples:

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

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: