Documentation/How Tos/Calc: Statistical functions

From Apache OpenOffice Wiki
Jump to: navigation, search


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

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Statistical_functions&oldid=227660"
Views
Personal tools
Navigation
Print/export
Tools