Distribution & Tests of Probability

BETADIST

Returns the cumulative beta probability density function
(Replaced by BETA.DIST function in Excel 2010)

BETA.DIST

Returns the cumulative beta distribution function or the beta probability density function
(New in Excel 2010  replaces BETADIST function)

BETAINV

Returns the inverse of the cumulative beta probability density function
(Replaced by BETA.INV function in Excel 2010)

BETA.INV

Returns the inverse of the cumulative beta probability density function
(New in Excel 2010  replaces BETAINV function)

BINOMDIST

Returns the individual term binomial distribution probability
(Replaced by BINOM.DIST function in Excel 2010)

BINOM.DIST

Returns the individual term binomial distribution probability
(New in Excel 2010  replaces BINOMDIST function)

BINOM.DIST.RANGE

Returns the probability of a trial result using a binomial distribution (New in Excel 2013)

NEGBINOMDIST

Returns the negative binomial distribution
(Replaced by NEGBINOM.DIST function in Excel 2010)

NEGBINOM.DIST

Returns the negative binomial distribution
(New in Excel 2010  replaces NEGBINOMDIST function)

CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to
a criterion value
(Replaced by BINOM.INV function in Excel 2010)

BINOM.INV

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to
a criterion value
(New in Excel 2010  replaces CRITBINOM function)

CHIDIST

Returns the righttailed probability of the chisquared distribution
(Replaced by CHISQ.DIST.RT function in Excel 2010)

CHISQ.DIST.RT

Returns the righttailed probability of the chisquared distribution
(New in Excel 2010  replaces CHIDIST function)

CHISQ.DIST

Returns the chisquared distribution (probability density or cumulative distribution function)
(New in Excel 2010)

CHIINV

Returns the inverse of the righttailed probability of the chisquared distribution
(Replaced by CHISQ.INV.RT function in Excel 2010)

CHISQ.INV.RT

Returns the inverse of the righttailed probability of the chisquared distribution
(New in Excel 2010  replaces CHIINV function)

CHISQ.INV

Returns the inverse of the lefttailed probability of the chisquared distribution
(New in Excel 2010)

CHITEST

Returns the chisquared statistical test for independence
(Replaced by CHISQ.TEST function in Excel 2010)

CHISQ.TEST

Returns the chisquared statistical test for independence
(New in Excel 2010  replaces CHITEST function)

CORREL

Returns the correlation coefficient between two sets of values

EXPONDIST

Returns the exponential distribution
(Replaced by EXPON.DIST function in Excel 2010)

EXPON.DIST

Returns the exponential distribution
(New in Excel 2010  replaces EXPONDIST function)

FDIST

Returns the righttailed F probability distribution for two data sets
(Replaced by F.DIST.RT function in Excel 2010)

F.DIST.RT

Returns the righttailed F probability distribution for two data sets
(New in Excel 2010  replaces FDIST function)

F.DIST

Returns the F probability distribution (probability density or cumulative distribution function)
(New in Excel 2010)

FINV

Returns the inverse of the righttailed F probability distribution for two data sets
(Replaced by F.INV.RT function in Excel 2010)

F.INV.RT

Returns the inverse of the righttailed F probability distribution for two data sets
(New in Excel 2010  replaces FINV function)

F.INV

Returns the inverse of the Cumulative F distribution
(New in Excel 2010)

FISHER

Returns the Fisher transformation

FISHERINV

Returns the inverse of the Fisher transformation

FTEST

Returns the result of an FTest for 2 supplied data sets
(Replaced by F.TEST function in Excel 2010)

F.TEST

Returns the result of an FTest for 2 supplied data sets
(New in Excel 2010  replaces FTEST function)

GAMMADIST

Returns the gamma distribution
(Replaced by GAMMA.DIST function in Excel 2010)

GAMMA.DIST

Returns the gamma distribution
(New in Excel 2010  replaces GAMMADIST function)

GAMMAINV

Returns the inverse gamma cumulative distribution
(Replaced by GAMMA.INV function in Excel 2010)

GAMMA.INV

Returns the inverse gamma cumulative distribution
(New in Excel 2010  replaces GAMMAINV function)

GAMMALN

Calculates the natural logarithm of the gamma function for a supplied value

GAMMALN.PRECISE

Returns the natural logarithm of the gamma function for a supplied value
(New in Excel 2010)

GAMMA

Return the gamma function value for a supplied number (New in Excel 2013)

GAUSS

Calculates the probability that a member of a standard normal population will fall between the mean
and z standard deviations from the mean (New in Excel 2013)

HYPGEOMDIST

Returns the hypergeometric distribution
(Replaced by HYPGEOM.DIST function in Excel 2010)

HYPGEOM.DIST

Returns the hypergeometric distribution
(New in Excel 2010  replaces HYPGEOMDIST function)

LOGNORMDIST

Returns the cumulative lognormal distribution
(Replaced by LOGNORM.DIST function in Excel 2010)

LOGNORM.DIST

Returns the lognormal probability density function or the cumulative log normal distribution
(New in Excel 2010  replaces LOGNORMDIST function)

LOGINV

Returns the inverse of the lognormal distribution
(Replaced by LOGNORM.INV function in Excel 2010)

LOGNORM.INV

Returns the inverse of the lognormal distribution
(New in Excel 2010  replaces LOGINV function)

NORMDIST

Returns the normal cumulative distribution
(Replaced by NORM.DIST function in Excel 2010)

NORM.DIST

Returns the normal cumulative distribution
(New in Excel 2010  replaces NORMDIST function)

NORMINV

Returns the inverse of the normal cumulative distribution
(Replaced by NORM.INV function in Excel 2010)

NORM.INV

Returns the inverse of the normal cumulative distribution
(New in Excel 2010  replaces NORMINV function)

NORMSDIST

Returns the standard normal cumulative distribution
(Replaced by NORM.S.DIST function in Excel 2010)

NORM.S.DIST

Returns the standard normal cumulative distribution
(New in Excel 2010  replaces NORMSDIST function)

NORMSINV

Returns the inverse of the standard normal cumulative distribution
(Replaced by NORM.S.INV function in Excel 2010)

NORM.S.INV

Returns the inverse of the standard normal cumulative distribution
(New in Excel 2010  replaces NORMSINV function)

PEARSON

Returns the Pearson product moment correlation coefficient

RSQ

Returns the square of the Pearson product moment correlation coefficient

PHI

Returns the value of the density function for a standard normal distribution, for a supplied number
(New in Excel 2013)

POISSON

Returns the Poisson distribution
(Replaced by POISSON.DIST function in Excel 2010)

POISSON.DIST

Returns the Poisson distribution
(New in Excel 2010  replaces POISSON function)

PROB

Returns the probablity that values in a supplied range are within given limits

SKEW

Returns the skewness of a distribution

SKEW.P

Returns the skewness of a distribution based on a population (New in Excel 2013)

STANDARDIZE

Returns a normalized value

TDIST

Returns the Student's Tdistribution
(Replaced by T.DIST.2T & T.DIST.RT functions in Excel 2010)

T.DIST.2T

Returns the twotailed Student's Tdistribution
(New in Excel 2010  replaces TDIST function)

T.DIST.RT

Returns the righttailed Student's Tdistribution
(New in Excel 2010  replaces TDIST function)

T.DIST

Returns the Student's Tdistribution (probability density or cumulative distribution function)
(New in Excel 2010)

TINV

Returns the twotailed inverse of the Student's Tdistribution
(Replaced by T.INV.2T function in Excel 2010)

T.INV.2T

Returns the twotailed inverse of the Student's Tdistribution
(New in Excel 2010  replaces TINV function)

T.INV

Returns the lefttailed inverse of the Student's Tdistribution
(New in Excel 2010)

TTEST

Returns the probability associated with a Student's TTest
(Replaced by T.TEST function in Excel 2010)

T.TEST

Returns the probability associated with a Student's TTest
(New in Excel 2010  replaces TTEST function)

WEIBULL

Returns the Weibull distribution
(Replaced by WEIBULL.DIST function in Excel 2010)

WEIBULL.DIST

Returns the Weibull distribution
(New in Excel 2010  replaces WEIBULL function)

ZTEST

Returns the onetailed probability value of a ztest
(Replaced by Z.TEST function in Excel 2010)

Z.TEST

Returns the onetailed probability value of a ztest
(New in Excel 2010  replaces ZTEST function)
