Microsoft Office Tutorials and References
In Depth Information
Returns the average of the absolute deviations of data points from
Returns the average of its arguments.
Returns the average of its arguments and includes evaluation of
text and logical values.
Returns the average for the cells specified by a given criterion.
Returns the average for the cells specified by multiple criteria.
Returns the beta cumulative distribution function.
Returns the inverse of the cumulative distribution function for a
specified beta distribution.
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.
Returns the chi-squared distribution.
Returns the right-tailed probability of the chi-squared distribution.
Returns the inverse of the left-tailed probability of the chi-squared
Returns the inverse of the right-tailed probability of the chi-squared
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-
Returns the correlation coefficient between two data sets.
Counts how many numbers are in the list of arguments.
Counts how many values are in the list of arguments.