The Statistical Functions

Excel provides several different functions that are used to perform statistical calculations. These functions are covered in the remaining portion of this chapter in alphabetical order, but they are categorized as follows:

Finding an average value:

AVEDEV (average of deviations between values)
AVERAGE (average of numeric values)
AVERAGEA (average of numeric, logical, and text values)

Working with distributions:

BETADIST (cumulative beta probability density function)
BETAINV (inverse of cumulative beta probability density function)
CHIDIST (chi-squared distribution)
CHIINV (inverse of chi-squared distribution)
CHITEST (compare expected range of values to actual range)
CRITBINOM (find the smallest value for the cumulative binomial distribution)
EXPONDIST (exponential distribution)
FDIST (F probability distribution)
FINV (inverse of F probability distribution)
GAMMADIST (gamma distribution)
GAMMAINV (inverse of gamma distribution)
GAMMALN (natural logarithm of a gamma function)
LOGINV (inverse of lognormal cumulative distribution)
LOGNORMDIST (lognormal cumulative distribution)
NORMDIST (cumulative normal distribution with specified mean and standard deviation)
NORMINV (inverse of cumulative normal distribution with specified mean and distribution)
NORMSDIST (cumulative standard distribution with mean of 0 and standard deviation of 1)
NORMSINV (inverse of cumulative standard distribution with mean of 0 and standard deviation of 1)
STANDARDIZE (Standardized value of an observation) ...

Get Excel 2000 in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.