Statistical functions

BETADIST

Returns the beta cumulative distribution function.

BETAINV

Returns the inverse of the cumulative distribution function for a specified beta distribution.

CHIDIST

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

CHIINV

Returns the inverse of the one-tailed probability of the chi-squared distribution.

CHITEST

Returns the test for independence.

COUNTBLANK

Counts the number of blank cells within a range.

COUNTIFS

Counts the number of non-blank cells across multiple ranges that meet the given criteria.

CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.

FDIST

Returns the F probability distribution.

FINV

Returns the inverse of the F probability distribution.

FREQUENCY

Returns a frequency distribution as a vertical array.

FTEST

Returns the result of an F-test.

GAMMADIST

Returns the gamma distribution.

GAMMAINV

Returns the inverse of the gamma cumulative distribution.

GAMMALN

Returns the natural logarithm of the gamma function, G(x).

HYPGEOMDIST

Returns the hyper geometric distribution.

LOGINV

Returns the inverse of the lognormal distribution.

LOGNORMDIST

Returns the cumulative lognormal distribution.

NEGBINOMDIST

Returns the negative binomial distribution.

PERCENTILE

Returns the k-th percentile of values in a range.

PERCENTRANK

Returns the percentage rank of a value in a data set.

POISSON

Returns the Poisson distribution.

PROB

Returns the probability that values in a range are between two limits.

QUARTILE

Returns the quartile of a data set.

RANK

Returns the rank of a number in a list of numbers.

TDIST

Returns the Student's t-distribution.

TINV

Returns the inverse of the Student's t-distribution.

TRIMMEAN

Returns the mean of the interior of a data set.

TTEST

Returns the probability associated with a Student's t-test.

ZTEST

Returns the one-tailed probability-value of a z-test.