Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(sub-categorisation) |
|||
Line 4: | Line 4: | ||
{| border="0" cellpadding="0" cellspacing="10" align="left" | {| border="0" cellpadding="0" cellspacing="10" align="left" | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big>Measures of Central Tendency</big>''' | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]] | |[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]] | ||
Line 13: | Line 16: | ||
|[[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]] | |[[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]] | ||
|Returns the average of the arguments, including text (valued as 0). | |Returns the average of the arguments, including text (valued as 0). | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: COUNT function|COUNT]] | ||
+ | |Counts how many numbers are in the list of arguments, ignoring text. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]] | ||
+ | |Counts how many values are in the list of arguments, including text entries. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]] | ||
+ | |Returns the geometric mean of the arguments. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]] | ||
+ | |Returns the harmonic mean of the arguments. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]] | ||
+ | |Returns the median of a set of numbers. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: MODE function|MODE]] | ||
+ | |Returns the most common value in a data set. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]] | ||
+ | |Returns the mean of a set of numbers, ignoring a proportion of high and low values. | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big>Measures of dispersion / spread</big>''' | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]] | ||
+ | |Returns the sum of squares of deviations from the mean. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: KURT function|KURT]] | ||
+ | |Returns the kurtosis of a data set (at least 4 values required). | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: SKEW function|SKEW]] | ||
+ | |Returns the skewness of a distribution. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: STDEV function|STDEV]] | ||
+ | |Returns the sample standard deviation. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: STDEVA function|STDEVA]] | ||
+ | |Returns the sample standard deviation (allowing text and logical values). | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: STDEVP function|STDEVP]] | ||
+ | |Returns the population standard deviation. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]] | ||
+ | |Returns the population standard deviation (allowing text and logical values). | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: VAR function|VAR]] | ||
+ | |Returns the sample variance. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: VARA function|VARA]] | ||
+ | |Returns the sample variance (allowing text and logical values). | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: VARP function|VARP]] | ||
+ | |Returns the population variance. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: VARPA function|VARPA]] | ||
+ | |Returns the population variance (allowing text and logical values). | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big>Probability and statistics</big>''' | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: B function|B]] | |[[Documentation/How_Tos/Calc: B function|B]] | ||
Line 25: | Line 88: | ||
|[[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]] | |[[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]] | ||
|Calculates probabilities for a binomial distribution. | |Calculates probabilities for a binomial distribution. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CHIINV function|CHIINV]] | |[[Documentation/How_Tos/Calc: CHIINV function|CHIINV]] | ||
Line 43: | Line 100: | ||
|[[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]] | |[[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]] | ||
|Returns the (1-alpha) confidence interval for a normal distribution. | |Returns the (1-alpha) confidence interval for a normal distribution. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]] | |[[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]] | ||
|Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. | |Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. | ||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]] | |[[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]] | ||
Line 70: | Line 118: | ||
|[[Documentation/How_Tos/Calc: FDIST function|FDIST]] | |[[Documentation/How_Tos/Calc: FDIST function|FDIST]] | ||
|Calculates the values of an F distribution. | |Calculates the values of an F distribution. | ||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: FTEST function|FTEST]] | |[[Documentation/How_Tos/Calc: FTEST function|FTEST]] | ||
Line 88: | Line 133: | ||
|[[Documentation/How_Tos/Calc: GAUSS function|GAUSS]] | |[[Documentation/How_Tos/Calc: GAUSS function|GAUSS]] | ||
|Returns the standard normal cumulative distribution. | |Returns the standard normal cumulative distribution. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]] | |[[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]] | ||
|Calculates values for a hypergeometric distribution. | |Calculates values for a hypergeometric distribution. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: LOGINV function|LOGINV]] | |[[Documentation/How_Tos/Calc: LOGINV function|LOGINV]] | ||
Line 112: | Line 142: | ||
|[[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]] | |[[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]] | ||
|Returns the cumulative lognormal distribution. | |Returns the cumulative lognormal distribution. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]] | |[[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]] | ||
Line 145: | Line 157: | ||
|[[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]] | |[[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]] | ||
|Calculates values for the standard normal cumulative distribution. | |Calculates values for the standard normal cumulative distribution. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: PERMUT function|PERMUT]] | |[[Documentation/How_Tos/Calc: PERMUT function|PERMUT]] | ||
Line 170: | Line 173: | ||
|Returns a result from a list of probabilities. | |Returns a result from a list of probabilities. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]] |
− | | | + | |Converts a random variable to a normalized value. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: TDIST function|TDIST]] |
− | |Returns the | + | |Returns the t-distribution. |
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: TINV function|TINV]] | ||
+ | |Returns the inverse of the t-distribution. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: TTEST function|TTEST]] | ||
+ | |Returns the probability associated with a Student's t-Test. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]] | ||
+ | |Returns the values of the Weibull distribution. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: ZTEST function|ZTEST]] | ||
+ | |Returns the two-tailed P value of a z test with standard distribution. | ||
+ | |||
+ | |-valign="top" | ||
+ | |colspan="2"|'''<big>Correlation and line fitting</big>''' | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: CORREL function|CORREL]] | ||
+ | |Returns the correlation coefficient between two data sets. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: COVAR function|COVAR]] | ||
+ | |Returns the covariance of the product of paired deviations. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: FORECAST function|FORECAST]] | ||
+ | |Extrapolates future values based on existing x and y values. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]] | ||
+ | |Calculates the point at which a line will intersect the y-values by using known x-values and y-values. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: PEARSON function|PEARSON]] | ||
+ | |Returns the Pearson product moment correlation coefficient r. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: RSQ function|RSQ]] | |[[Documentation/How_Tos/Calc: RSQ function|RSQ]] | ||
|Returns the square of the Pearson correlation coefficient based on the given values. | |Returns the square of the Pearson correlation coefficient based on the given values. | ||
− | |||
− | |||
− | |||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: SLOPE function|SLOPE]] | |[[Documentation/How_Tos/Calc: SLOPE function|SLOPE]] | ||
|Returns the slope of the linear regression line for a data set. | |Returns the slope of the linear regression line for a data set. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: STEYX function|STEYX]] |
− | |Returns the | + | |Returns the standard error of the predicted y value for each x in the regression. |
|-valign="top" | |-valign="top" | ||
− | | | + | |colspan="2"|'''see also (in the Array Function category)''' |
− | + | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']] |
− | | | + | |returns an array of values for an exponential least squares fit to known data pairs. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']] |
− | | | + | |returns an array of statistics for a straight line that best fits a data set. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']] |
− | | | + | |returns an array of statistics for an exponential curve that best fits a data set. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: TREND function|'''TREND''']] |
− | | | + | |fits a straight line to a data set using linear regression and returns points on that line. |
+ | |||
|-valign="top" | |-valign="top" | ||
− | | | + | |colspan="2"|'''<big>Ranking</big>''' |
− | + | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: LARGE function|LARGE]] |
− | |Returns the | + | |Returns the n<sup>th</sup> largest value in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MAX function|MAX]] |
− | |Returns the | + | |Returns the maximum value in a list of arguments. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MAXA function|MAXA]] |
− | |Returns the | + | |Returns the maximum value in a list of arguments including text. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MIN function|MIN]] |
− | |Returns the | + | |Returns the minimum value in a list of arguments. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MINA function|MINA]] |
− | |Returns the | + | |Returns the minimum value in a list of arguments, including text. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]] |
− | |Returns | + | |Returns a specified percentile in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]] |
− | |Returns the | + | |Returns the percentage rank of a number in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]] |
− | |Returns | + | |Returns a specified quartile in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: RANK function|RANK]] |
− | |Returns the | + | |Returns the rank of a number in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: SMALL function|SMALL]] |
− | |Returns the | + | |Returns the n<sup>th</sup> smallest value in a list of numbers. |
|} | |} |
Revision as of 17:44, 18 June 2008
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 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). |
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. |
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 data set. |
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 of a data set (at least 4 values required). |
SKEW | Returns the skewness of a distribution. |
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 | 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. |
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. |
CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is less 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. |
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. |