# Compatibility Functions

## Content

DsExcel.NET provides the following compatibility functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [BETADIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/betadist) | This function calculates the cumulative beta distribution function. |
| [BETAINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/betainv) | This function calculates the inverse of the cumulative beta distribution function. |
| [BINOMDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/binomdist) | This function calculates the individual term binomial distribution probability. |
| [CHIDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/chidist) | This function calculates the one-tailed probability of the chi-squared distribution. |
| [CHIINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/chiinv) | This function calculates the inverse of the one-tailed probability of the chi-squared distribution. |
| [CHITEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/chitest) | This function calculates the test for independence from the chi-squared distribution. |
| [CONFIDENCE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/confidence) | This function returns a confidence interval for a population mean. |
| [COVAR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/expondist) | This function returns the exponential distribution or the probability density. |
| [FDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/fdist) | This function calculates the F probability distribution, to see degrees of diversity between two sets of data. |
| [FINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/finv) | This function returns the inverse of the F probability distribution. |
| [FLOOR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/floor) | This function rounds a number down to the nearest multiple of a specified value. |
| [FTEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/gammadist) | This function returns the gamma distribution. |
| [GAMMAINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/gammainv) | This function returns the inverse of the gamma cumulative distribution. |
| [HYPGEOMDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/hypgeomdist) | This function returns the hypergeometric distribution. |
| [LOGINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/mode) | This function returns the most frequently occurring value in a set of data. |
| [NEGBINOMDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/negbinomdist) | This function returns the negative binomial distribution. |
| [NORM.INV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/norminv) | This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation. |
| [NORMDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/normdist) | This function returns the normal cumulative distribution for the specified mean and standard deviation. |
| [NORMSDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/normsdist) | This function returns the standard normal cumulative distribution function. |
| [NORMSINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/percentile) | This function returns the nth percentile of values in a range. |
| [PERCENTRANK](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/percentrank) | This function returns the rank of a value in a data set as a percentage of the data set. |
| [POISSON](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/poisson) | This function returns the Poisson distribution. |
| [QUARTILE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/quartile) | This function returns which quartile (which quarter or 25 percent) of a data set a value is. |
| [RANK](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/stdev) | This function returns the standard deviation for a set of numbers. |
| [STDEVP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/stdevp) | This function returns the standard deviation for an entire specified population (of numeric values). |
| [TDIST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/tdist) | This function returns the probability for the t-distribution. |
| [TINV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/ttest) | This function returns the probability associated with a t-test. |
| [VAR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/var) | This function returns the variance based on a sample of a population, which uses only numeric values. |
| [VARP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/varp) | This function returns variance based on the entire population, which uses only numeric values. |
| [WEIBULL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/compatibility-functions/weibull) | This function returns the two-parameter Weibull distribution, often used in reliability analysis. |
| [ZTEST](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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. |