Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Changed descriptions to match those in function descriptions)
Line 54: Line 54:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]]
 
|[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]]
−
|Returns the sum of squares of deviations based on a sample mean.
+
|Returns the sum of squares of deviations from the mean.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]]
 
|[[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]]
−
|Returns the exponential distribution.
+
|Calculates values for an exponential distribution.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: FINV function|FINV]]
 
|[[Documentation/How_Tos/Calc: FINV function|FINV]]
Line 63: Line 63:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: FISHER function|FISHER]]
 
|[[Documentation/How_Tos/Calc: FISHER function|FISHER]]
−
|Returns the Fisher transformation for x and creates a function close to a normal distribution.
+
|Calculates values for the Fisher transformation.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]]
 
|[[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]]
−
|Returns the inverse of the Fisher transformation for x.
+
|Calculates the inverse of the FISHER transformation.  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: FDIST function|FDIST]]
 
|[[Documentation/How_Tos/Calc: FDIST function|FDIST]]
Line 78: Line 78:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]]
 
|[[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]]
−
|Returns the inverse of the Gamma cumulative distribution.  
+
|Calculates the inverse of the cumulative GAMMADIST function.  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]]
 
|[[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]]
−
|Returns the natural logarithm of the Gamma function: G(x).
+
|Returns the natural logarithm of the gamma function.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]]
 
|[[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]]
−
|Returns the values of a Gamma distribution.
+
|Calculates values for a gamma distribution.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: GAUSS function|GAUSS]]
 
|[[Documentation/How_Tos/Calc: GAUSS function|GAUSS]]
Line 96: Line 96:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]]
 
|[[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]]
−
|Returns the hypergeometric distribution.
+
|Calculates values for a hypergeometric distribution.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]]
 
|[[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]]
Line 132: Line 132:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]]
 
|[[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]]
−
|Returns the negative binomial distribution.
+
|Calculates probabilities for a negative binomial distribution.  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NORMINV function|NORMINV]]
 
|[[Documentation/How_Tos/Calc: NORMINV function|NORMINV]]
Line 138: Line 138:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]]
 
|[[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]]
−
|Returns the density function or the normal cumulative distribution.
+
|Calculates values for a normal distribution.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]]
 
|[[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]]
Line 144: Line 144:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]]
 
|[[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]]
−
|Returns the standard normal cumulative distribution function.  
+
|Calculates values for the cumulative distribution function of a normal distribution.  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]
 
|[[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]
Line 168: Line 168:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: PROB function|PROB]]
 
|[[Documentation/How_Tos/Calc: PROB function|PROB]]
−
|Returns the probability that values in a range are between two limits.  
+
|Returns a result from a list of probabilities.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]]
 
|[[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]]

Revision as of 04:43, 1 May 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 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.
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 from the mean.
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.
FORECAST Extrapolates future values based on existing x and y values.
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.
GEOMEAN Returns the geometric mean of the arguments.
HARMEAN Returns the harmonic mean of the arguments.
HYPGEOMDIST Calculates values for a 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 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 cumulative distribution function of a normal distribution.
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 a result from a list of probabilities.
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.


See also

Functions listed by category

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Statistical_functions&oldid=75409"
Personal tools