Statistical functions

Statistical functions calculate values related to statistical distributions and probability, such as standard deviation and number of permutations.

In this category

Function	Description
BETA.DIST	Returns the beta distribution.
BETA.INV	Returns the inverse of the beta cumulative probability density function (BETA.DIST).
CHISQ.DIST	Returns the chi-squared distribution.
CHISQ.DIST.RT	Returns the right-tailed probability of the chi-squared distribution.
CHISQ.INV	Returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.INV.RT	Returns the inverse of the right-tailed probability of the chi-squared distribution.
COMBIN	Returns the number of combinations for a given number of items.
COMBINA	Returns the number of combinations (with repetitions) for a given number of items.
CONFIDENCE.NORM	The confidence interval is a range of values.
CONFIDENCE.T	Returns the confidence interval for a population mean, using a Student's t distribution.
EXPON.DIST	Returns the exponential distribution.
GEOMEAN	Returns the geometric mean of the numbers in a column.
GEOMEANX	Returns the geometric mean of an expression evaluated for each row in a table.
LINEST	Uses the Least Squares method to calculate a straight line that best fits the given data.
LINESTX	Uses the Least Squares method to calculate a straight line that best fits the given data. The data result from expressions evaluated for each row in a table.
MEDIAN	Returns the median of numbers in a column.
MEDIANX	Returns the median number of an expression evaluated for each row in a table.
NORM.DIST	Returns the normal distribution for the specified mean and standard deviation.
NORM.INV	The inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.S.DIST	Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
NORM.S.INV	Returns the inverse of the standard normal cumulative distribution.
PERCENTILE.EXC	Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC	Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTILEX.EXC	Returns the percentile number of an expression evaluated for each row in a table.
PERCENTILEX.INC	Returns the percentile number of an expression evaluated for each row in a table.
PERMUT	Returns the number of permutations for a given number of objects that can be selected from number objects.
POISSON.DIST	Returns the Poisson distribution.
RANK.EQ	Returns the ranking of a number in a list of numbers.
RANKX	Returns the ranking of a number in a list of numbers for each row in the table argument.
SAMPLE	Returns a sample of N rows from the specified table.
STDEV.P	Returns the standard deviation of the entire population.
STDEV.S	Returns the standard deviation of a sample population.
STDEVX.P	Returns the standard deviation of the entire population.
STDEVX.S	Returns the standard deviation of a sample population.
T.DIST	Returns the Student's left-tailed t-distribution.
T.DIST.2T	Returns the two-tailed Student's t-distribution.
T.DIST.RT	Returns the right-tailed Student's t-distribution.
T.INV	Returns the left-tailed inverse of the Student's t-distribution.
T.INV.2t	Returns the two-tailed inverse of the Student's t-distribution.
VAR.P	Returns the variance of the entire population.
VAR.S	Returns the variance of a sample population.
VARX.P	Returns the variance of the entire population.
VARX.S	Returns the variance of a sample population.