PERCENTILE.INC

Returns a percentile value from a data set.

Syntax:

PERCENTILE.INC(data:Array|Range, k:Number)

Returns the (100*k)th percentile from the values in the data array (or range of cells).

k must be a decimal fraction in the range [0.0,1.0] (i.e. inclusive).

Revisions:

This function was added in 2.00.