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) .
To get detailed information about a function, click its name in the first column.
|
Function |
Description |
|---|---|
|
Returns the beta cumulative distribution function |
|
|
Returns the inverse of the cumulative distribution function for a specified beta distribution |
|
|
Returns the individual term binomial distribution probability |
|
|
Returns the one-tailed probability of the chi-squared distribution |
|
|
Returns the inverse of the one-tailed probability of the chi-squared distribution |
|
|
Returns the test for independence |
|
|
Joins two or more text strings into one string. |
|
|
Returns the confidence interval for a population mean |
|
|
Returns covariance, the average of the products of paired deviations |
|
|
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
|
|
Returns the exponential distribution |
|
|
Returns the F probability distribution |
|
|
Returns the inverse of the F probability distribution |
|
|
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. |
|
|
Rounds a number down, toward zero |
|
|
Returns the result of an F-test |
|
|
Returns the gamma distribution |
|
|
Returns the inverse of the gamma cumulative distribution |
|
|
Returns the hypergeometric distribution |
|
|
Returns the inverse of the lognormal cumulative distribution function |
|
|
Returns the cumulative lognormal distribution |
|
|
Returns the most common value in a data set |
|
|
Returns the negative binomial distribution |
|
|
Returns the normal cumulative distribution |
|
|
Returns the inverse of the normal cumulative distribution |
|
|
Returns the standard normal cumulative distribution |
|
|
Returns the inverse of the standard normal cumulative distribution |
|
|
Returns the k-th percentile of values in a range |
|
|
Returns the percentage rank of a value in a data set |
|
|
Returns the Poisson distribution |
|
|
Returns the quartile of a data set |
|
|
Returns the rank of a number in a list of numbers |
|
|
Estimates standard deviation based on a sample |
|
|
Calculates standard deviation based on the entire population |
|
|
Returns the Student's t-distribution |
|
|
Returns the inverse of the Student's t-distribution |
|
|
Returns the probability associated with a Student's t-test |
|
|
Estimates variance based on a sample |
|
|
Calculates variance based on the entire population |
|
|
Returns the Weibull distribution |
|
|
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.
