PERCENTRANK.INC()
Syntax. PERCENTRANK.INC(array,x,significance)
Definition. This function returns the rank of a value (alpha) in a data set as a percentage (0 to 1 inclusive).
This function can be used to evaluate the relative position of a value within a data set. For example, you can use PERCENTRANK.INC() 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 (required). The value for which you want to know the rank.
significance (optional). A value that identifies the number of decimal places for the returned percentage value. If significance is not specified, PERCENTRANK.INC() uses three decimal ...
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.