Name |
Description |
Syntax |
| 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])
|