Apple iWork '09 - Manual (Page 279)

Chapter 10 Statistical Functions 279
“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
PERCENTILE
The PERCENTILE function returns the value within a collection that corresponds to a
particular percentile.
PERCENTILE(num-date-dur-set, percentile-value)
 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.
 percentile-value: The percentile value you want to find, in the range 0 to 1.
percentile-value is a number value and is either entered as a decimal (for example,
0.25) or delimited with a percent sign (for example, 25%). It must be greater than or
equal to 0 and less than or equal to 1.
Usage Notes
Values included in the array of the same size are ranked together, but impact the Â
outcome.
Examples
Assume the following table contains the cumulative test scores for this semester for your 20 students.
(We have organized the data this way for the example; it would likely originally have been in 20
separate rows.)
=PERCENTILE(A1:E4, 0.90) returns 92, the minimum cumulative test score to be in the top 10% of the
class (90th percentile).
=PERCENTILE(A1:E4, 2/3) returns 85, the minimum cumulative test score to be in the top one-third of
the class (2/3 or approximately 67th percentile).
=PERCENTILE(A1:E4, 0.50) returns 83, the minimum cumulative test score to be in the top half of the
class (the 50th percentile).
Related Topics
For related functions and additional information, see:
“FREQUENCY” on page 257
“PERCENTRANK” on page 280