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

From Apache OpenOffice Wiki
Jump to: navigation, search
(sub-categorisation)
Line 4: Line 4:
  
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 +
 +
|-valign="top"
 +
|colspan="2"|'''<big>Measures of Central Tendency</big>'''
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]]
 
|[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]]
Line 13: Line 16:
 
|[[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"
 +
|[[Documentation/How_Tos/Calc: COUNT function|COUNT]]
 +
|Counts how many numbers are in the list of arguments, ignoring text.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]]
 +
|Counts how many values are in the list of arguments, including text entries.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]]
 +
|Returns the geometric mean of the arguments.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]]
 +
|Returns the harmonic mean of the arguments.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]]
 +
|Returns the median of a set of numbers.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: MODE function|MODE]]
 +
|Returns the most common value in a data set.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]]
 +
|Returns the mean of a set of numbers, ignoring a proportion of high and low values.
 +
 +
|-valign="top"
 +
|colspan="2"|'''<big>Measures of dispersion / spread</big>'''
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]]
 +
|Returns the sum of squares of deviations from the mean.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: KURT function|KURT]]
 +
|Returns the kurtosis of a data set (at least 4 values required).
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: SKEW function|SKEW]]
 +
|Returns the skewness of a distribution.
 +
|-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"
 +
|colspan="2"|'''<big>Probability and statistics</big>'''
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: B function|B]]
 
|[[Documentation/How_Tos/Calc: B function|B]]
Line 25: Line 88:
 
|[[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]
 
|[[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]]
 
|Calculates probabilities for a binomial distribution.
 
|Calculates probabilities for a binomial distribution.
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: COUNT function|COUNT]]
 
−
|Counts how many numbers are in the list of arguments, ignoring text.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]]
 
−
|Counts how many values are in the list of arguments, including text entries.
 
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: CHIINV function|CHIINV]]
 
|[[Documentation/How_Tos/Calc: CHIINV function|CHIINV]]
Line 43: Line 100:
 
|[[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]]
 
|[[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]]
 
|Returns the (1-alpha) confidence interval for a normal distribution.
 
|Returns the (1-alpha) confidence interval for a normal distribution.
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: CORREL function|CORREL]]
 
−
|Returns the correlation coefficient between two data sets.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: COVAR function|COVAR]]
 
−
|Returns the covariance of the product of paired deviations.
 
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]]
 
|[[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]]
 
|Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
 
|Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]]
 
−
|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]]
Line 70: Line 118:
 
|[[Documentation/How_Tos/Calc: FDIST function|FDIST]]
 
|[[Documentation/How_Tos/Calc: FDIST function|FDIST]]
 
|Calculates the values of an F distribution.
 
|Calculates the values of an F distribution.
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: FORECAST function|FORECAST]]
 
−
|Extrapolates future values based on existing x and y values.
 
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: FTEST function|FTEST]]
 
|[[Documentation/How_Tos/Calc: FTEST function|FTEST]]
Line 88: Line 133:
 
|[[Documentation/How_Tos/Calc: GAUSS function|GAUSS]]
 
|[[Documentation/How_Tos/Calc: GAUSS function|GAUSS]]
 
|Returns the standard normal cumulative distribution.
 
|Returns the standard normal cumulative distribution.
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]]
 
−
|Returns the geometric mean of the arguments.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]]
 
−
|Returns the harmonic mean of the arguments.
 
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]]
 
|[[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]]
 
|Calculates values for a hypergeometric distribution.
 
|Calculates values for a hypergeometric distribution.
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]]
 
−
|Calculates the point at which a line will intersect the y-values by using known x-values and y-values.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: KURT function|KURT]]
 
−
|Returns the kurtosis of a data set (at least 4 values required).
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: LARGE function|LARGE]]
 
−
|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 112: Line 142:
 
|[[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"
 
−
|[[Documentation/How_Tos/Calc: MAX function|MAX]]
 
−
|Returns the maximum value in a list of arguments.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: MAXA function|MAXA]]
 
−
|Returns the maximum value in a list of arguments including text.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]]
 
−
|Returns the median of a set of numbers.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: MIN function|MIN]]
 
−
|Returns the minimum value in a list of arguments.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: MINA function|MINA]]
 
−
|Returns the minimum value in a list of arguments, including text.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: MODE function|MODE]]
 
−
|Returns the most common value in a data set.
 
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]]
 
|[[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]]
Line 145: Line 157:
 
|[[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]]
 
|[[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]]
 
|Calculates values for the standard normal cumulative distribution.  
 
|Calculates values for the standard normal cumulative distribution.  
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]
 
−
|Returns the Pearson product moment correlation coefficient r.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]]
 
−
|Returns a specified percentile in a list of numbers.
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]]
 
−
|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 170: Line 173:
 
|Returns a result from a list of probabilities.
 
|Returns a result from a list of probabilities.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]]
+
|[[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]]
−
|Returns a specified quartile in a list of numbers.
+
|Converts a random variable to a normalized value.
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: RANK function|RANK]]
+
|[[Documentation/How_Tos/Calc: TDIST function|TDIST]]
−
|Returns the rank of a number in a list of numbers.
+
|Returns the t-distribution.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: TINV function|TINV]]
 +
|Returns the inverse of the t-distribution.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: TTEST function|TTEST]]
 +
|Returns the probability associated with a Student's t-Test.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]]
 +
|Returns the values of the Weibull distribution.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: ZTEST function|ZTEST]]
 +
|Returns the two-tailed P value of a z test with standard distribution.
 +
 
 +
|-valign="top"
 +
|colspan="2"|'''<big>Correlation and line fitting</big>'''
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: CORREL function|CORREL]]
 +
|Returns the correlation coefficient between two data sets.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: COVAR function|COVAR]]
 +
|Returns the covariance of the product of paired deviations.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: FORECAST function|FORECAST]]
 +
|Extrapolates future values based on existing x and y values.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]]
 +
|Calculates the point at which a line will intersect the y-values by using known x-values and y-values.
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]
 +
|Returns the Pearson product moment correlation coefficient r.
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: RSQ function|RSQ]]
 
|[[Documentation/How_Tos/Calc: RSQ function|RSQ]]
 
|Returns the square of the Pearson correlation coefficient based on the given values.  
 
|Returns the square of the Pearson correlation coefficient based on the given values.  
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: SKEW function|SKEW]]
 
−
|Returns the skewness of a distribution.
 
 
|-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 n<sup>th</sup> smallest value in a list of numbers.
+
|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''']]
−
|Returns the sample standard deviation.
+
|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''']]
−
|Returns the sample standard deviation (allowing text and logical values).
+
|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''']]
−
|Returns the population standard deviation.
+
|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''']]
−
|Returns the population standard deviation (allowing text and logical values).
+
|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 set of numbers, ignoring a proportion of high and low values.
+
|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]]
−
|Returns the sample variance.
+
|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]]
−
|Returns the sample variance (allowing text and logical values).
+
|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]]
−
|Returns the population variance.
+
|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]]
−
|Returns the population variance (allowing text and logical values).
+
|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.
  
 
|}
 
|}

Revision as of 17:44, 18 June 2008

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 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).
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.
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 data set.
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 of a data set (at least 4 values required).
SKEW Returns the skewness of a distribution.
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 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.
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.
CRITBINOM Returns the smallest value for which the cumulative binomial distribution is less 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.
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

Functions listed by category

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