Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 547

BINOMDIST BINOMDIST(successes, trials, p, type) returns the
probability for the binomial distribution (type is
TRUE for cumulative distribution function, FALSE
for probability mass function).
CHIDIST CHIDIST(x, df) returns the probability for the
chi-square distribution.
CHIINV CHIINV(p, df) returns the inverse of the chi-square
distribution.
CRITBINOM CRITBINOM(trials, p, alpha) returns the smallest
value so that the cumulative binomial distribution
is greater than or equal to the criterion value, alpha.
EXPONDIST EXPONDIST(x, lambda, type) returns the probability
for the exponential distribution (type is true for
the cumulative distribution function, false for the
probability density function).
FDIST FDIST(x, df1, df2) returns the probability for the
F distribution.
FINV FINV(p, df1, df2) returns the inverse of the
F distribution.
GAMMADIST GAMMADIST(x, alpha, beta, type) returns the
probability for the gamma distribution with
parameters alpha and beta (type is true for the
cumulative distribution function, false for the
probability mass function).
GAMMAINV GAMMAINV(p, alpha, beta) returns the inverse of
the gamma distribution.
GAMMALN GAMMALN(x) returns the natural log of the gamma
function evaluated at x.
HYPGEOMDIST HYPGEOMDIST(sample-successes, sample-size,
population-successes, population-size) returns the
probability for the hypergeometric distribution.
LOGINV LOGINV(p, mean, sd) returns the inverse of the
lognormal distribution, where the natural logarithm
of the distribution is normally distributed with
mean mean and standard deviation sd.
LOGNORMDIST LOGNORMDIST(x, mean, sd) returns the
probability for the lognormal distribution,
where the natural logarithm of the distribution
is normally distributed with mean mean and
standard deviation sd.
NEGBINOMDIST NEGBINOMDIST(failures, threshold-successes,
probability) returns the probability for the negative
binomial distribution.
NORMDIST NORMDIST(x, mean, sd, type) returns the
probability for the normal distribution with mean
mean and standard deviation sd (type is true for
the cumulative distribution function, false for the
probability mass function).