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

From Apache OpenOffice Wiki
Jump to: navigation, search
(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 Rank_c-th largest value in a data set.
+
|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 the alpha-percentile of data values in an array.  
+
|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 value in a sample.
+
|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 the quartile of a data set.
+
|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 sample.
+
|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 Rank_c-th smallest value in a data set.
+
|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 data set without the Alpha percent of data at the margins.
+
|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.


See also

Functions listed by category

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