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 are greater than ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

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