Documentation/How Tos/Calc: Statistical functions

List of Calc Statistical functions

The Statistical functions allow statistical analysis of data.

AVEDEV	Returns the average of the absolute deviations of data points from their mean.
AVERAGE	Returns the average of the arguments, ignoring text.
AVERAGEA	Returns the average of the arguments, including text (valued as 0).
B	Calculates probabilities for a binomial distribution.
BETADIST	Returns the cumulative beta probability density function.
BETAINV	Returns the inverse of the cumulative beta probability density function.
BINOMDIST	Calculates probabilities for a binomial distribution.
COUNT	Counts how many numbers are in the list of arguments, ignoring text.
COUNTA	Counts how many values are in the list of arguments, including text entries.
CHIINV	Returns the inverse of the one-tailed probability of the chi-squared distribution.
CHITEST	Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.
CHIDIST	Returns the probability value from the indicated Chi square that a hypothesis is confirmed.
CONFIDENCE	Returns the (1-alpha) confidence interval for a normal distribution.
CORREL	Returns the correlation coefficient between two data sets.
COVAR	Returns the covariance of the product of paired deviations.
CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
DEVSQ	Returns the sum of squares of deviations from the mean.
EXPONDIST	Calculates values for an exponential distribution.
FINV	Returns the inverse of the F probability distribution.
FISHER	Calculates values for the Fisher transformation.
FISHERINV	Calculates the inverse of the FISHER transformation.
FDIST	Calculates the values of an F distribution.
FORECAST	Extrapolates future values based on existing x and y values.
FTEST	Returns the result of an F test.
GAMMAINV	Calculates the inverse of the cumulative GAMMADIST function.
GAMMALN	Returns the natural logarithm of the gamma function.
GAMMADIST	Calculates values for a gamma distribution.
GAUSS	Returns the standard normal cumulative distribution.
GEOMEAN	Returns the geometric mean of the arguments.
HARMEAN	Returns the harmonic mean of the arguments.
HYPGEOMDIST	Calculates values for a hypergeometric distribution.
INTERCEPT	Calculates the point at which a line will intersect the y-values by using known x-values and y-values.
KURT	Returns the kurtosis of a data set (at least 4 values required).
LARGE	Returns the nth largest value in a list of numbers.
LOGINV	Returns the inverse of the lognormal distribution.
LOGNORMDIST	Returns the cumulative lognormal distribution.
MAX	Returns the maximum value in a list of arguments.
MAXA	Returns the maximum value in a list of arguments including text.
MEDIAN	Returns the median of a set of numbers.
MIN	Returns the minimum value in a list of arguments.
MINA	Returns the minimum value in a list of arguments, including text.
MODE	Returns the most common value in a data set.
NEGBINOMDIST	Calculates probabilities for a negative binomial distribution.
NORMINV	Returns the inverse of the normal cumulative distribution.
NORMDIST	Calculates values for a normal distribution.
NORMSINV	Returns the inverse of the standard normal cumulative distribution.
NORMSDIST	Calculates values for the cumulative distribution function of a normal distribution.
PEARSON	Returns the Pearson product moment correlation coefficient r.
PERCENTILE	Returns a specified percentile in a list of numbers.
PERCENTRANK	Returns the percentage rank of a number in a list of numbers.
PERMUT	Returns the number of permutations for a given number of objects.
PERMUTATIONA	Returns the number of permutations for a given number of objects (repetition allowed).
PHI	Returns the values of the distribution function for a standard normal distribution.
POISSON	Calculates values for a Poisson distribution.
PROB	Returns a result from a list of probabilities.
QUARTILE	Returns a specified quartile in a list of numbers.
RANK	Returns the rank of a number in a list of numbers.
RSQ	Returns the square of the Pearson correlation coefficient based on the given values.
SKEW	Returns the skewness of a distribution.
SLOPE	Returns the slope of the linear regression line for a data set.
SMALL	Returns the nth smallest value in a list of numbers.
STANDARDIZE	Converts a random variable to a normalized value.
STDEV	Returns the sample standard deviation.
STDEVA	Returns the sample standard deviation (allowing text and logical values).
STDEVP	Returns the population standard deviation.
STDEVPA	Returns the population standard deviation (allowing text and logical values).
STEYX	Returns the standard error of the predicted y value for each x in the regression.
TDIST	Returns the t-distribution.
TINV	Returns the inverse of the t-distribution.
TRIMMEAN	Returns the mean of a set of numbers, ignoring a proportion of high and low values.
TTEST	Returns the probability associated with a Student's t-Test.
VAR	Returns the sample variance.
VARA	Returns the sample variance (allowing text and logical values).
VARP	Returns the population variance.
VARPA	Returns the population variance (allowing text and logical values).
WEIBULL	Returns the values of the Weibull distribution.
ZTEST	Returns the two-tailed P value of a z test with standard distribution.

See also

Functions listed by category