Thursday, April 8, 2021

Compatibility functions reference

In Excel 2010 or later, these functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage. You can still use them for compatibility with earlier versions of Excel, but if backward compatibility isn't required, you should start using the new functions instead. For more information about the new functions, see Statistical functions (reference) and Math and trigonometry functions (reference) .

If you're using Excel 2007, you'll find these functions in the Statistical or Math & Trig categories on the Formulas tab.

To get detailed information about a function, click its name in the first column.

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

CONCATENATE function

Joins two or more text strings into one string.

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

FORECAST function

Returns a value along a linear trend

Note: In Excel 2016, this function is replaced with the new Forecasting functions, but it's still available for compatibility with earlier versions.

FLOOR function

Rounds a number down, toward zero

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

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

See Also

Excel functions (by category)

Excel functions (alphabetical)

No comments:

Post a Comment