PERCENTILE

PERCENTILE(array, k)

Returns the value from a data set that corresponds to a particular percentage (inclusive).

array	The array of values.
k	The percentage you are looking for between 0 and 1 (inclusive).

REMARKS

* PERCENTILE.INC was added in Excel 2010 to replace this function.
* For an illustrated example refer to the page under Advanced Functions
* If "array" contains more than 8,191 data points, then #NUM! is returned.
* If "array" is empty, then #NUM! is returned.
* If "k" < 0, then #NUM! is returned.
* If "k" > 1, then #NUM! is returned.
* If "k" is not numeric, then #VALUE! is returned.
* If "k" is not a multiple of 1/(n - 1), then this function interpolates to determine the value at the kth percentile.
* You can use the PERCENTILE.EXC function to return the number corresponding to a particular percentage from an array of numbers (exclusive).
* You can use the PERCENTRANK.INC function to return the rank of a value as a percentage (inclusive).
* You can use the QUARTILE.INC function to return the fixed percentiles of 0, 25, 50, 75 and 100 (inclusive).
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=PERCENTILE({1, 2, 3, 4}, 0.3) = 1.9
2	=PERCENTILE({1, 2, 3, 4}, 0.33) = 2.0
3	=PERCENTILE({1, 2, 3, 4}, 0.9) = 3.7
4	=PERCENTILE({1, 2, 3, 4}, 0) = 1
5	=PERCENTILE(, 0.3) = 0
6	=PERCENTILE({1, 2, 3, 4}, 2) = #NUM!
7	=PERCENTILE({1, 2, 3, 4}, "some text") = #VALUE!

1 - What value would represent the 30% percentile in the array of numbers {1,2,3,4}.
2 - What value would represent the 33% percentile in the array of numbers {1,2,3,4}.
3 - What value would represent the 90% percentile in the array of numbers {1,2,3,4}.
4 - What value would represent the 0% percentile in the array of numbers {1,2,3,4}.
5 - What value would represent the 100% percentile in the array of numbers {1,2,3,4}.