Formulas and Functions

225
The statistical functions help you manipulate and analyze
collections of data using a variety of measures and statistical
techniques.
Listing of Statistical Functions
iWork provides these statistical functions for use with tables.
Function Description
“AVEDEV” (page 230) The AVEDEV function returns the average of the
dierence of a collection of numbers from their
average (arithmetic mean).
“AVERAGE” (page 231 ) The AVERAGE function returns the average
(arithmetic mean) of a collection of numbers.
“AVERAGEA” (page 232) The AVERAGEA function returns the average
(arithmetic mean) of a collection of values,
including text and Boolean values.
“AVERAGEIF” (page 233) The AVERAGEIF function returns the average
(arithmetic mean) of the cells in a range that
meet a given condition.
“AVERAGEIFS” (page 234) The AVERAGEIFS function returns the average
(arithmetic mean) of the cells in a collection that
meet all the given conditions.
“BETADIST” (page 236) The BETADIST function returns the cumulative
beta distribution probability value.
10
Statistical Functions