Excel Formulas

Showing page 15 of 21
STDEV
Statistical

Estimates standard deviation based on a sample

STDEVP
Statistical

Calculates standard deviation based on the entire population

VAR
Statistical

Estimates variance based on a sample

VARP
Statistical

Calculates variance based on the entire population

NORMDIST
Statistical

Returns the normal distribution for the specified mean and standard deviation

NORMINV
Statistical

Returns the inverse of the normal cumulative distribution

NORMSDIST
Statistical

Returns the standard normal cumulative distribution

NORMSINV
Statistical

Returns the inverse of the standard normal cumulative distribution

BETADIST
Statistical

Returns the beta cumulative distribution function

BETAINV
Statistical

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

BINOMDIST
Statistical

Returns the individual term binomial distribution probability

EXPONDIST
Statistical

Returns the exponential distribution

FDIST
Statistical

Returns the F probability distribution

FINV
Statistical

Returns the inverse of the F probability distribution

GAMMADIST
Statistical

Returns the gamma distribution

GAMMAINV
Statistical

Returns the inverse of the gamma cumulative distribution

LOGNORMDIST
Statistical

Returns the cumulative lognormal distribution

LOGINV
Statistical

Returns the inverse of the lognormal cumulative distribution

NEGBINOMDIST
Statistical

Returns the negative binomial distribution

POISSON
Statistical

Returns the Poisson distribution

Page 15 of 21