Compatibility functions (reference)

Click one of the links in the following list to see detailed help about the function.

Important    All of these functions have been replaced with new functions that may provide improved accuracy and whose names better reflect their usage. These functions are still available for compatibility with earlier versions of Excel. However, if backward compatibility is not required, you should consider using the new functions from now on, because they more accurately describe their functionality.

For more information about the new functions, see Statistical functions (reference).

Function Description
BETADIST function Returns the beta cumulative distribution function
BETAINV function Returns the inverse of the cumulative distribution function for a specified beta distribution
BINOMDIST function Returns the individual term binomial distribution probability
CHIDIST function Returns the one-tailed probability of the chi-squared distribution
CHIINV function Returns the inverse of the one-tailed probability of the chi-squared distribution
CHITEST function Returns the test for independence
CONFIDENCE function Returns the confidence interval for a population mean
COVAR function Returns covariance, the average of the products of paired deviations
CRITBINOM function Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
EXPONDIST function Returns the exponential distribution
FDIST function Returns the F probability distribution
FINV function Returns the inverse of the F probability distribution
FTEST function Returns the result of an F-test
GAMMADIST function Returns the gamma distribution
GAMMAINV function Returns the inverse of the gamma cumulative distribution
HYPGEOMDIST function Returns the hypergeometric distribution
LOGINV function Returns the inverse of the lognormal cumulative distribution function
LOGNORMDIST function Returns the cumulative lognormal distribution
MODE function Returns the most common value in a data set
NEGBINOMDIST function Returns the negative binomial distribution
NORMDIST function Returns the normal cumulative distribution
NORMINV function Returns the inverse of the normal cumulative distribution
NORMSDIST function Returns the standard normal cumulative distribution
NORMSINV function Returns the inverse of the standard normal cumulative distribution
PERCENTILE function Returns the k-th percentile of values in a range
PERCENTRANK function Returns the percentage rank of a value in a data set
POISSON function Returns the Poisson distribution
QUARTILE function Returns the quartile of a data set
RANK function Returns the rank of a number in a list of numbers
STDEV function Estimates standard deviation based on a sample
STDEVP function Calculates standard deviation based on the entire population
TDIST function Returns the Student's t-distribution
TINV function Returns the inverse of the Student's t-distribution
TTEST function Returns the probability associated with a Student's t-test
VAR function Estimates variance based on a sample
VARP function Calculates variance based on the entire population
WEIBULL function Returns the Weibull distribution
ZTEST function Returns the one-tailed probability-value of a z-test
 
 
Applies to:
Excel 2010, Excel Web App