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 Starter



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language