Manuals/calci/PERCENTILE

PERCENTILE(ar,k)

• $ar$ is the array of data .
• $k$ is the Percentile value.

Description

• This function gives the $k^{th}$ percentile value in a given range.
• Percentile means any of the 100 equal parts into which the range of the values of a set of data can be divided in order to show the distribution of those values.
• The percentile of a given value is determined by the percentage of the values that are smaller than that value.
• For example we can have the $25^{th}$ percentile is the value below which 25 percent of the observations may be found.
• The 25th percentile is called as the first quartile (Q1), the 50th percentile as the median quartile (Q2), and the 75th percentile as the third quartile (Q3).
• In general, percentiles and quartiles are specific types of quantiles.
• In $PERCENTILE(ar,k)$, $ar$ is the array of data that indicating relative standing and $k$ is the Percentile value in the range $0...1$(inclusive).
• This function will return the result as error when

1. The array value is empty.
2. $k$ is non-numeric or $k<0$ or $k>1$.

Examples

1.

Spreadsheet

	A	B	C	D
1	5	7	2	9

=PERCENTILE(A1:D1,0.4) = 5.4

2.

Spreadsheet

	A	B	C	D	E
1	15	20	12	41	35

=PERCENTILE(A1:E1,0.721) = 33.26

3.

Spreadsheet

	A	B	C
1	2	3	4

=PERCENTILE(A1:A3,1.1) = NAN

See Also

• MAX
• MIN
• MEDIAN
• QUARTILE

References

• Percentile