Documentation/Calc Functions/PERCENTILE.EXC

Function name:
PERCENTILE.EXC

Category:
Statistical Analysis

Summary:
Calculates the alpha-percentile of data values in an array of numbers. Percentiles can be used to understand the significance of particular values within a data set. The nth percentile of a data set is the value below which n% of the data set lies. This function uses an alpha argument lying in the range 0 to 1 (exclusive), which corresponds to a percentage in the range 0% to 100% (exclusive). For example, an alpha of 0.5 gives the 50th percentile, also known as the median.

Syntax:
PERCENTILE.EXC(Data; Alpha)

Returns:
Returns a real number which is the scale value for the specified data set and alpha.

Arguments:
Data is an array or a reference to the range of cells that represents the array of data.

Alpha is a real number or a reference to the cell containing that number which represents the percentage of the scale between 0 and 1. Values 0 and 1 are excluded.


 * If Alpha is greater than or equal to 1 or less than or equal to 0 then the function returns an error value.
 * If Alpha is not a multiple of 1/(n+1), (where n is the number of values in the supplied array), the function interpolates between the values in the supplied array, to calculate the percentile value. However, if Alpha is less than 1/(n+1) or Alpha is greater than n/(n+1), the function is unable to interpolate, and so returns an error.

Additional details:

 * Alpha = 0.25 gives the first quartile, Alpha = 0.5 gives the median, and Alpha = 0.75 gives the third quartile.
 * For more details on percentiles, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/PERCENTILE PERCENTILE]

[[Special:MyLanguage/Documentation/Calc_Functions/PERCENTILE.INC PERCENTILE.INC]

[[Special:MyLanguage/Documentation/Calc_Functions/PERCENTRANK PERCENTRANK]

[[Special:MyLanguage/Documentation/Calc_Functions/PERCENTRANK.EXC PERCENTRANK.EXC]

[[Special:MyLanguage/Documentation/Calc_Functions/PERCENTRANK.INC PERCENTRANK.INC]

[[Special:MyLanguage/Documentation/Calc_Functions/RANK RANK]

[[Special:MyLanguage/Documentation/Calc_Functions/QUARTILE QUARTILE]

[[Special:MyLanguage/Documentation/Calc_Functions/MAX MAX]

[[Special:MyLanguage/Documentation/Calc_Functions/MEDIAN MEDIAN]

ODF standard:
None

Equivalent Excel functions:
PERCENTILE.EXC