Редагувати

Поділитися через


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.