Statistical
104 functions in this section.
| AVEDEV | Returns the average of the absolute deviations of values from their mean. |
| AVERAGE | Returns the average (arithmetic mean) of the parameters. |
| AVERAGEA | Returns the average (arithmetic mean) of the parameters. |
| AVERAGEIF | Returns the average (arithmetic mean) of the array elements that satisfy a condition. |
| AVERAGEIFS | Returns the average (arithmetic mean) of all array elements which satisfy one or several conditions. |
| BETA.DIST | Returns the cumulative distribution function or the probability density function of a beta distribution. |
| BETA.INV | Returns the inverse of the cumulative BETA.DIST function. |
| BINOM.DIST | Returns a probability for a binomial distribution. |
| BINOM.DIST.RANGE | Returns the probability that the number of successes in a binomial experiment falls within a specified range. |
| BINOM.INV | Returns the smallest number of successes for which the cumulative binomial distribution is greater than or equal to a given threshold. |
| CHISQ.DIST | Returns a value for a chi-squared distribution. |
| CHISQ.DIST.RT | Returns the right-tailed probability of a chi-squared distribution, which is the probability that a value is at least the value of the X parameter. |
| CHISQ.INV | Returns the inverse of the cumulative CHISQ.DIST function. |
| CHISQ.INV.RT | Returns the inverse of the right-tailed CHISQ.DIST.RT function. |
| CHISQ.TEST | Returns the result of a chi-squared test, comparing observed values with expected values. |
| CONFIDENCE.NORM | Returns the margin of error of the mean of a population, given the standard deviation of the population and the size of a sample. |
| CONFIDENCE.T | Returns the margin of error of the mean of a population, given the standard deviation and the size of a sample. |
| CORREL | Returns the Pearson correlation coefficient of two sets of data. |
| COUNT | Returns the number of values which can be interpreted as numbers. |
| COUNTA | Returns the number of values which are not blank. |
| COUNTBLANK | Returns the number of elements of the given array which are either blank or are equal to the empty text string. |
| COUNTIF | Returns the number of array elements which satisfy a condition. |
| COUNTIFS | Returns the number of array elements which satisfy one or several conditions. |
| COVARIANCE.P | Returns the population covariance, which is the average of the products of the deviations of each pair of values from their means. |
| COVARIANCE.S | Returns the sample covariance, which is the sum of the products of the deviations of each pair of values from their means, divided by the number of pairs minus 1. |
| DEVSQ | Returns the sum of squares of deviations from the mean. |
| EXPON.DIST | Returns a value for an exponential distribution. |
| F.DIST | Returns a value for an F distribution. |
| F.DIST.RT | Returns the right-tailed probability of an F distribution, which is the probability that a value is at least the value of the X parameter. |
| F.INV | Returns the inverse of the cumulative F.DIST function. |
| F.INV.RT | Returns the inverse of the right-tailed F.DIST.RT function. |
| F.TEST | Returns the two-tailed probability of an F-test, which tests whether the variances of two sets of data differ. |
| FISHER | Returns the Fisher transformation of a number. |
| FISHERINV | Returns the inverse of the FISHER transformation. |
| FORECAST | Fits a straight line to data using linear regression and returns the vertical coordinate of a point on that line. |
| FREQUENCY | Returns the frequency distribution of the values of the first array when grouped into the intervals of the second array. |
| GAMMA | Returns the values of the Gamma function. |
| GAMMA.DIST | Returns a value for a Gamma distribution. |
| GAMMA.INV | Returns the inverse of the cumulative GAMMA.DIST function. |
| GAMMALN | Returns the natural logarithm of the gamma function. |
| GAMMALN.PRECISE | Returns the natural logarithm of the gamma function. |
| GAUSS | Returns the probability that a value drawn from the standard normal distribution lies between 0, the mean, and the given number. |
| GEOMEAN | Returns the geometric mean of the parameters. |
| GROWTH | Returns the points of an exponential curve of the form y = b * m ^ x through the given data points using linear regression. |
| HARMEAN | Returns the harmonic mean of the given values. |
| HYPGEOM.DIST | Returns a probability for the hypergeometric distribution. |
| INTERCEPT | Fits a straight line to data using linear regression and returns its intercept on the vertical axis. |
| KURT | Returns the excess kurtosis of the given values. |
| LARGE | Returns the nth largest value in the given array, where n is given as the second parameter. |
| LINEST | Finds a straight line, y = m * x + b, that best fits the given data, and returns an array containing two values corresponding to m and b in the equation above. |
| LOGNORM.DIST | Returns a value for a lognormal distribution. |
| LOGNORM.INV | Returns the inverse of the cumulative LOGNORM.DIST function. |
| MAX | Returns the largest number of the given numbers. |
| MAXA | Returns the largest number of the given numbers. |
| MAXIFS | Returns the largest value of all array elements which satisfy one or several conditions. |
| MEDIAN | Returns the median of the given values, which is the value in the middle when they are ordered. |
| MIN | Returns the smallest number of the given numbers. |
| MINA | Returns the smallest number of the given numbers. |
| MINIFS | Returns the smallest value of all array elements which satisfy one or several conditions. |
| MODE.MULT | Returns the values that appear most frequently. |
| MODE.SNGL | Returns the value that appears most frequently. |
| NEGBINOM.DIST | Returns a probability for a negative binomial distribution. |
| NORM.DIST | Returns a value for a normal distribution. |
| NORM.INV | Returns the inverse of the cumulative NORM.DIST function. |
| NORM.S.DIST | Returns a value for the standard normal distribution, which is the normal distribution with a mean of 0 and a standard deviation of 1. |
| NORM.S.INV | Returns the inverse of the cumulative NORM.S.DIST function. |
| PEARSON | Returns the Pearson correlation coefficient of two sets of data. |
| PERCENTILE.EXC | Returns the number of the given array at the kth percentile, where k is a number between 0 and 1 (exclusive), which can also be specified with the % operator (.5 equals 50%). |
| PERCENTILE.INC | Returns the number of the given array at the kth percentile, where k is a number between 0 and 1 (inclusive), which can also be specified with the % operator (.5 equals 50%). |
| PERCENTRANK.EXC | Returns the percentile rank of a number in an array. |
| PERCENTRANK.INC | Returns the percentile rank of a number in an array. |
| PERMUT | Returns the number of permutations for a given number of objects, where an object can only be chosen once. |
| PERMUTATIONA | Returns the number of permutations for a given number of objects, where objects can be repeated. |
| PHI | Returns the height of the curve of the standard normal distribution at the given number (the probability density function). |
| POISSON.DIST | Returns a probability for the Poisson distribution. |
| PROB | Returns the probability that a value is inside a given interval. |
| QUARTILE.EXC | Returns the number of the given array at the given quartile value. |
| QUARTILE.INC | Returns the number of the given array at the given quartile value. |
| RANK.AVG | Returns the rank of the given number in the given number array. |
| RANK.EQ | Returns the rank of the given number in the given number array. |
| RSQ | Returns the square of the Pearson correlation coefficient of two sets of data. |
| SKEW | Returns a measure of how asymmetric a distribution is around its mean. |
| SKEW.P | Returns a measure of how skewed a distribution is based on a population. |
| SLOPE | Fits a straight line to data using least-squares linear regression and returns its slope. |
| SMALL | Returns the nth smallest value in the given array, where n is given as the second parameter. |
| STANDARDIZE | Converts a value to a z-score in a standard normal distribution (mean 0, standard deviation 1). |
| STDEV.P | Returns the population standard deviation of the parameters. |
| STDEV.S | Returns the sample standard deviation of the parameters. |
| STDEVA | Returns the sample standard deviation of the parameters. |
| STDEVPA | Returns the population standard deviation of the parameters. |
| STEYX | Fits a straight line to data using linear regression and returns the standard error of the actual vertical coordinates compared to the vertical coordinates of the straight line. |
| T.DIST | Returns a value for Student's left-tailed t-distribution. |
| T.DIST.2T | Returns the two-tailed probability of Student's t-distribution, which is the probability that a value is at least as far from 0, in either direction, as the value of the X parameter. |
| T.DIST.RT | Returns the right-tailed probability of Student's t-distribution, which is the probability that a value is at least the value of the X parameter. |
| T.INV | Returns the inverse of the left-tailed T.DIST function. |
| T.INV.2T | Returns the inverse of the two-tailed T.DIST.2T function. |
| T.TEST | Returns the probability of a Student's t-test, which tests whether two sets of data are likely to come from populations with the same mean. |
| TRIMMEAN | Returns the mean (average) of the given values, ignoring a percentage of array elements at the beginning and end of the given array. |
| VAR.P | Returns the population variance of the parameters. |
| VAR.S | Returns the sample variance of the parameters. |
| VARA | Returns the sample variance of the parameters. |
| VARPA | Returns the population variance of the parameters. |
| WEIBULL.DIST | Returns a value for a Weibull distribution. |
| Z.TEST | Returns the one-tailed cumulative probability value of a Z-test. |