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.
Search JabSto ::




Custom Search