BETADIST |
Returns the beta cumulative distribution 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 one-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 |
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 less 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. |
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. |
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 percentage rank of a value in a 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 t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. |
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]) |