Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (talk | contribs) |
Javier Lopez (talk | contribs) |
||
| Line 83: | Line 83: | ||
* [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]] | * [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]] | ||
* [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%;">Rsq]] | * [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%;">Rsq]] | ||
| − | * [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc:_SLOPE_function|<div style="font-size: 120%;">Slope]] |
* [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]] | * [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]] | ||
| − | <div style="font-size: | + | <div style="font-size: 100%;">''See also (in the [[Documentation/How_Tos/Calc:_Array_functions|Array Function]] category); GROWTH, LINEST, LOGEST, TREND''</div> |
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Ranking</div> | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Ranking</div> | ||
| Line 138: | Line 138: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: TRIMMEAN function|'''TRIMMEAN''']] | |[[Documentation/How_Tos/Calc: TRIMMEAN function|'''TRIMMEAN''']] | ||
| − | |Returns the mean of a set of numbers, ignoring a proportion of high and low values. | + | |Returns the mean of a set of numbers, ignoring a proportion |
| + | of high and low values. | ||
|-valign="top" | |-valign="top" | ||
| Line 195: | Line 196: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']] | |[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']] | ||
| − | |Calculates left-tail values for a cumulative χ<sup>2</sup>-distribution or values for the density function. | + | |Calculates left-tail values for a cumulative χ<sup>2</sup>-distribution |
| + | or values for the density function. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']] | |[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']] | ||
| Line 210: | Line 212: | ||
|-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 greater than or equal to a criterion value. | + | |Returns the smallest value for which the cumulative binomial distribution |
| + | is greater 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 231: | Line 234: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: GAMMA function|'''GAMMA''']] | |[[Documentation/How_Tos/Calc: GAMMA function|'''GAMMA''']] | ||
| − | |Calculates the GAMMA function; not a statical function, but actually in this category. | + | |Calculates the GAMMA function; not a statical function, but actually |
| + | in this category. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMAINV''']] | |[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMAINV''']] | ||
| Line 273: | Line 277: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: PERMUTATIONA function|'''PERMUTATIONA''']] | |[[Documentation/How_Tos/Calc: PERMUTATIONA function|'''PERMUTATIONA''']] | ||
| − | |Returns the number of permutations for a given number of objects (repetition allowed). | + | |Returns the number of permutations for a given number of objects |
| + | (repetition allowed). | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: PHI function|'''PHI''']] | |[[Documentation/How_Tos/Calc: PHI function|'''PHI''']] | ||
| Line 315: | Line 320: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: INTERCEPT function|'''INTERCEPT''']] | |[[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. | + | |Calculates the point at which a line will intersect the y-values |
| + | by using known x-values and y-values. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: PEARSON function|'''PEARSON''']] | |[[Documentation/How_Tos/Calc: PEARSON function|'''PEARSON''']] | ||
| Line 321: | Line 327: | ||
|-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''']] | ||
| Line 327: | Line 334: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: STEYX function|'''STEYX''']] | |[[Documentation/How_Tos/Calc: STEYX function|'''STEYX''']] | ||
| − | |Returns the standard error of the predicted y value for each x in the regression. | + | |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)''' | |colspan="2"|'''see also (in the Array Function category)''' | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']] | |[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']] | ||
| − | |returns an array of values for an exponential least squares fit to known data pairs. | + | |returns an array of values for an exponential least squares fit to |
| + | known data pairs. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']] | |[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']] | ||
| − | |returns an array of statistics for a straight line that best fits a data set. | + | |returns an array of statistics for a straight line that best fits a |
| + | data set. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']] | |[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']] | ||
| − | |returns an array of statistics for an exponential curve that best fits a data set. | + | |returns an array of statistics for an exponential curve that best fits a |
| + | data set. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: TREND function|'''TREND''']] | |[[Documentation/How_Tos/Calc: TREND function|'''TREND''']] | ||
| − | |fits a straight line to a data set using linear regression and returns points on that line. | + | |fits a straight line to a data set using linear regression and returns |
| + | points on that line. | ||
|-valign="top" | |-valign="top" | ||
Revision as of 22:12, 1 June 2013
CALC FUNCTIONS
Measures of Central Tendency
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Array Function category); GROWTH, LINEST, LOGEST, TREND
Ranking
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. |
