PERCENTRANK()
Note
In Excel 2010, the PERCENTRANK() function was replaced with the PERCENTRANK.EXC() and PERCENTRANK.INC() functions to increase the accuracy of the results. To ensure the backward compatibility of PERCENTRANK.EXC() and PERCENTRANK.INC(), the PERCENTRANK() function is still available.
Syntax. PERCENTRANK(array,x,significance)
Definition. This function returns the rank of a value (alpha) as a percentage.
This function can be used to evaluate the relative position of a value within a data set. For example, you can use PERCENTRANK() to evaluate the position of an aptitude test score among all scores for the test.
Arguments
array (required). The array or range of data with numeric values that defines the relative position of the data.
x
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.
