Documentation/How Tos/Calc: Statistical functions

CALC FUNCTIONS

Statistical Functions

< Previous Section

Next Section >

FUNCTIONS

Spreadsheet Lookup functions

• AVEDEV
• AVERAGE
• AVERAGEA
• COUNT
• COUNTA
• GEOMEAN
• HARMEAN
• MEDIAN
• MODE
• TRIMMEAN

Measures of dispersion / spread

• DEVSQ
• KURT
• SKEW
• STDEV
• STEDEVA
• STDEVP
• STDEVPA
• VAR
• VARA
• VARP
• VARPA

Probability and statistics

• B
• BETADIST
• BETAINV
• BINOMDIST
• CHIDIST
• CHIINV
• CHISQINV
• CHITEST
• CONFIDENCE
• CRITBINOM
• EXPONDIST
• FINV
• FISHER
• FISHERINV
• FDIST
• FTEST
• GAMMA
• GAMMAINV
• GAMMALN
• GAMMADIST
• GAUSS
• HYPGEOMDIST
• LOGINV
• LOGNORMDIST
• NEGBINOMDIST
• NORMINV
• NORMDIST
• NORMSINV
• NORMSDIST
• PERMUT
• PERMUTATIONA
• PHI
• POISSON
• PROB
• STANDARDIZE
• TDIST
• TINV
• TTEST
• WEIBULL
• ZTEST

Correlation and line fitting

• CORREL
• COVAR
• FORECAST
• INTERCEPT
• PEARSON
• RSQ
• SLOPE
• STEYX

See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND

Ranking

• LARGE
• MAX
• MAXA
• MIN
• MINA
• PERCENTILE
• PERCENTRANK
• QUARTILE
• RANK
• SMALL

[[{{{PrevPage}}}|< Previous Page ]]

[[{{{NextPage}}}|Next Page >]]

List of Calc Statistical functions

The Statistical functions allow statistical analysis of data.

Measures of Central Tendency
AVEDEV	Returns the average of the absolute deviations of values from their mean.
AVERAGE	Returns the average of the arguments, ignoring text.
AVERAGEA	Returns the average of the arguments, including text (valued as 0).
COUNT	Counts the numbers in the list of arguments, ignoring text entries.
COUNTA	Counts the non-empty values in the list of arguments.
GEOMEAN	Returns the geometric mean of the arguments.
HARMEAN	Returns the harmonic mean of the arguments.
MEDIAN	Returns the median of a set of numbers.
MODE	Returns the most common value in a set of numbers.
TRIMMEAN	Returns the mean of a set of numbers, ignoring a proportion of high and low values.
Measures of dispersion / spread
DEVSQ	Returns the sum of squares of deviations from the mean.
KURT	Returns the kurtosis, a measure of how peaked or flat a distribution is.
SKEW	Returns a measure of how skewed a distribution is.
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).
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).
Probability and statistics
B	Calculates probabilities for a binomial distribution.
BETADIST	Calculates the cumulative distribution function of a beta distribution.
BETAINV	Calculates the inverse of the BETADIST function.
BINOMDIST	Calculates probabilities for a binomial distribution.
CHIDIST	Calculates right-tail values for a cumulative χ2-distribution.
CHISQDIST	Calculates left-tail values for a cumulative χ2-distribution or values for the density function.
CHIINV	Calculates the inverse of the CHIDIST function.
CHISQINV	Calculates the inverse of the CHISQDIST function.
CHITEST	Returns a measure of χ2 'goodness of fit'.
CONFIDENCE	Returns a confidence interval.
CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
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.
FTEST	Returns the result of an F test.
GAMMA	Calculates the GAMMA function; not a statical function, but actually in this category.
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.
HYPGEOMDIST	Calculates values for a hypergeometric distribution.
LOGINV	Returns the inverse of the lognormal distribution.
LOGNORMDIST	Returns the cumulative lognormal distribution.
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 standard normal cumulative distribution.
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	Calculates values for the standard normal probability distribution.
POISSON	Calculates values for a Poisson distribution.
PROB	Returns a result from a list of probabilities.
STANDARDIZE	Converts a random variable to a normalized value.
TDIST	Returns the t-distribution.
TINV	Returns the inverse of the t-distribution.
TTEST	Returns the probability associated with a Student's t-Test.
WEIBULL	Returns the values of the Weibull distribution.
ZTEST	Returns the two-tailed P value of a z test with standard distribution.
Correlation and line fitting
CORREL	Returns the correlation coefficient between two data sets.
COVAR	Returns the covariance of the product of paired deviations.
FORECAST	Extrapolates future values based on existing x and y values.
INTERCEPT	Calculates the point at which a line will intersect the y-values by using known x-values and y-values.
PEARSON	Returns the Pearson product moment correlation coefficient r.
RSQ	Returns the square of the Pearson correlation coefficient based on the given values.
SLOPE	Returns the slope of the linear regression line for a data set.
STEYX	Returns the standard error of the predicted y value for each x in the regression.
see also (in the Array Function category)
GROWTH	returns an array of values for an exponential least squares fit to known data pairs.
LINEST	returns an array of statistics for a straight line that best fits a data set.
LOGEST	returns an array of statistics for an exponential curve that best fits a data set.
TREND	fits a straight line to a data set using linear regression and returns points on that line.
Ranking
LARGE	Returns the nth largest value in a list of numbers.
MAX	Returns the maximum value in a list of arguments.
MAXA	Returns the maximum value in a list of arguments including text.
MIN	Returns the minimum value in a list of arguments.
MINA	Returns the minimum value in a list of arguments, including text.
PERCENTILE	Returns a specified percentile in a list of numbers.
PERCENTRANK	Returns the percentage rank of a number in a list of numbers.
QUARTILE	Returns a specified quartile in a list of numbers.
RANK	Returns the rank of a number in a list of numbers.
SMALL	Returns the nth smallest value in a list of numbers.

---

See Also

• Functions listed alphabetically,
• Functions listed by category