Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
(reworded stdev, var) |
||
| Line 192: | Line 192: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: STDEV function|STDEV]] | |[[Documentation/How_Tos/Calc: STDEV function|STDEV]] | ||
| − | | | + | |Returns the sample standard deviation. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: STDEVA function|STDEVA]] | |[[Documentation/How_Tos/Calc: STDEVA function|STDEVA]] | ||
| − | | | + | |Returns the sample standard deviation (allowing text and logical values). |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: STDEVP function|STDEVP]] | |[[Documentation/How_Tos/Calc: STDEVP function|STDEVP]] | ||
| − | | | + | |Returns the population standard deviation. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]] | |[[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]] | ||
| − | | | + | |Returns the population standard deviation (allowing text and logical values). |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: STEYX function|STEYX]] | |[[Documentation/How_Tos/Calc: STEYX function|STEYX]] | ||
| Line 219: | Line 219: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: VAR function|VAR]] | |[[Documentation/How_Tos/Calc: VAR function|VAR]] | ||
| − | | | + | |Returns the sample variance. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: VARA function|VARA]] | |[[Documentation/How_Tos/Calc: VARA function|VARA]] | ||
| − | | | + | |Returns the sample variance (allowing text and logical values). |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: VARP function|VARP]] | |[[Documentation/How_Tos/Calc: VARP function|VARP]] | ||
| − | | | + | |Returns the population variance. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: VARPA function|VARPA]] | |[[Documentation/How_Tos/Calc: VARPA function|VARPA]] | ||
| − | | | + | |Returns the population variance (allowing text and logical values). |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]] | |[[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]] | ||
Revision as of 18:56, 4 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 Rank_c-th largest value in a data set. |
| 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 the alpha-percentile of data values in an array. |
| PERCENTRANK | Returns the percentage rank of a value in a sample. |
| 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 the quartile of a data set. |
| RANK | Returns the rank of a number in a sample. |
| 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 Rank_c-th smallest value in a data set. |
| 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 data set without the Alpha percent of data at the margins. |
| 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. |
