O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required