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]) |