Statistical functions – Apple Numbers '08 User Manual
Page 202
202
Chapter 12
Dictionary of Functions
Statistical Functions
Statistical functions perform statistical calculations and require numeric expressions as
arguments. The numeric expression can be a number, cell reference, or range. Unless
otherwise stated, statistical functions result in a number.
Numbers provides these statistical functions.
Function
Description
AVEDEV (page 210)
Calculates the average difference (deviation) of data points from
their arithmetic mean (average).
AVERAGE (page 211)
Calculates the average (arithmetic mean) of a set of numbers.
AVERAGEA (page 211)
Calculates the average (arithmetic mean) of a set of values
including numbers, text, and Boolean values.
Returns a value for creating a statistical confidence interval for a
sample of a specified size from a population with a known
standard deviation; assumes values in sample are normally
distributed.
Calculates the correlation between two data sets based on linear
regression analysis.
Counts the number of arguments and referenced cells that contain
numbers, numeric expressions, or dates.
COUNTA (page 219)
Counts the number of arguments and referenced cells that are not
empty.
Counts the number of cells in a range that are empty.
Counts the number of cells in a range that satisfy a condition.
Calculates the covariance of two data sets.
Calculates the y (dependent) value that corresponds to a chosen x
(independent) value by using linear regression analysis of known
value pairs.
Calculates the y-intercept of the best-fit line for a data set using
linear regression analysis.
Retrieves the nth-largest value in a range.
Finds the largest number in a set.
Finds the largest value in a set that includes numbers, text, and
Boolean values.
Finds the median value in a set of numbers.
Finds the smallest number in a set.
Finds the smallest value in a set that includes numbers, text, and
Boolean values.
Finds the most frequently occurring value in a set of numbers.