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 
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 onetailed probability of the chisquared distribution 

Returns the inverse of the onetailed probability of the chisquared distribution 

Returns the test for independence 

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


Rounds a number down, toward zero 

Returns the result of an Ftest 

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 kth 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 tdistribution 

Returns the inverse of the Student's tdistribution 

Returns the probability associated with a Student's ttest 

Estimates variance based on a sample 

Calculates variance based on the entire population 

Returns the Weibull distribution 

Returns the onetailed probabilityvalue of a ztest 