# Statistical functions

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 BETA.DIST function. |

BINOM.DIST | Returns a probability for a binomial distribution. |

BINOM.DIST.RANGE | Returns the probability for a binomial distribution over an interval. |

BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |

CHISQ.DIST | Returns a value for a chi-squared distribution. |

CHISQ.INV | Returns the inverse of the CHISQ.DIST function. |

CONFIDENCE.NORM | Returns a confidence interval for a normal distribution. |

CONFIDENCE.T | Returns a confidence interval for a Student's t-distribution. |

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, that is, the covariance of the product of paired deviations, for an entire population. |

COVARIANCE.S | Returns the sample covariance, that is, the covariance of the product of paired deviations, for a sample of the population. |

DEVSQ | Returns the sum of squares of deviations from the mean. |

EXPON.DIST | Returns a value for an exponential distribution. |

FISHER | Returns a value for the Fisher transformation. |

FISHERINV | Returns the inverse of the FISHER function. |

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 a value in the standard normal cumulative distribution. |

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 value for a hypergeometric distribution. |

INTERCEPT | Fits a straight line to data using linear regression and returns its intercept on the vertical axis. |

KURT | Returns a measure of how peaked or flat a distribution is (the kurtosis) based on the given parameters. |

LARGE | Returns the nth largest number 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 the cumulative distribution function of a lognormal distribution. |

LOGNORM.INV | Returns the inverse of the 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 number of all array elements which satisfy one or several conditions. |

MEDIAN | Returns the median of the given numbers. |

MIN | Returns the smallest number of the given numbers. |

MINA | Returns the smallest number of the given numbers. |

MINIFS | Returns the smallest number 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 cumulative distribution function of a normal distribution. |

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 (. |

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 (. |

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 a value for a standard normal distribution. |

POISSON.DIST | Returns a value for a 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. |

SERIESSUM | Returns the sum of the first terms of a power series. |

SKEW | Returns a measure of how skewed a distribution is, represented by the given parameters. |

SKEW.P | Returns a measure of how skewed a distribution is based on a population. |

SLOPE | Fits a straight line to data using linear regression and returns its slope. |

SMALL | Returns the nth smallest number in the given array, where n is given as the second parameter. |

STANDARDIZE | Converts a value in a normal distribution to its equivalent in a standard normal distribution. |

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.INV | Returns the inverse of the left-tailed T.DIST function. |

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. |