BETA.DIST
Returns the beta cumulative distribution function.
StatisticalStatistics & Analysis
Compatibility / Legacy
Compatibility functions exist to keep older workbooks working across versions. They’re useful when maintaining legacy files—or when you need exact backward-compatible behavior.
This collection groups Excel functions that are commonly used for compatibility / legacy workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Tips
- Start with the most common functions in this collection and expand as your problems get more complex.
- Combine these functions with structured tables to keep formulas readable and resilient.
Excel functions in this collection (40)
BETAINV
Returns the inverse of the cumulative distribution function for a specified beta distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
BINOM.DIST
Returns the individual term binomial distribution probability.
StatisticalStatistics & Analysis
CEILING
Rounds a number to the nearest integer or to the nearest multiple of significance.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CHIDIST
Returns the one-tailed probability of the chi-squared distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CHIINV
Returns the inverse of the one-tailed probability of the chi-squared distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CHITEST
Returns the test for independence.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CONFIDENCE
Returns the confidence interval for a population mean.
CompatibilityCompatibility / LegacyLegacy / Older Versions
COVAR
Returns covariance, the average of the products of paired deviations.
CompatibilityCompatibility / LegacyLegacy / Older Versions
CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
CompatibilityCompatibility / LegacyLegacy / Older Versions
EXPON.DIST
Returns the exponential distribution.
StatisticalStatistics & Analysis
F.DIST
Returns the F probability distribution.
StatisticalStatistics & Analysis
F.INV
Returns the inverse of the F probability distribution.
StatisticalStatistics & Analysis
FLOOR
Rounds a number down, toward zero.
CompatibilityCompatibility / LegacyLegacy / Older Versions
F.TEST
Returns the result of an F-test.
StatisticalStatistics & Analysis
GAMMA.DIST
Returns the gamma distribution.
StatisticalStatistics & Analysis
GAMMA.INV
Returns the inverse of the gamma cumulative distribution.
StatisticalStatistics & Analysis
HYPGEOM.DIST
Returns the hypergeometric distribution.
StatisticalStatistics & Analysis
LOGINV
Returns the inverse of the lognormal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
LOGNORM.DIST
Returns the cumulative lognormal distribution.
StatisticalStatistics & Analysis
MODE
Returns the most common value in a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
NEGBINOM.DIST
Returns the negative binomial distribution.
StatisticalStatistics & Analysis
NORM.DIST
Returns the normal cumulative distribution.
StatisticalStatistics & Analysis
NORM.INV
Returns the inverse of the normal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
NORM.S.DIST
Returns the standard normal cumulative distribution.
StatisticalStatistics & Analysis
NORM.S.INV
Returns the inverse of the standard normal cumulative distribution.
StatisticalStatistics & Analysis
PERCENTILE
Returns the k-th percentile of values in a range.
CompatibilityCompatibility / LegacyLegacy / Older Versions
PERCENTRANK
Returns the percentage rank of a value in a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
POISSON
Returns the Poisson distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
QUARTILE
Returns the quartile of a data set.
CompatibilityCompatibility / LegacyLegacy / Older Versions
RANK
Returns the rank of a number in a list of numbers.
CompatibilityCompatibility / LegacyLegacy / Older Versions
STDEV
Estimates standard deviation based on a sample.
CompatibilityCompatibility / LegacyLegacy / Older Versions
STDEV.P
Calculates standard deviation based on the entire population.
StatisticalStatistics & Analysis
T.DIST
Returns the Percentage Points (probability) for the Student t-distribution.
StatisticalStatistics & Analysis
T.INV
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
StatisticalStatistics & Analysis
T.TEST
Returns the probability associated with a Student's t-test.
StatisticalStatistics & Analysis
VAR
Estimates variance based on a sample.
CompatibilityCompatibility / LegacyLegacy / Older Versions
VAR.P
Calculates variance based on the entire population.
StatisticalStatistics & Analysis
WEIBULL
Calculates variance based on the entire population, including numbers, text, and logical values.
CompatibilityCompatibility / LegacyLegacy / Older Versions
Z.TEST
Returns the one-tailed probability-value of a z-test.
StatisticalStatistics & Analysis