Level 16 Level 18
Level 17

Statistical functions


30 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
AVEDEV
Returns the average of the absolute deviations of data points from their mean
AVERAGEA
Returns the average of its arguments, including numbers, text, and logical values
AVERAGEIF
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS
Returns the average (arithmetic mean) of all cells that meet multiple criteria
BETA.DIST
Returns the beta cumulative distribution function
BETA.INV
Returns the inverse of the cumulative distribution function for a specified beta distribution
BINOM.DIST
Returns the individual term binomial distribution probability
BINOM.INV
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CHISQ.DIST
Returns the cumulative beta probability density function
CHISQ.DIST.RT
Returns the one-tailed probability of the chi-squared distribution
CHISQ.INV
Returns the cumulative beta probability density function
CHISQ.INV.RT
Returns the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.TEST
Returns the test for independence
CONFIDENCE.NORM
Returns the confidence interval for a population mean
CONFIDENCE.T
Returns the confidence interval for a population mean, using a Student's t distribution
CORREL
Returns the correlation coefficient between two data sets
COUNT
Counts how many numbers are in the list of arguments
COVARIANCE.P
Returns covariance, the average of the products of paired deviations
COVARIANCE.S
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
DEVSQ
Returns the sum of squares of deviations
EXPON.DIST
Returns the exponential distribution
F.DIST
Returns the F probability distribution
F.DIST.RT
Returns the F probability distribution
F.INV
Returns the inverse of the F probability distribution
F.INV.RT
Returns the inverse of the F probability distribution
F.TEST
Returns the result of an F-test
FISHER
Returns the Fisher transformation
FISHERINV
Returns the inverse of the Fisher transformation
FREQUENCY
Returns a frequency distribution as a vertical array
GAMMA.DIST
Returns the gamma distribution