**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 right-tailed probability of the chi-squared distribution *(Replaced by CHISQ.DIST.RT function in Excel 2010)* |

**CHISQ.DIST.RT** | Returns the right-tailed probability of the chi-squared distribution *(New in Excel 2010 - replaces CHIDIST function)* |

**CHISQ.DIST** | Returns the chi-squared distribution (probability density or cumulative distribution function) *(New in Excel 2010)* |

**CHIINV** | Returns the inverse of the right-tailed probability of the chi-squared distribution *(Replaced by CHISQ.INV.RT function in Excel 2010)* |

**CHISQ.INV.RT** | Returns the inverse of the right-tailed probability of the chi-squared distribution *(New in Excel 2010 - replaces CHIINV function)* |

**CHISQ.INV** | Returns the inverse of the left-tailed probability of the chi-squared distribution *(New in Excel 2010)* |

**CHITEST** | Returns the chi-squared statistical test for independence *(Replaced by CHISQ.TEST function in Excel 2010)* |

**CHISQ.TEST** | Returns the chi-squared 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 right-tailed F probability distribution for two data sets *(Replaced by F.DIST.RT function in Excel 2010)* |

**F.DIST.RT** | Returns the right-tailed 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 right-tailed F probability distribution for two data sets *(Replaced by F.INV.RT function in Excel 2010)* |

**F.INV.RT** | Returns the inverse of the right-tailed 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 F-Test for 2 supplied data sets *(Replaced by F.TEST function in Excel 2010)* |

**F.TEST** | Returns the result of an F-Test 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 log-normal distribution *(Replaced by LOGNORM.DIST function in Excel 2010)* |

**LOGNORM.DIST** | Returns the log-normal 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 T-distribution *(Replaced by T.DIST.2T & T.DIST.RT functions in Excel 2010)* |

**T.DIST.2T** | Returns the two-tailed Student's T-distribution *(New in Excel 2010 - replaces TDIST function)* |

**T.DIST.RT** | Returns the right-tailed Student's T-distribution *(New in Excel 2010 - replaces TDIST function)* |

**T.DIST** | Returns the Student's T-distribution (probability density or cumulative distribution function) *(New in Excel 2010)* |

**TINV** | Returns the two-tailed inverse of the Student's T-distribution *(Replaced by T.INV.2T function in Excel 2010)* |

**T.INV.2T** | Returns the two-tailed inverse of the Student's T-distribution *(New in Excel 2010 - replaces TINV function)* |

**T.INV** | Returns the left-tailed inverse of the Student's T-distribution *(New in Excel 2010)* |

**TTEST** | Returns the probability associated with a Student's T-Test *(Replaced by T.TEST function in Excel 2010)* |

**T.TEST** | Returns the probability associated with a Student's T-Test *(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 one-tailed probability value of a z-test *(Replaced by Z.TEST function in Excel 2010)* |

**Z.TEST** | Returns the one-tailed probability value of a z-test *(New in Excel 2010 - replaces ZTEST function)* |