Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(POISSON description) |
m |
||
(21 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" | ||
− | | | + | |colspan="2"|'''<big>Measures of Central Tendency</big>''' |
− | + | ||
|-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: | + | |[[Documentation/How_Tos/Calc: COUNT function|'''COUNT''']] |
− | | | + | |Counts the numbers in the list of arguments, ignoring text entries. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: COUNTA function|'''COUNTA''']] |
− | | | + | |Counts the non-empty values in the list of arguments. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: GEOMEAN function|'''GEOMEAN''']] |
− | |Returns the | + | |Returns the geometric mean of the arguments. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[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 set of numbers. | ||
+ | |-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, 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" | ||
+ | |colspan="2"|'''<big>Probability and statistics</big>''' | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: B function|'''B''']] | ||
|Calculates probabilities for a binomial distribution. | |Calculates probabilities for a binomial distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: BETADIST function|'''BETADIST''']] |
− | | | + | |Calculates the cumulative distribution function of a beta distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: BETAINV function|'''BETAINV''']] |
− | | | + | |Calculates the inverse of the BETADIST function. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: BINOMDIST function|'''BINOMDIST''']] |
− | | | + | |Calculates probabilities for a binomial distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CHIDIST function|'''CHIDIST''']] |
− | | | + | |Calculates right-tail values for a cumulative χ<sup>2</sup>-distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']] |
− | | | + | |Calculates left-tail values for a cumulative χ<sup>2</sup>-distribution |
+ | or values for the density function. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']] |
− | | | + | |Calculates the inverse of the CHIDIST function. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CHISQINV function|'''CHISQINV''']] |
− | | | + | |Calculates the inverse of the CHISQDIST function. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CHITEST function|'''CHITEST''']] |
− | |Returns | + | |Returns a measure of χ<sup>2</sup> 'goodness of fit'. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CONFIDENCE function|'''CONFIDENCE''']] |
− | |Returns | + | |Returns a confidence interval. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CRITBINOM function|'''CRITBINOM''']] |
− | |Returns the | + | |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: EXPONDIST function|EXPONDIST]] | + | |[[Documentation/How_Tos/Calc: EXPONDIST function|'''EXPONDIST''']] |
|Calculates values for an 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''']] |
|Returns the inverse of the F probability distribution. | |Returns the inverse of the F probability distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FISHER function|FISHER]] | + | |[[Documentation/How_Tos/Calc: FISHER function|'''FISHER''']] |
|Calculates values for the Fisher transformation. | |Calculates values for the Fisher transformation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]] | + | |[[Documentation/How_Tos/Calc: FISHERINV function|'''FISHERINV''']] |
|Calculates the inverse of the FISHER transformation. | |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''']] |
|Calculates the values of an F distribution. | |Calculates the values of an F distribution. | ||
|-valign="top" | |-valign="top" | ||
− | + | |[[Documentation/How_Tos/Calc: FTEST function|'''FTEST''']] | |
− | + | ||
− | + | ||
− | |[[Documentation/How_Tos/Calc: FTEST function|FTEST]] | + | |
|Returns the result of an F test. | |Returns the result of an F test. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]] | + | |[[Documentation/How_Tos/Calc: GAMMA function|'''GAMMA''']] |
+ | |Calculates the GAMMA function; not a statical function, but actually | ||
+ | in this category. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMAINV''']] | ||
|Calculates the inverse of the cumulative GAMMADIST function. | |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. | |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''']] |
|Calculates values for 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''']] |
|Returns the standard normal cumulative distribution. | |Returns the standard normal cumulative distribution. | ||
|-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" | |-valign="top" | ||
− | + | |[[Documentation/How_Tos/Calc: LOGINV function|'''LOGINV''']] | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | |[[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: | + | |[[Documentation/How_Tos/Calc: NEGBINOMDIST function|'''NEGBINOMDIST''']] |
− | | | + | |Calculates probabilities for a negative binomial distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: NORMINV function|'''NORMINV''']] |
− | |Returns the | + | |Returns the inverse of the normal cumulative distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: NORMDIST function|'''NORMDIST''']] |
− | | | + | |Calculates values for a normal distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: NORMSINV function|'''NORMSINV''']] |
− | |Returns the | + | |Returns the inverse of the standard normal cumulative distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: NORMSDIST function|'''NORMSDIST''']] |
− | | | + | |Calculates values for the standard normal cumulative distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PERMUT function|'''PERMUT''']] |
− | |Returns the | + | |Returns the number of permutations for a given number of objects. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PERMUTATIONA function|'''PERMUTATIONA''']] |
− | | | + | |Returns the number of permutations for a given number of objects |
+ | (repetition allowed). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PHI function|'''PHI''']] |
− | | | + | |Calculates values for the standard normal probability distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: POISSON function|'''POISSON''']] |
− | |Calculates values for a | + | |Calculates values for a Poisson distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PROB function|'''PROB''']] |
− | |Returns | + | |Returns a result from a list of probabilities. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: STANDARDIZE function|'''STANDARDIZE''']] |
− | | | + | |Converts a random variable to a normalized value. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: TDIST function|'''TDIST''']] |
− | |Returns the | + | |Returns the t-distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: TINV function|'''TINV''']] |
− | |Returns | + | |Returns the inverse of the t-distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: TTEST function|'''TTEST''']] |
− | |Returns the | + | |Returns the probability associated with a Student's t-Test. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: WEIBULL function|'''WEIBULL''']] |
− | |Returns the | + | |Returns the values of the Weibull distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: ZTEST function|'''ZTEST''']] |
− | |Returns the | + | |Returns the two-tailed P value of a z test with standard distribution. |
+ | |||
|-valign="top" | |-valign="top" | ||
− | | | + | |colspan="2"|'''<big>Correlation and line fitting</big>''' |
− | + | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: CORREL function|'''CORREL''']] |
− | | | + | |Returns the correlation coefficient between two data sets. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: COVAR function|'''COVAR''']] |
− | |Returns | + | |Returns the covariance of the product of paired deviations. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[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: | + | |[[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" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PEARSON function|'''PEARSON''']] |
− | |Returns | + | |Returns the Pearson product moment correlation coefficient r. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: RSQ function|'''RSQ''']] |
− | |Returns the | + | |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: | + | |[[Documentation/How_Tos/Calc: STEYX function|'''STEYX''']] |
− | |Returns the | + | |Returns the standard error of the predicted y value for each x in |
+ | the regression. | ||
|-valign="top" | |-valign="top" | ||
− | | | + | |colspan="2"|'''see also (in the Array Function category)''' |
− | + | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']] |
− | | | + | |returns an array of values for an exponential least squares fit to |
+ | known data pairs. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']] |
− | | | + | |returns an array of statistics for a straight line that best fits a |
+ | data set. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']] |
− | | | + | |returns an array of statistics for an exponential curve that best fits a |
+ | data set. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: TREND function|'''TREND''']] |
− | | | + | |fits a straight line to a data set using linear regression and returns |
+ | points on that line. | ||
+ | |||
|-valign="top" | |-valign="top" | ||
− | | | + | |colspan="2"|'''<big>Ranking</big>''' |
− | + | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: LARGE function|'''LARGE''']] |
− | |Returns the | + | |Returns the n<sup>th</sup> largest value in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MAX function|'''MAX''']] |
− | |Returns the | + | |Returns the maximum value in a list of arguments. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MAXA function|'''MAXA''']] |
− | |Returns the | + | |Returns the maximum value in a list of arguments including text. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MIN function|'''MIN''']] |
− | |Returns the | + | |Returns the minimum value in a list of arguments. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: MINA function|'''MINA''']] |
− | |Returns the | + | |Returns the minimum value in a list of arguments, including text. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PERCENTILE function|'''PERCENTILE''']] |
− | |Returns | + | |Returns a specified percentile in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: PERCENTRANK function|'''PERCENTRANK''']] |
− | |Returns the | + | |Returns the percentage rank of a number in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: QUARTILE function|'''QUARTILE''']] |
− | |Returns | + | |Returns a specified quartile in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: RANK function|'''RANK''']] |
− | |Returns the | + | |Returns the rank of a number in a list of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc: SMALL function|'''SMALL''']] |
− | |Returns the | + | |Returns the n<sup>th</sup> smallest value in a list of numbers. |
|} | |} | ||
Line 240: | Line 309: | ||
<!-- why on earth is this necessary? --> | <!-- why on earth is this necessary? --> | ||
− | + | {{SeeAlso|EN| | |
− | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]], | |
− | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]] | |
+ | }} | ||
+ | [[Category: Documentation/Reference/Calc]] |