Microsoft Office Tutorials and References

In Depth Information

Returns the average of the absolute deviations of data points from

their mean.

AVEDEV

AVERAGE

Returns the average of its arguments.

Returns the average of its arguments and includes evaluation of

text and logical values.

AVERAGEA

AVERAGEIF*

Returns the average for the cells specified by a given criterion.

AVERAGEIFS*

Returns the average for the cells specified by multiple criteria.

BETA.DIST**

Returns the beta cumulative distribution function.

Returns the inverse of the cumulative distribution function for a

specified beta distribution.

BETA.INV**

BINOM.DIST**

Returns the individual term binomial distribution probability.

BINOM.DIST.RANGE*** Returns the probability of a trial result using a binomial distribution.

Returns the smallest value for which the cumulative binomial distri-

bution is less than or equal to a criterion value.

BINOM.INV**

CHISQ.DIST**

Returns the chi-squared distribution.

CHISQ.DIST.RT**

Returns the right-tailed probability of the chi-squared distribution.

Returns the inverse of the left-tailed probability of the chi-squared

distribution.

CHISQ.INV**

Returns the inverse of the right-tailed probability of the chi-squared

distribution.

CHISQ.INV.RT**

CHISQ.TEST**

Returns the test for independence.

CONFIDENCE.NORM** Returns the confidence interval for a population mean.

Returns the confidence interval for a population mean, using a stu-

dent's t-distribution.

CONFIDENCE.T**

CORREL

Returns the correlation coefficient between two data sets.

COUNT

Counts how many numbers are in the list of arguments.

COUNTA

Counts how many values are in the list of arguments.