Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(reworded stdev, var) |
(→List of Calc Statistical functions: changed various descriptions) |
||
Line 105: | Line 105: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: LARGE function|LARGE]] | |[[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: LOGINV function|LOGINV]] | |[[Documentation/How_Tos/Calc: LOGINV function|LOGINV]] | ||
Line 150: | Line 150: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]] | |[[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: PERCENTRANK function|PERCENTRANK]] | |[[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]] | ||
− | |Returns the percentage rank of a | + | |Returns the percentage rank of a number in a list of numbers. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: PERMUT function|PERMUT]] | |[[Documentation/How_Tos/Calc: PERMUT function|PERMUT]] | ||
Line 171: | Line 171: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]] | |[[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: RANK function|RANK]] | |[[Documentation/How_Tos/Calc: RANK function|RANK]] | ||
− | |Returns the rank of a number in a | + | |Returns the rank of a number in a list of numbers. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: RSQ function|RSQ]] | |[[Documentation/How_Tos/Calc: RSQ function|RSQ]] | ||
Line 186: | Line 186: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: SMALL function|SMALL]] | |[[Documentation/How_Tos/Calc: SMALL function|SMALL]] | ||
− | |Returns the | + | |Returns the n<sup>th</sup> smallest value in a list of numbers. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]] | |[[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]] | ||
Line 213: | Line 213: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]] | |[[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]] | ||
− | |Returns the mean of a | + | |Returns the mean of a set of numbers, ignoring a proportion of high and low values. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: TTEST function|TTEST]] | |[[Documentation/How_Tos/Calc: TTEST function|TTEST]] |
Revision as of 19:36, 24 April 2008
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 the arguments. |
HARMEAN | Returns the harmonic mean of the arguments. |
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 nth largest value in a list of numbers. |
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 a specified percentile in a list of numbers. |
PERCENTRANK | Returns the percentage rank of a number in a list of numbers. |
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 a specified quartile in a list of numbers. |
RANK | Returns the rank of a number in a list of numbers. |
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 nth smallest value in a list of numbers. |
STANDARDIZE | Converts a random variable to a normalized value. |
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). |
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 set of numbers, ignoring a proportion of high and low values. |
TTEST | Returns the probability associated with a Student's t-Test. |
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). |
WEIBULL | Returns the values of the Weibull distribution. |
ZTEST | Returns the two-tailed P value of a z test with standard distribution. |