The arguments for the PERCENTILE.INC function are:

Argument | Required? | Description |
---|---|---|

array | Required | The array or range of data that defines relative standing. |

k | Required | The percentile value in the range 0..1, inclusive. |

Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.

You can use this function to establish a threshold of acceptance. For example, you can decide to examine candidates who score above the 90th percentile.

The arguments for the PERCENTILE.INC function are:

Argument | Required? | Description |
---|---|---|

array | Required | The array or range of data that defines relative standing. |

k | Required | The percentile value in the range 0..1, inclusive. |