The Excel compatibility functions are used to return the cumulative beta probability density, binominal distribution probability, right-tailed probability of the chi-squared distribution, confidence interval for a population mean and much more.
Complete List of Excel Compatibility Functions (A to Z)
All Excel compatibility functions are mentioned below in alphabetical order:
| Function | Description |
| BETADIST Function | Cumulative beta distribution formula. |
| BETAINV Function | Inverse of the cumulative beta distribution formula for a specified beta distribution. |
| BINOMDIST Function | Binomial distribution probability. |
| CEILING Function | Number that is rounded up, away from zero, and to the nearest multiple of a given number. |
| CHIDIST Function | Chi-squared distribution. |
| CHIINV Function | Inverse of the chi-squared distribution. |
| CHITEST Function | Chi-squared distribution and the appropriate degrees of freedom. |
| CONCATENATE Function | Combines the text from multiple cell ranges. |
| CONFIDENCE Function | Confidence interval for the mean of a population. |
| COVAR Function | Covariance, the average of the products of deviations for two data sets. |
| CRITBINOM Function | Smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |
| EXPONDIST Function | Exponential distribution. |
| FDIST Function | F probability distribution. |
| FINV Function | Inverse of the F probability distribution. |
| FLOOR Function | Round a number down, to the nearest multiple of a specified significance.. |
| FORECAST Function | Predict the future value by using the existing values. |
| FTEST Function | The result of an F-test for the two given arrays. |
| GAMMADIST Function | Gamma cumulative distribution. |
| GAMMAINV Function | Inverse of the gamma cumulative distribution. |
| HYPGEOMDIST Function | Hypergeometric distribution. |
| LOGINV Function | Inverse of the lognormal cumulative distribution. |
| LOGNORMDIST Function | Lognormal cumulative distribution. |
| MODE Function | Find the most seen value in a data set. |
| NEGBINOMDIST Function | Negative binomial distribution. |
| NORMDIST Function | Normal cumulative distribution. |
| NORMINV Function | Inverse of the normal cumulative distribution. |
| NORMSDIST Function | Standard normal cumulative distribution. |
| NORMSINV Function | Inverse of the standard normal cumulative distribution. |
| PERCENTILE Function | The k-th percentile of values in a range. |
| PERCENTRANK Function | The percentage rank of a value in a data set. |
| POISSON Function | Poisson distribution. |
| QUARTILE Function | The quartile of a data set. |
| RANK Function | The rank of a number in a list of numbers. |
| STDEV Function | The standard deviation based on a sample. |
| STDEVP Function | The standard deviation based on the entire population. |
| TDIST Function | Student’s t-distribution. |
| TINV Function | Inverse of the student’s t-distribution |
| TTEST Function | Probability associated with a student’s t-test. |
| VAR Function | The variance based on a sample. |
| VARP Function | The variance based on the entire population. |
| WEIBULL Function | Weibull distribution. |
| ZTEST Function | The probability value (P-value) of a Z-test. |