Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(sub-categorisation) |
m |
||
(19 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. | ||
Line 8: | Line 27: | ||
|colspan="2"|'''<big>Measures of Central Tendency</big>''' | |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''']] |
− | |Returns the average of the absolute deviations of | + | |Returns the average of the absolute deviations of values from their mean. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]] | + | |[[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: COUNT function|COUNT]] | + | |[[Documentation/How_Tos/Calc: COUNT function|'''COUNT''']] |
− | |Counts | + | |Counts the numbers in the list of arguments, ignoring text entries. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]] | + | |[[Documentation/How_Tos/Calc: COUNTA function|'''COUNTA''']] |
− | |Counts | + | |Counts the non-empty values in the list of arguments. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]] | + | |[[Documentation/How_Tos/Calc: GEOMEAN function|'''GEOMEAN''']] |
|Returns the geometric mean of the arguments. | |Returns the geometric mean of the arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]] | + | |[[Documentation/How_Tos/Calc: HARMEAN function|'''HARMEAN''']] |
|Returns the harmonic mean of the arguments. | |Returns the harmonic mean of the arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]] | + | |[[Documentation/How_Tos/Calc: MEDIAN function|'''MEDIAN''']] |
|Returns the median of a set of numbers. | |Returns the median of a set of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MODE function|MODE]] | + | |[[Documentation/How_Tos/Calc: MODE function|'''MODE''']] |
− | |Returns the most common value in a | + | |Returns the most common value in a set of numbers. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]] | + | |[[Documentation/How_Tos/Calc: TRIMMEAN function|'''TRIMMEAN''']] |
− | |Returns the mean of a set of numbers, ignoring a proportion of high and low values. | + | |Returns the mean of a set of numbers, ignoring a proportion |
+ | of high and low values. | ||
|-valign="top" | |-valign="top" | ||
|colspan="2"|'''<big>Measures of dispersion / spread</big>''' | |colspan="2"|'''<big>Measures of dispersion / spread</big>''' | ||
|-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 from the mean. | |Returns the sum of squares of deviations from the mean. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: KURT function|KURT]] | + | |[[Documentation/How_Tos/Calc: KURT function|'''KURT''']] |
− | |Returns the kurtosis of a | + | |Returns the kurtosis, a measure of how peaked or flat a distribution is. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SKEW function|SKEW]] | + | |[[Documentation/How_Tos/Calc: SKEW function|'''SKEW''']] |
− | |Returns | + | |Returns a measure of how skewed a distribution is. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEV function|STDEV]] | + | |[[Documentation/How_Tos/Calc: STDEV function|'''STDEV''']] |
|Returns the sample standard deviation. | |Returns the sample standard deviation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEVA function|STDEVA]] | + | |[[Documentation/How_Tos/Calc: STDEVA function|'''STDEVA''']] |
|Returns the sample standard deviation (allowing text and logical values). | |Returns the sample standard deviation (allowing text and logical values). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEVP function|STDEVP]] | + | |[[Documentation/How_Tos/Calc: STDEVP function|'''STDEVP''']] |
|Returns the population standard deviation. | |Returns the population standard deviation. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]] | + | |[[Documentation/How_Tos/Calc: STDEVPA function|'''STDEVPA''']] |
|Returns the population standard deviation (allowing text and logical values). | |Returns the population standard deviation (allowing text and logical values). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VAR function|VAR]] | + | |[[Documentation/How_Tos/Calc: VAR function|'''VAR''']] |
|Returns the sample variance. | |Returns the sample variance. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VARA function|VARA]] | + | |[[Documentation/How_Tos/Calc: VARA function|'''VARA''']] |
|Returns the sample variance (allowing text and logical values). | |Returns the sample variance (allowing text and logical values). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VARP function|VARP]] | + | |[[Documentation/How_Tos/Calc: VARP function|'''VARP''']] |
|Returns the population variance. | |Returns the population variance. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: VARPA function|VARPA]] | + | |[[Documentation/How_Tos/Calc: VARPA function|'''VARPA''']] |
|Returns the population variance (allowing text and logical values). | |Returns the population variance (allowing text and logical values). | ||
Line 77: | Line 97: | ||
|colspan="2"|'''<big>Probability and statistics</big>''' | |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''']] |
|Calculates probabilities for a binomial distribution. | |Calculates probabilities for a binomial distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BETADIST function|BETADIST]] | + | |[[Documentation/How_Tos/Calc: BETADIST function|'''BETADIST''']] |
− | | | + | |Calculates the cumulative distribution function of a beta distribution. |
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: BETAINV function|BETAINV]] | + | |[[Documentation/How_Tos/Calc: BETAINV function|'''BETAINV''']] |
− | | | + | |Calculates the inverse of the BETADIST function. |
|-valign="top" | |-valign="top" | ||
− | |[[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" | |-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: EXPONDIST function|EXPONDIST]] | + | |[[Documentation/How_Tos/Calc: CONFIDENCE function|'''CONFIDENCE''']] |
+ | |Returns a confidence interval. | ||
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: CRITBINOM function|'''CRITBINOM''']] | ||
+ | |Returns the smallest value for which the cumulative binomial distribution | ||
+ | is greater than or equal to a criterion value. | ||
+ | |-valign="top" | ||
+ | |[[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: NEGBINOMDIST function|NEGBINOMDIST]] | + | |[[Documentation/How_Tos/Calc: NEGBINOMDIST function|'''NEGBINOMDIST''']] |
|Calculates probabilities for a 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''']] |
|Returns the inverse of the normal cumulative distribution. | |Returns the inverse of the normal cumulative distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]] | + | |[[Documentation/How_Tos/Calc: NORMDIST function|'''NORMDIST''']] |
|Calculates values for a normal 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''']] |
|Returns the inverse of the standard normal cumulative distribution. | |Returns the inverse of the standard normal cumulative distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[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" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PERMUT function|PERMUT]] | + | |[[Documentation/How_Tos/Calc: PERMUT function|'''PERMUT''']] |
|Returns the number of permutations for a given number of objects. | |Returns the number of permutations for a given number of objects. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]] | + | |[[Documentation/How_Tos/Calc: PERMUTATIONA function|'''PERMUTATIONA''']] |
− | |Returns the number of permutations for a given number of objects (repetition allowed). | + | |Returns the number of permutations for a given number of objects |
+ | (repetition allowed). | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PHI function|PHI]] | + | |[[Documentation/How_Tos/Calc: PHI function|'''PHI''']] |
|Calculates values for the standard normal probability distribution. | |Calculates values for the standard normal probability distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: POISSON function|POISSON]] | + | |[[Documentation/How_Tos/Calc: POISSON function|'''POISSON''']] |
|Calculates values for a Poisson distribution. | |Calculates values for a Poisson distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PROB function|PROB]] | + | |[[Documentation/How_Tos/Calc: PROB function|'''PROB''']] |
|Returns a result from a list of probabilities. | |Returns a result from a list of probabilities. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]] | + | |[[Documentation/How_Tos/Calc: STANDARDIZE function|'''STANDARDIZE''']] |
|Converts a random variable to a normalized value. | |Converts a random variable to a normalized value. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TDIST function|TDIST]] | + | |[[Documentation/How_Tos/Calc: TDIST function|'''TDIST''']] |
|Returns the t-distribution. | |Returns the t-distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TINV function|TINV]] | + | |[[Documentation/How_Tos/Calc: TINV function|'''TINV''']] |
|Returns the inverse of the t-distribution. | |Returns the inverse of the t-distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: TTEST function|TTEST]] | + | |[[Documentation/How_Tos/Calc: TTEST function|'''TTEST''']] |
|Returns the probability associated with a Student's t-Test. | |Returns the probability associated with a Student's t-Test. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]] | + | |[[Documentation/How_Tos/Calc: WEIBULL function|'''WEIBULL''']] |
|Returns the values of the Weibull distribution. | |Returns the values of the Weibull distribution. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: ZTEST function|ZTEST]] | + | |[[Documentation/How_Tos/Calc: ZTEST function|'''ZTEST''']] |
|Returns the two-tailed P value of a z test with standard distribution. | |Returns the two-tailed P value of a z test with standard distribution. | ||
Line 194: | Line 227: | ||
|colspan="2"|'''<big>Correlation and line fitting</big>''' | |colspan="2"|'''<big>Correlation and line fitting</big>''' | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: CORREL function|CORREL]] | + | |[[Documentation/How_Tos/Calc: CORREL function|'''CORREL''']] |
|Returns the correlation coefficient between two data sets. | |Returns the correlation coefficient between two data sets. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: COVAR function|COVAR]] | + | |[[Documentation/How_Tos/Calc: COVAR function|'''COVAR''']] |
|Returns the covariance of the product of paired deviations. | |Returns the covariance of the product of paired deviations. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: FORECAST function|FORECAST]] | + | |[[Documentation/How_Tos/Calc: FORECAST function|'''FORECAST''']] |
|Extrapolates future values based on existing x and y values. | |Extrapolates future values based on existing x and y values. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]] | + | |[[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. | + | |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: PEARSON function|PEARSON]] | + | |[[Documentation/How_Tos/Calc: PEARSON function|'''PEARSON''']] |
|Returns the Pearson product moment correlation coefficient r. | |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" | |-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: STEYX function|STEYX]] | + | |[[Documentation/How_Tos/Calc: STEYX function|'''STEYX''']] |
− | |Returns the standard error of the predicted y value for each x in the regression. | + | |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)''' | |colspan="2"|'''see also (in the Array Function category)''' | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']] | |[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']] | ||
− | |returns an array of values for an exponential least squares fit to known data pairs. | + | |returns an array of values for an exponential least squares fit to |
+ | known data pairs. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']] | |[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']] | ||
− | |returns an array of statistics for a straight line that best fits a data set. | + | |returns an array of statistics for a straight line that best fits a |
+ | data set. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']] | |[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']] | ||
− | |returns an array of statistics for an exponential curve that best fits a data set. | + | |returns an array of statistics for an exponential curve that best fits a |
+ | data set. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: TREND function|'''TREND''']] | |[[Documentation/How_Tos/Calc: TREND function|'''TREND''']] | ||
− | |fits a straight line to a data set using linear regression and returns points on that line. | + | |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>''' | |colspan="2"|'''<big>Ranking</big>''' | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: LARGE function|LARGE]] | + | |[[Documentation/How_Tos/Calc: LARGE function|'''LARGE''']] |
|Returns the n<sup>th</sup> largest value in a list of numbers. | |Returns the n<sup>th</sup> largest value in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MAX function|MAX]] | + | |[[Documentation/How_Tos/Calc: MAX function|'''MAX''']] |
|Returns the maximum value in a list of arguments. | |Returns the maximum value in a list of arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MAXA function|MAXA]] | + | |[[Documentation/How_Tos/Calc: MAXA function|'''MAXA''']] |
|Returns the maximum value in a list of arguments including text. | |Returns the maximum value in a list of arguments including text. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MIN function|MIN]] | + | |[[Documentation/How_Tos/Calc: MIN function|'''MIN''']] |
|Returns the minimum value in a list of arguments. | |Returns the minimum value in a list of arguments. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: MINA function|MINA]] | + | |[[Documentation/How_Tos/Calc: MINA function|'''MINA''']] |
|Returns the minimum value in a list of arguments, including text. | |Returns the minimum value in a list of arguments, including text. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]] | + | |[[Documentation/How_Tos/Calc: PERCENTILE function|'''PERCENTILE''']] |
|Returns a specified percentile in a list of numbers. | |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 number in a list of numbers. | |Returns the percentage rank of a number in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]] | + | |[[Documentation/How_Tos/Calc: QUARTILE function|'''QUARTILE''']] |
|Returns a specified quartile in a list of numbers. | |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 list of numbers. | |Returns the rank of a number in a list of numbers. | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: SMALL function|SMALL]] | + | |[[Documentation/How_Tos/Calc: SMALL function|'''SMALL''']] |
|Returns the n<sup>th</sup> smallest value in a list of numbers. | |Returns the n<sup>th</sup> smallest value in a list of numbers. | ||
Line 269: | 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]] |