Statistical - PERCENTILE.INC Function

Description

The PERCENTILE.INC function 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.

Syntax

PERCENTILE.INC (array,k)

Arguments

Argument	Description	Required/ Optional
Array	The array or range of data that defines relative standing.	Required
K	The percentile value in the range 0..1, inclusive.	Required

Notes

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

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm