PERCENTILE.INC()

Syntax. PERCENTILE.INC(array,k)

Definition. This function returns the k-quantile of the values in a range where k is between 0 and 1.

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.

Arguments

• array (required). The range of data that defines the relative standing of the data

• k (required). A value between 0 and 1 inclusive

Note

If array has no data points, the function returns the #NUM! error.

If k isn’t a numeric expression, the PERCENTILE.INC() function returns the #VALUE! error. If k is less than 0 or greater than 1, the PERCENTILE.INC() function returns the #NUM! error. If k isn’t a multiple of 1/(n – 1), PERCENTILE.INC() interpolates to determine the value at the k quantile.

Background. You will find more information about the use of this function in the description of PERCENTILE().

See Also

LARGE(), MAX(), MEDIAN(), MIN(), PERCENT.EXC(), PERCENTRANK(), SMALL()

Sample Files

Use the PERCENTILEINC worksheet in the Average.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.