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	Returns the probability of a sample with binomial distribution.
BETADIST	Returns the cumulative beta probability density function.
BETAINV	Returns the inverse of the cumulative beta probability density function.
BINOMDIST	Returns the individual term binomial distribution probability.
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 based on a sample mean.
EXPONDIST	Returns the exponential distribution.
FINV	Returns the inverse of the F probability distribution.
FISHER	Returns the Fisher transformation for x and creates a function close to a normal distribution.
FISHERINV	Returns the inverse of the Fisher transformation for x.
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	Returns the inverse of the Gamma cumulative distribution.
GAMMALN	Returns the natural logarithm of the Gamma function: G(x).
GAMMADIST	Returns the values of a Gamma distribution.
GAUSS	Returns the standard normal cumulative distribution.
GEOMEAN	Returns the geometric mean of a sample.
HARMEAN	Returns the harmonic mean of a data set.
HYPGEOMDIST	Returns the 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 Rank_c-th largest value in a data set.
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	Returns the negative binomial distribution.
NORMINV	Returns the inverse of the normal cumulative distribution.
NORMDIST	Returns the density function or the normal cumulative distribution.
NORMSINV	Returns the inverse of the standard normal cumulative distribution.
NORMSDIST	Returns the standard normal cumulative distribution function.
PEARSON	Returns the Pearson product moment correlation coefficient r.
PERCENTILE	Returns the alpha-percentile of data values in an array.
PERCENTRANK	Returns the percentage rank of a value in a sample.
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	Returns the Poisson distribution.
PROB	Returns the probability that values in a range are between two limits.
QUARTILE	Returns the quartile of a data set.
RANK	Returns the rank of a number in a sample.
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 Rank_c-th smallest value in a data set.
STANDARDIZE	Converts a random variable to a normalized value.
STDEV	Estimates the standard deviation based on a sample.
STDEVA	Calculates the standard deviation of an estimation based on a sample.
STDEVP	Calculates the standard deviation based on the entire population.
STDEVPA	Calculates the standard deviation based on the entire population.
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 data set without the Alpha percent of data at the margins.
TTEST	Returns the probability associated with a Student's t-Test.
VAR	Estimates the variance based on a sample.
VARA	Estimates a variance based on a sample. The value of text is 0.
VARP	Calculates a variance based on the entire population.
VARPA	Calculates the variance based on the entire population. The value of text is 0.
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