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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
