PERCENTILE function
PERCENTILE(Array,
Percentile) PERCENTILE(Array;
Percentile)
Array
{ Number }
The unordered array of data.
Percentile
Number or { Number }
The percentile value, from 0 through 1.
Returns
Number or { Number }
A specified percentile in an array of numbers.
This function is a compatibility alias for PERCENTILE.INC. Use PERCENTILE.INC for new projects.