Statistical Functions
Function | Description |
|---|---|
AVEDEV | Returns the average absolute variance of data points |
AVERAGE | Returns the mean value of arguments |
AVERAGEA | Returns the mean value of arguments considering numbers, text, and logical values |
AVERAGEIF | Returns the mean value (mean average) of all cells in a range meeting a specified criterion |
AVERAGEIFS | Returns the mean value (mean average) of all cells meeting several criteria |
BETA.DIST (2010) | See BETADIST |
BETA.INV (2010) | See BETAINV |
BETADIST | Returns the values of the cumulative beta distribution function |
BETAINV | Returns the quantile of the given beta distribution |
BINOM.DIST (2010) | See BINOMDIST |
BINOM.INV (2010) | Returns the smallest value for which the cumulative probabilities of the binominal distribution ... |
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.
