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