Apple iWork '09 User Manual
Page 229
Chapter 10
Statistical Functions
229
Function
Description
The QUARTILE function returns the value for the
specified quartile of a given collection.
The RANK function returns the rank of a number
within a range of numbers.
The SLOPE function returns the slope of the best-
fit line for the collection using linear regression
analysis.
The SMALL function returns the n
th
-smallest
value within a range. The smallest value is ranked
number 1.
“STANDARDIZE” (page 289)
The STANDARDIZE function returns a normalized
value from a distribution characterized by a given
mean and standard deviation.
The STDEV function returns the standard
deviation, a measure of dispersion, of a collection
of values based on their sample (unbiased)
variance.
The STDEVA function returns the standard
deviation, a measure of dispersion, of a collection
of values that may include text and Boolean
values, based on the sample (unbiased) variance.
The STDEVP function returns the standard
deviation, a measure of dispersion, of a collection
of values based on their population (true)
variance.
The STDEVPA function returns the standard
deviation, a measure of dispersion, of a collection
of values that may include text and Boolean
values, based on the population (true) variance.
The TDIST function returns the probability from
the Student’s t-distribution.
The TINV functions returns the t value (a function
of the probability and degrees of freedom) from
the Student’s t-distribution.
The TTEST function returns the probability
associated with a Student’s t-test, based on the
t-distribution function.
The VAR function returns the sample (unbiased)
variance, a measure of dispersion, of a collection
of values.