Formulas and Functions

Table Of Contents

“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, signicance)

Â 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.

Â signicance:An optional value specifying the number of digits to the right of the

decimal point. signicance 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 specied

number falls. For example, if in a given collection, there are ten values smaller than a

specied number and ten values that are larger, the PERCENTRANK of the specied

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.