Apple iWork '09 User Manual
Page 258
Example
Assume the following table contains the test scores of 30 students who recently took an exam you
administered. Assume further that that the minimum passing grade is 65 and that the lowest score
for other grades are as given. In order to facilitate building the formulas, an “F” is represented by 1
and an “A” by 5.
=INDEX(FREQUENCY($A$1:$F$5, $B$8:$E$8), B9) returns 5, the number of students who received an
“F” (score of 65 or less). This formula can be entered in cell B10 and then extended across to cell F10.
The resulting values returned for grades of “D” to “A” are 3, 8, 8, and 6, respectively.
Related Topics
For related functions and additional information, see:
“PERCENTILE” on page 279
“PERCENTRANK” on 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
258
Chapter 10
Statistical Functions