Compatibility Functions

BETADIST

This function calculates the cumulative beta distribution function.

BETAINV

This function calculates the inverse of the cumulative beta distribution function.

BINOMDIST

This function calculates the individual term binomial distribution probability.

CHIDIST

This function calculates the one-tailed probability of the chi-squared distribution.

CHIINV

This function calculates the inverse of the one-tailed probability of the chi-squared distribution.

CHITEST

This function calculates the test for independence from the chi-squared distribution.

CONFIDENCE

This function returns a confidence interval for a population mean.

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

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

This function returns the exponential distribution or the probability density.

FDIST

This function calculates the F probability distribution, to see degrees of diversity between two sets of data.

FLOOR

This function rounds a number down to the nearest multiple of a specified value.

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

This function returns the gamma distribution.

GAMMAINV

This function returns the inverse of the gamma cumulative distribution.

HYPGEOMDIST

This function returns the hypergeometric distribution.

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

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

This function returns the most frequently occurring value in a set of data.

NEGBINOMDIST

This function returns the negative binomial distribution.

NORM.INV

This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation.

NORMDIST

This function returns the normal cumulative distribution for the specified mean and standard deviation.

NORMSDIST

This function returns the standard normal cumulative distribution function.

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

This function returns the nth percentile of values in a range.

PERCENTRANK

This function returns the rank of a value in a data set as a percentage of the data set.

POISSON

This function returns the Poisson distribution.

QUARTILE

This function returns which quartile (which quarter or 25 percent) of a data set a value is.

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

This function returns the standard deviation for a set of numbers.

STDEVP

This function returns the standard deviation for an entire specified population (of numeric values).

TDIST

This function returns the probability for the t-distribution.

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

This function returns the probability associated with a t-test.

VAR

This function returns the variance based on a sample of a population, which uses only numeric values.

VARP

This function returns variance based on the entire population, which uses only numeric values.

WEIBULL

This function returns the two-parameter Weibull distribution, often used in reliability analysis.

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.