|
Returns the cumulative beta probability density function.
|
BETADIST(x,alpha,beta,[A],[B])
|
BETAINV
|
|
Returns the inverse of the cumulative beta probability density function for a specified beta distribution.
|
BETAINV(probability,alpha,beta,A,B)
|
BINOMDIST
|
|
Returns the individual term binomial distribution probability.
|
BINOMDIST(number_s,trials,probability_s,cumulative)
|
CHIDIST
|
|
Returns the one-tailed probability of the chi-squared distribution.
|
CHIDIST(x,degrees_freedom)
|
CHIINV
|
|
Returns the inverse of the right-tailed probability of the chi-squared distribution.
|
CHIINV(probability,degrees_freedom)
|
CHITEST
|
|
Returns the test for independence as the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.
|
CHITEST(actual_range,expected_range)
|
CONFIDENCE
|
|
Returns the confidence interval for a population mean using a normal distribution.
|
CONFIDENCE(alpha,standard_dev,size)
|
COVAR
|
|
Returns covariance, the average of the products of deviations for each data point pair in two data sets.
|
COVAR(array1,array2)
|
CRITBINOM
|
|
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
|
CRITBINOM(trials,probability_s,alpha)
|
EXPONDIST
|
|
Returns the exponential distribution.
|
EXPONDIST(x,lambda,cumulative)
|
FDIST
|
|
Returns the F probability distribution (degree of diversity) for two data sets.
|
FDIST(x,degrees_freedom1,degrees_freedom2)
|
FINV
|
|
Returns the inverse of the F probability distribution.
|
FINV(probability,degrees_freedom1,degrees_freedom2)
|
FTEST
|
|
Returns the two-tailed probability that the variances in array1 and array2 are not significantly different.
|
FTEST(array1,array2)
|
GAMMADIST
|
|
Returns the gamma distribution.
|
GAMMADIST(x,alpha,beta,cumulative)
|
GAMMAINV
|
|
Returns the inverse of the gamma cumulative distribution.
|
GAMMAINV(probability,alpha,beta)
|
HYPGEOMDIST
|
|
Returns the hypergeometric distribution.
|
HYPGEOMDIST(sample_s,number_sample,population_s,number_pop)
|
LOGINV
|
|
Returns the inverse of the lognormal cumulative distribution function.
|
LOGINV(probability,mean,standard_dev)
|
LOGNORMDIST
|
|
Returns the cumulative lognormal distribution.
|
LOGNORMDIST(x,mean,standard_dev)
|
MODE
|
|
Returns the most frequently occurring, or repetitive, value in an array or data range.
|
MODE(number1,[number2],…])
|
NEGBINOMDIST
|
|
Returns the negative binomial distribution.
|
NEGBINOMDIST(number_f,number_s,probability_s)
|
NORMDIST
|
|
Returns the normal distribution for the specified mean and standard deviation.
|
NORMDIST(x,mean,standard_dev,cumulative)
|
NORMINV
|
|
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
|
NORMINV(probability,mean,standard_dev)
|
NORMSDIST
|
|
Returns the standard normal cumulative distribution function.
|
NORMSDIST(z)
|
NORMSINV
|
|
Returns the inverse of the standard normal cumulative distribution.
|
NORMSINV(probability)
|
PERCENTILE
|
|
Returns the k-th percentile of values in a range.
|
PERCENTILE(array,k)
|
PERCENTRANK
|
|
Returns the rank of a value in a data set as a percentage of the data set.
|
PERCENTRANK(array,x,[significance])
|
POISSON
|
|
Returns the Poisson distribution.
|
POISSON(x,mean,cumulative)
|
QUARTILE
|
|
Returns the quartile of a data set.
|
QUARTILE(array,quart)
|
RANK
|
|
Returns the rank of a number in a list of numbers.
|
RANK(number,ref,[order])
|
STDEV
|
|
Calculates standard deviation based on a sample.
|
STDEV(number1,[number2],…])
|
STDEVP
|
|
Calculates standard deviation based on the entire population.
|
STDEVP(number1,[number2],…])
|
TINV
|
|
Returns the two-tailed inverse of the Student’s t-distribution.
|
TINV(probability,degrees_freedom)
|
TDIST
|
|
Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed.
|
TDIST(x,degrees_freedom,tails)
|
TTEST
|
|
Returns the probability associated with a Student’s t-Test.
|
TTEST(array1,array2,tails,type)
|
VAR
|
|
Calculates variance based on a sample.
|
VAR(number1,[number2],…])
|
VARP
|
|
Calculates variance based on the entire population.
|
VARP(number1,[number2],…])
|
WEIBULL
|
|
Returns the Weibull distribution.
|
WEIBULL(x,alpha,beta,cumulative)
|
ZTEST
|
|
Returns the one-tailed probability-value of a z-test.
|
ZTEST(array,x,[sigma])
|
|