# Compatibility Functions

## Content

Spread provides the following compatibility functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [BETADIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/BETADIST) | This function calculates the cumulative beta distribution function. |
| [BETAINV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/BETAINV) | This function calculates the inverse of the cumulative beta distribution function. |
| [BINOMDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/BINOMDIST) | This function calculates the individual term binomial distribution probability. |
| [CHIDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/CHIDIST) | This function calculates the one-tailed probability of the chi-squared distribution. |
| [CHIINV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/CHIINV) | This function calculates the inverse of the one-tailed probability of the chi-squared distribution. |
| [CHITEST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/CHITEST) | This function calculates the test for independence from the chi-squared distribution. |
| [CONFIDENCE](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/CONFIDENCE) | This function returns a confidence interval for a population mean. |
| [COVAR](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/COVAR) | This function returns the covariance, which is the average of the products of deviations for each data point pair in two sets of numbers. |
| [CRITBINOM](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/CRITBINOM) | This function returns the criterion binomial, the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
| [EXPONDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/EXPONDIST) | This function returns the exponential distribution or the probability density. |
| [FDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/FDIST) | This function calculates the F probability distribution, to see degrees of diversity between two sets of data. |
| [FLOOR](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/FLOOR) | This function rounds a number down to the nearest multiple of a specified value. |
| [FTEST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/FTEST) | This function returns the result of an F-test, which returns the one-tailed probability that the variances in two arrays are not significantly different. |
| [GAMMADIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/GAMMADIST) | This function returns the gamma distribution. |
| [GAMMAINV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/GAMMAINV) | This function returns the inverse of the gamma cumulative distribution. |
| [HYPGEOMDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/HYPGEOMDIST) | This function returns the hypergeometric distribution. |
| [LOGINV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/LOGINV) | This function returns the inverse of the lognormal cumulative distribution function of x, where LN(x) is normally distributed with the specified mean and standard deviation. |
| [LOGNORMDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/LOGNORMDIST) | This function returns the cumulative natural log-normal distribution of x, where LN(x) is normally distributed with the specified mean and standard deviation. Analyze data that has been logarithmically transformed with this function. |
| [MODE](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/MODE) | This function returns the most frequently occurring value in a set of data. |
| [NEGBINOMDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/NEGBINOMDIST) | This function returns the negative binomial distribution. |
| [NORM.INV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/NORM.INV) | This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation. |
| [NORMDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/NORMDIST) | This function returns the normal cumulative distribution for the specified mean and standard deviation. |
| [NORMSDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/NORMSDIST) | This function returns the standard normal cumulative distribution function. |
| [NORMSINV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/NORMSINV) | This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one. |
| [PERCENTILE](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/PERCENTILE) | This function returns the nth percentile of values in a range. |
| [PERCENTRANK](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/PERCENTRANK) | This function returns the rank of a value in a data set as a percentage of the data set. |
| [POISSON](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/POISSON) | This function returns the Poisson distribution. |
| [QUARTILE](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/QUARTILE) | This function returns which quartile (which quarter or 25 percent) of a data set a value is. |
| [RANK](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/RANK) | This function returns the rank of a number in a set of numbers. If you were to sort the set, the rank of the number would be its position in the list. |
| [STDEV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/STDEV) | This function returns the standard deviation for a set of numbers. |
| [STDEVP](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/STDEVP) | This function returns the standard deviation for an entire specified population (of numeric values). |
| [TDIST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/TDIST) | This function returns the probability for the t-distribution. |
| [TINV](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/TINV) | This function returns the t-value of the student's t-distribution as a function of the probability and the degrees of freedom. |
| [TTEST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/TTEST) | This function returns the probability associated with a t-test. |
| [VAR](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/VAR) | This function returns the variance based on a sample of a population, which uses only numeric values. |
| [VARP](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/VARP) | This function returns variance based on the entire population, which uses only numeric values. |
| [WEIBULL](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/WEIBULL) | This function returns the two-parameter Weibull distribution, often used in reliability analysis. |
| [ZTEST](/spreadjs/docs/v16/formulareference/FormulaFunctions/compatibility-functions/ZTEST) | This function returns the significance value of a z-test. The z-test generates a standard score for x with respect to the set of data and returns the two-tailed probability for the normal distribution. |