In This Topic

PERCENTILE.INC

In This Topic

This function returns the *k*th percentile of values in a range where k is between 0..1, inclusive.

PERCENTILE.INC(*array*,*k*)

This function has these arguments:

Argument | Description |
---|---|

array |
Array of values representing the data |

k |
Value representing the percentile value between 0 and 1 |

This function returns the #NUM! error value if the array is empty. If *k* is nonnumeric, #VALUE! is returned. If *k* < 0 or > 1, #NUM! is returned. The function interpolates to determine the value at the *k*th percentile if *k* is not a multiple of 1/(n-1).

Accepts numeric data for both arguments. Returns numeric data.

PERCENTILE.INC(A1:A12,0.95)

PERCENTILE.INC(R1C1:R1C45,0.866)

PERCENTILE.INC({5,15,25,50,65},0.45) gives the result 23

This function is available in Spread for Windows Forms 11.0 or later.

See Also