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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
