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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
 
(28 intermediate revisions by 7 users not shown)
Line 1: Line 1:
−
==List of Calc Statistical functions==
+
{{DISPLAYTITLE:Statistical Functions}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevPage={{{ShowPrevPage}}}
 +
|PrevPage={{{PrevPage}}}
 +
|ShowNextPage={{{ShowNextPage}}}
 +
|NextPage={{{NextPage}}}
 +
|bookid=CalcFunctions
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
 +
|ShowParttitle=block
 +
|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]]
 +
|ShowPrevPart=block
 +
|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions
 +
|ShowNextPart=block
 +
|NextPart=Documentation/How_Tos/Calc:_Text_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
}}__NOTOC__
 +
 
 +
[[File:open.jpg]]
 +
 
 +
== <big>List of Calc Statistical functions</big> ==
  
 
The Statistical functions allow statistical analysis of data.
 
The Statistical functions allow statistical analysis of data.
  
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 +
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]]
+
|colspan="2"|'''<big>Measures of Central Tendency</big>'''
−
|Returns the average of the absolute deviations of data points from their mean.
+
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]]
+
|[[Documentation/How_Tos/Calc: AVEDEV function|'''AVEDEV''']]
 +
|Returns the average of the absolute deviations of values from their mean.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: AVERAGE function|'''AVERAGE''']]
 
|Returns the average of the arguments, ignoring text.
 
|Returns the average of the arguments, ignoring text.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]]
+
|[[Documentation/How_Tos/Calc: AVERAGEA function|'''AVERAGEA''']]
 
|Returns the average of the arguments, including text (valued as 0).
 
|Returns the average of the arguments, including text (valued as 0).
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: B function|B]]
+
|[[Documentation/How_Tos/Calc: COUNT function|'''COUNT''']]
−
|Returns the probability of a sample with binomial distribution.
+
|Counts the numbers in the list of arguments, ignoring text entries.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: BETADIST function|BETADIST]]
+
|[[Documentation/How_Tos/Calc: COUNTA function|'''COUNTA''']]
−
|Returns the cumulative beta probability density function.
+
|Counts the non-empty values in the list of arguments.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: BETAINV function|BETAINV]]
+
|[[Documentation/How_Tos/Calc: GEOMEAN function|'''GEOMEAN''']]
−
|Returns the inverse of the cumulative beta probability density function.
+
|Returns the geometric mean of the arguments.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]
+
|[[Documentation/How_Tos/Calc: HARMEAN function|'''HARMEAN''']]
−
|Returns the individual term binomial distribution probability.
+
|Returns the harmonic mean of the arguments.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUNT function|COUNT]]
+
|[[Documentation/How_Tos/Calc: MEDIAN function|'''MEDIAN''']]
−
|Counts how many numbers are in the list of arguments, ignoring text.
+
|Returns the median of a set of numbers.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]]
+
|[[Documentation/How_Tos/Calc: MODE function|'''MODE''']]
−
|Counts how many values are in the list of arguments, including text entries.
+
|Returns the most common value in a set of numbers.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CHIINV function|CHIINV]]
+
|[[Documentation/How_Tos/Calc: TRIMMEAN function|'''TRIMMEAN''']]
−
|Returns the inverse of the one-tailed probability of the chi-squared distribution.
+
|Returns the mean of a set of numbers, ignoring a proportion
 +
of high and low values.
 +
 
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CHITEST function|CHITEST]]
+
|colspan="2"|'''<big>Measures of dispersion / spread</big>'''
−
|Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.
+
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]]
+
|[[Documentation/How_Tos/Calc: DEVSQ function|'''DEVSQ''']]
−
|Returns the probability value from the indicated Chi square that a hypothesis is confirmed.  
+
|Returns the sum of squares of deviations from the mean.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: KURT function|'''KURT''']]
 +
|Returns the kurtosis, a measure of how peaked or flat a distribution is.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: SKEW function|'''SKEW''']]
 +
|Returns a measure of how skewed a distribution is.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: STDEV function|'''STDEV''']]
 +
|Returns the sample standard deviation.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: STDEVA function|'''STDEVA''']]
 +
|Returns the sample standard deviation (allowing text and logical values).
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: STDEVP function|'''STDEVP''']]
 +
|Returns the population standard deviation.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: STDEVPA function|'''STDEVPA''']]
 +
|Returns the population standard deviation (allowing text and logical values).
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: VAR function|'''VAR''']]
 +
|Returns the sample variance.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: VARA function|'''VARA''']]
 +
|Returns the sample variance (allowing text and logical values).
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: VARP function|'''VARP''']]
 +
|Returns the population variance.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: VARPA function|'''VARPA''']]
 +
|Returns the population variance (allowing text and logical values).
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]]
+
|colspan="2"|'''<big>Probability and statistics</big>'''
−
|Returns the (1-alpha) confidence interval for a normal distribution.
+
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CORREL function|CORREL]]
+
|[[Documentation/How_Tos/Calc: B function|'''B''']]
−
|Returns the correlation coefficient between two data sets.
+
|Calculates probabilities for a binomial distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COVAR function|COVAR]]
+
|[[Documentation/How_Tos/Calc: BETADIST function|'''BETADIST''']]
−
|Returns the covariance of the product of paired deviations.
+
|Calculates the cumulative distribution function of a beta distribution.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]]
+
|[[Documentation/How_Tos/Calc: BETAINV function|'''BETAINV''']]
−
|Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
+
|Calculates the inverse of the BETADIST function.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]]
+
|[[Documentation/How_Tos/Calc: BINOMDIST function|'''BINOMDIST''']]
−
|Returns the sum of squares of deviations based on a sample mean.
+
|Calculates probabilities for a binomial distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]]
+
|[[Documentation/How_Tos/Calc: CHIDIST function|'''CHIDIST''']]
−
|Returns the exponential distribution.
+
|Calculates right-tail values for a cumulative &chi;<sup>2</sup>-distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FINV function|FINV]]
+
|[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']]
−
|
+
|Calculates left-tail values for a cumulative &chi;<sup>2</sup>-distribution
−
Returns the inverse of the F probability distribution.
+
or values for the density function.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FISHER function|FISHER]]
+
|[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']]
−
|Returns the Fisher transformation for x and creates a function close to a normal distribution.
+
|Calculates the inverse of the CHIDIST function.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]]
+
|[[Documentation/How_Tos/Calc: CHISQINV function|'''CHISQINV''']]
−
|Returns the inverse of the Fisher transformation for x.
+
|Calculates the inverse of the CHISQDIST function.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FDIST function|FDIST]]
+
|[[Documentation/How_Tos/Calc: CHITEST function|'''CHITEST''']]
−
|Calculates the values of an F distribution.
+
|Returns a measure of &chi;<sup>2</sup> 'goodness of fit'.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FORECAST function|FORECAST]]
+
|[[Documentation/How_Tos/Calc: CONFIDENCE function|'''CONFIDENCE''']]
−
|Extrapolates future values based on existing x and y values.
+
|Returns a confidence interval.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FTEST function|FTEST]]
+
|[[Documentation/How_Tos/Calc: CRITBINOM function|'''CRITBINOM''']]
−
|Returns the result of an F test.
+
|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: GAMMAINV function|GAMMAINV]]
+
|[[Documentation/How_Tos/Calc: EXPONDIST function|'''EXPONDIST''']]
−
|Returns the inverse of the Gamma cumulative distribution.  
+
|Calculates values for an exponential distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]]
+
|[[Documentation/How_Tos/Calc: FINV function|'''FINV''']]
−
|Returns the natural logarithm of the Gamma function: G(x).
+
|Returns the inverse of the F probability distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]]
+
|[[Documentation/How_Tos/Calc: FISHER function|'''FISHER''']]
−
|Returns the values of a Gamma distribution.
+
|Calculates values for the Fisher transformation.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: GAUSS function|GAUSS]]
+
|[[Documentation/How_Tos/Calc: FISHERINV function|'''FISHERINV''']]
−
|Returns the standard normal cumulative distribution.
+
|Calculates the inverse of the FISHER transformation.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]]
+
|[[Documentation/How_Tos/Calc: FDIST function|'''FDIST''']]
−
|Returns the geometric mean of a sample.
+
|Calculates the values of an F distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]]
+
|[[Documentation/How_Tos/Calc: FTEST function|'''FTEST''']]
−
|Returns the harmonic mean of a data set.
+
|Returns the result of an F test.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]]
+
|[[Documentation/How_Tos/Calc: GAMMA function|'''GAMMA''']]
−
|Returns the hypergeometric distribution.
+
|Calculates the GAMMA function; not a statical function, but actually
 +
in this category.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]]
+
|[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMAINV''']]
−
|Calculates the point at which a line will intersect the y-values by using known x-values and y-values.
+
|Calculates the inverse of the cumulative GAMMADIST function.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: KURT function|KURT]]
+
|[[Documentation/How_Tos/Calc: GAMMALN function|'''GAMMALN''']]
−
|Returns the kurtosis of a data set (at least 4 values required).
+
|Returns the natural logarithm of the gamma function.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: LARGE function|LARGE]]
+
|[[Documentation/How_Tos/Calc: GAMMADIST function|'''GAMMADIST''']]
−
|Returns the Rank_c-th largest value in a data set.
+
|Calculates values for a gamma distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: LOGINV function|LOGINV]]
+
|[[Documentation/How_Tos/Calc: GAUSS function|'''GAUSS''']]
 +
|Returns the standard normal cumulative distribution.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: HYPGEOMDIST function|'''HYPGEOMDIST''']]
 +
|Calculates values for a hypergeometric distribution.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: LOGINV function|'''LOGINV''']]
 
|Returns the inverse of the lognormal distribution.
 
|Returns the inverse of the lognormal distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]]
+
|[[Documentation/How_Tos/Calc: LOGNORMDIST function|'''LOGNORMDIST''']]
 
|Returns the cumulative lognormal distribution.
 
|Returns the cumulative lognormal distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MAX function|MAX]]
+
|[[Documentation/How_Tos/Calc: NEGBINOMDIST function|'''NEGBINOMDIST''']]
−
|Returns the maximum value in a list of arguments.
+
|Calculates probabilities for a negative binomial distribution.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MAXA function|MAXA]]
+
|[[Documentation/How_Tos/Calc: NORMINV function|'''NORMINV''']]
−
|Returns the maximum value in a list of arguments including text.
+
|Returns the inverse of the normal cumulative distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]]
+
|[[Documentation/How_Tos/Calc: NORMDIST function|'''NORMDIST''']]
−
|Returns the median of a set of numbers.  
+
|Calculates values for a normal distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MIN function|MIN]]
+
|[[Documentation/How_Tos/Calc: NORMSINV function|'''NORMSINV''']]
−
|Returns the minimum value in a list of arguments.
+
|Returns the inverse of the standard normal cumulative distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MINA function|MINA]]
+
|[[Documentation/How_Tos/Calc: NORMSDIST function|'''NORMSDIST''']]
−
|Returns the minimum value in a list of arguments, including text.
+
|Calculates values for the standard normal cumulative distribution.  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MODE function|MODE]]
+
|[[Documentation/How_Tos/Calc: PERMUT function|'''PERMUT''']]
−
|Returns the most common value in a data set.  
+
|Returns the number of permutations for a given number of objects.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]]
+
|[[Documentation/How_Tos/Calc: PERMUTATIONA function|'''PERMUTATIONA''']]
−
|Returns the negative binomial distribution.
+
|Returns the number of permutations for a given number of objects
 +
(repetition allowed).
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NORMINV function|NORMINV]]
+
|[[Documentation/How_Tos/Calc: PHI function|'''PHI''']]
−
|Returns the inverse of the normal cumulative distribution.
+
|Calculates values for the standard normal probability distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]]
+
|[[Documentation/How_Tos/Calc: POISSON function|'''POISSON''']]
−
|Returns the density function or the normal cumulative distribution.
+
|Calculates values for a Poisson distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]]
+
|[[Documentation/How_Tos/Calc: PROB function|'''PROB''']]
−
|Returns the inverse of the standard normal cumulative distribution.
+
|Returns a result from a list of probabilities.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]]
+
|[[Documentation/How_Tos/Calc: STANDARDIZE function|'''STANDARDIZE''']]
−
|Returns the standard normal cumulative distribution function.  
+
|Converts a random variable to a normalized value.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]
+
|[[Documentation/How_Tos/Calc: TDIST function|'''TDIST''']]
−
|Returns the Pearson product moment correlation coefficient r.
+
|Returns the t-distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]]
+
|[[Documentation/How_Tos/Calc: TINV function|'''TINV''']]
−
|Returns the alpha-percentile of data values in an array.  
+
|Returns the inverse of the t-distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]]
+
|[[Documentation/How_Tos/Calc: TTEST function|'''TTEST''']]
−
|Returns the percentage rank of a value in a sample.
+
|Returns the probability associated with a Student's t-Test.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PERMUT function|PERMUT]]
+
|[[Documentation/How_Tos/Calc: WEIBULL function|'''WEIBULL''']]
−
|Returns the number of permutations for a given number of objects.
+
|Returns the values of the Weibull distribution.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]]
+
|[[Documentation/How_Tos/Calc: ZTEST function|'''ZTEST''']]
−
|Returns the number of permutations for a given number of objects (repetition allowed).
+
|Returns the two-tailed P value of a z test with standard distribution.
 +
 
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PHI function|PHI]]
+
|colspan="2"|'''<big>Correlation and line fitting</big>'''
−
|Returns the values of the distribution function for a standard normal distribution.
+
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: POISSON function|POISSON]]
+
|[[Documentation/How_Tos/Calc: CORREL function|'''CORREL''']]
−
|Returns the Poisson distribution.
+
|Returns the correlation coefficient between two data sets.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PROB function|PROB]]
+
|[[Documentation/How_Tos/Calc: COVAR function|'''COVAR''']]
−
|Returns the probability that values in a range are between two limits.  
+
|Returns the covariance of the product of paired deviations.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]]
+
|[[Documentation/How_Tos/Calc: FORECAST function|'''FORECAST''']]
−
|Returns the quartile of a data set.
+
|Extrapolates future values based on existing x and y values.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: RANK function|RANK]]
+
|[[Documentation/How_Tos/Calc: INTERCEPT function|'''INTERCEPT''']]
−
|Returns the rank of a number in a sample.
+
|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: RSQ function|RSQ]]
+
|[[Documentation/How_Tos/Calc: PEARSON function|'''PEARSON''']]
−
|Returns the square of the Pearson correlation coefficient based on the given values.  
+
|Returns the Pearson product moment correlation coefficient r.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SKEW function|SKEW]]
+
|[[Documentation/How_Tos/Calc: RSQ function|'''RSQ''']]
−
|Returns the skewness of a distribution.
+
|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''']]
 
|Returns the slope of the linear regression line for a data set.
 
|Returns the slope of the linear regression line for a data set.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SMALL function|SMALL]]
+
|[[Documentation/How_Tos/Calc: STEYX function|'''STEYX''']]
−
|Returns the Rank_c-th smallest value in a data set.
+
|Returns the standard error of the predicted y value for each x in  
 +
the regression.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]]
+
|colspan="2"|'''see also (in the Array Function category)'''
−
|Converts a random variable to a normalized value.
+
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: STDEV function|STDEV]]
+
|[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']]
−
|Estimates the standard deviation based on a sample.
+
|returns an array of values for an exponential least squares fit to
 +
known data pairs.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: STDEVA function|STDEVA]]
+
|[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']]
−
|Calculates the standard deviation of an estimation based on a sample.
+
|returns an array of statistics for a straight line that best fits a
 +
data set.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: STDEVP function|STDEVP]]
+
|[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']]
−
|Calculates the standard deviation based on the entire population.
+
|returns an array of statistics for an exponential curve that best fits a
 +
data set.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]]
+
|[[Documentation/How_Tos/Calc: TREND function|'''TREND''']]
−
|Calculates the standard deviation based on the entire population.
+
|fits a straight line to a data set using linear regression and returns
 +
points on that line.
 +
 
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: STEYX function|STEYX]]
+
|colspan="2"|'''<big>Ranking</big>'''
−
|Returns the standard error of the predicted y value for each x in the regression.
+
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TDIST function|TDIST]]
+
|[[Documentation/How_Tos/Calc: LARGE function|'''LARGE''']]
−
|Returns the t-distribution.
+
|Returns the n<sup>th</sup> largest value in a list of numbers.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TINV function|TINV]]
+
|[[Documentation/How_Tos/Calc: MAX function|'''MAX''']]
−
|Returns the inverse of the t-distribution.
+
|Returns the maximum value in a list of arguments.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]]
+
|[[Documentation/How_Tos/Calc: MAXA function|'''MAXA''']]
−
|Returns the mean of a data set without the Alpha percent of data at the margins.
+
|Returns the maximum value in a list of arguments including text.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TTEST function|TTEST]]
+
|[[Documentation/How_Tos/Calc: MIN function|'''MIN''']]
−
|Returns the probability associated with a Student's t-Test.
+
|Returns the minimum value in a list of arguments.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: VAR function|VAR]]
+
|[[Documentation/How_Tos/Calc: MINA function|'''MINA''']]
−
|Estimates the variance based on a sample.
+
|Returns the minimum value in a list of arguments, including text.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: VARA function|VARA]]
+
|[[Documentation/How_Tos/Calc: PERCENTILE function|'''PERCENTILE''']]
−
|Estimates a variance based on a sample. The value of text is 0.
+
|Returns a specified percentile in a list of numbers.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: VARP function|VARP]]
+
|[[Documentation/How_Tos/Calc: PERCENTRANK function|'''PERCENTRANK''']]
−
|Calculates a variance based on the entire population.
+
|Returns the percentage rank of a number in a list of numbers.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: VARPA function|VARPA]]
+
|[[Documentation/How_Tos/Calc: QUARTILE function|'''QUARTILE''']]
−
|Calculates the variance based on the entire population. The value of text is 0.
+
|Returns a specified quartile in a list of numbers.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]]
+
|[[Documentation/How_Tos/Calc: RANK function|'''RANK''']]
−
|Returns the values of the Weibull distribution.
+
|Returns the rank of a number in a list of numbers.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ZTEST function|ZTEST]]
+
|[[Documentation/How_Tos/Calc: SMALL function|'''SMALL''']]
−
|Returns the two-tailed P value of a z test with standard distribution.
+
|Returns the n<sup>th</sup> smallest value in a list of numbers.
  
 
|}
 
|}
Line 242: Line 309:
 
<!-- why on earth is this necessary? -->
 
<!-- why on earth is this necessary? -->
  
−
==See also==
+
{{SeeAlso|EN|
−
 
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]],
−
'''[[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]'''
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]
 +
}}
 +
[[Category: Documentation/Reference/Calc]]

Latest revision as of 13:03, 2 February 2024



Open.jpg

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.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Statistical_functions&oldid=260007"
Views
Personal tools
Navigation
Tools