Manuals/calci/PERCENTILE

PERCENTILE(ar,k)

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ar} is the array of data .
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 the 25th 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PERCENTILE(ar,k), ar } is the array of data that indicating relative standing and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 nonnumeric or k<0 or k>1.

7 2 9 PERCENTILE(C1:C4,0.4)=5.4

20 12 41 35 PERCENTILE(D1:D5,0.721)=33.26

3 4 PERCENTILE(A1:A3,1.1)=NAN