| Function |
Description |
| AVEDEV |
Computes the average deviation of a list of numbers. |
| AVERAGE |
Returns the average of the supplied numbers. The result of AVERAGE is also known as the arithmetic mean. |
| AVERAGEA |
Computes the average of a list of numbers, considering textual values. |
| BETADIST |
Computes the cumulative beta distribution. |
| BETAINV |
Computes the inverse of the BETADIST function. |
| BINOMDIST |
Computes the binomial distribution, which is used to determine probabilities on repeated tests where each test is independent of every other test. |
| CHIDIST |
Computes the "complementary" version of the chi-square distribution. |
| CHIINV |
Computes the inverse of the "complementary" chi-square distribution. |
| CHITEST |
Computes the probability of the distribution against expected values. |
| CONFIDENCE |
Computes the confidence interval, assuming a normal distribution. |
| CORREL |
Computes the correlation coefficient for two sets of numbers, paired up one-to-one. |
| COUNT |
Returns the number of values in the supplied list. |
| COUNTA |
Returns the number of nonblank values in the supplied list. |
| COVAR |
Computes the covariance for pairwise numbers in two arrays |
| CRITBINOM |
Computes the smallest number of successes that will result in the BINOMDISTCUM function giving an answer larger than a specified criteria value. |
| DEVSQ |
Computes the square of the deviation of the numbers. |
| EXPONDIST |
Computes the exponential distribution. |
| FDIST |
Computes the F-distribution, which is used to compare data from two different populations. |
| FINV |
Computes the inverse of the complementary F-distribution (that is, the inverse of the FDIST function). |
| FISHER |
Computes Fisher's z-transformation. |
| FISHERINV |
Computes the inverse of Fisher's z-transformation. |
| FORECAST |
Constructs the least squares regression line through the data given, then computes the predicted y value for the requested x. |
| FREQUENCY |
Distributes the specified array of numbers, sorted in ascending order, into specified bins. |
| FTEST |
Computes an F-test probability for two specified distributions. |
| GAMMADIST |
Computes the gamma distribution for a given value. |
| GAMMAINV |
Computes the inverse of the cumulative gamma distribution. |
| GAMMALN |
Computes the logarithm of the gamma function. |
| GEOMEAN |
Computes the geometric mean of a list of positive numbers. |
| GROWTH |
Computes result values from the fitted curve of a multiple exponential regression for a group of specified observations relative to a group of specified independent variables. |
| HARMEAN |
Computes the harmonic mean of a list of positive numbers. |
| HYPGEOMDIST |
Computes the hypergeometric distribution. |
| INTERCEPT |
Computes the y-intercept of the least squares linear regression line through the given data. |
| KURT |
Computes the kurtosis or of a list of numbers. |
| LARGE |
Computes the Xth largest value in a list. |
| LINEST |
Computes multiple linear regression for a group of observations relative to a number of independent variables. |
| LOGEST |
Computes multiple exponential regression for a group of observations relative to a number of independent variables. |
| LOGINV |
Computes the inverse of the cumulative lognormal distribution of x, where the logarithm of x is normally distributed. |
| LOGNORMDIST |
Computes the cumulative lognormal distribution for x, where the logarithm of x is normally distributed. |
| MAX |
Returns the largest value in the specified list of numbers. |
| MAXA |
Returns the largest value in the specified list of numbers, considering textual values. |
| MEDIAN |
Computes the median or middle value of a list of numbers arranged in ascending order. |
| MIN |
Returns the smallest value in the specified list of numbers. |
| MINA |
Returns the smallest value in the specified list of numbers, considering textual values. |
| MODE |
Computes the most frequent value in a list of numbers (the number that appears most often in the list). |
| NEGBINOMDIST |
Computes the negative binomial distribution. |
| NORMDIST |
Computes the normal distribution. |
| NORMINV |
Computes the inverse of the cumulative normal distribution. |
| NORMSDIST |
Computes the standard normal cumulative distribution (often called "the bell curve"). |
| NORMSINV |
Computes the inverse of the standard normal distribution. |
| PEARSON |
Computes the correlation coefficient for two sets of numbers, paired up one-to-one. |
| PERCENTILE |
Computes the value corresponding to the specified percentile of a specified range of numbers. |
| PERCENTRANK |
Computes the percent rank of a specified value in a specified array of numbers. |
| PERMUT |
Computes the number of combinations possible by taking k items at a time from a pool of n, where order in the sample taken is important. |
| POISSON |
Computes the Poisson distribution, which is usually used to determine the probability of a certain number of repeated events taking place over time. |
| PROB |
Given a set of numbers and a probability associated with each number, computes the probability corresponding to a specified number. |
| QUARTILE |
Computes the value corresponding to the specified quartile in a specified array of numbers. |
| RANK |
Computes the rank of a specified value in a specified array of numbers. |
| RSQ |
Computes the square of the correlation coefficient for two sets of numbers, paired up one-to-one. |
| SKEW |
Computes the skewness of a set of numbers. |
| SLOPE |
Computes the slope of the least squares linear regression line through the given data. |
| SMALL |
Computes the Xth smallest value in a list. |
| STANDARDIZE |
Computes the proper argument for the function that calculates the standard normal cumulative distribution, given specified values for x, mean, and standard deviation. |
| STDEV |
Returns the standard deviation of a population based on a sample of supplied values. |
| STDEVA |
Returns the standard deviation of a population based on a sample of supplied values, considering textual values. |
| STDEVP |
Returns the standard deviation of a population based on an entire population of values. |
| STDEVPA |
Returns the standard deviation of a population based on an entire population of values, considering textual values. |
| STEYX |
Computes the standard error of the predicted y-value for each x in the regression. |
| TDIST |
Computes the complementary student's T-distribution. |
| TINV |
Computes the x value corresponding to a specified probability value, given a specified number of degrees of freedom. |
| TREND |
Computes result values from the fitted curve of a multiple linear regression for a group of specified observations relative to a group of specified independent variables. |
| TRIMMEAN |
Computes the mean of a list of numbers after reducing a specified percent of the members of the list. |
| TTEST |
Computes the student's T-distribution from the data in two specified arrays, then computes the probability. |
| VAR |
Returns the variance of a population based on a sample of values. |
| VARA |
Returns the variance of a population based on a sample of values, considering textual values. |
| VARP |
Returns the variance of a population based on an entire population of values. |
| VARPA |
Returns the variance of a population based on the entire population of values, considering textual values. |
| WEIBULL |
Computes the Weibull distribution. |
| ZTEST |
Computes the two-tailed probability of a z-test, which is a test of a specified value against a specified set of numbers. |
