Apple iWork '09 - Manual (Page 280)

“QUARTILE” on page 284
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
PERCENTRANK
The PERCENTRANK function returns the rank of a value in a collection as a percentage
of the collection.
PERCENTRANK(num-date-dur-set, num-date-dur, significance)
 num-date-dur-set: A collection of values. num-date-dur-set is a collection
containing number, date, or duration values. All values must be of the same type.
 num-date-dur: A value. num-date-dur is a number value, a date/time value, or a
duration value.
 significance: An optional value specifying the number of digits to the right of the
decimal point. significance is a number value that must be greater than or equal to 1.
If omitted, a default value of 3 is used (x.xxx%).
Usage Notes
PERCENTRANK can be used to evaluate the relative standing of a value within Â
a collection. It is calculated by determining where in the collection a specified
number falls. For example, if in a given collection, there are ten values smaller than a
specified number and ten values that are larger, the PERCENTRANK of the specified
number is 50%.
Example
=PERCENTRANK({5, 6, 9, 3, 7, 11, 8, 2, 14}, 10) returns 0.813, as there are seven values smaller than 10
and only two that are larger.
Related Topics
For related functions and additional information, see:
“FREQUENCY” on page 257
“PERCENTILE” on page 279
“Listing of Statistical Functions” on page 225
280 Chapter 10 Statistical Functions