Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
Line 83: | Line 83: | ||
* [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]] | * [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]] | ||
* [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%;">Rsq]] | * [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%;">Rsq]] | ||
− | * [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc:_SLOPE_function|<div style="font-size: 120%;">Slope]] |
* [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]] | * [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]] | ||
− | <div style="font-size: | + | <div style="font-size: 100%;">''See also (in the [[Documentation/How_Tos/Calc:_Array_functions|Array Function]] category); GROWTH, LINEST, LOGEST, TREND''</div> |
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Ranking</div> | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Ranking</div> | ||
Line 138: | Line 138: | ||
|-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" | ||
Line 195: | Line 196: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']] | |[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']] | ||
− | |Calculates left-tail values for a cumulative χ<sup>2</sup>-distribution or values for the density function. | + | |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: CHIINV function|'''CHIINV''']] | |[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']] | ||
Line 210: | Line 212: | ||
|-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 greater than or equal to a criterion value. | + | |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''']] | ||
Line 231: | Line 234: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: GAMMA function|'''GAMMA''']] | |[[Documentation/How_Tos/Calc: GAMMA function|'''GAMMA''']] | ||
− | |Calculates the GAMMA function; not a statical function, but actually in this category. | + | |Calculates the GAMMA function; not a statical function, but actually |
+ | in this category. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMAINV''']] | |[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMAINV''']] | ||
Line 273: | Line 277: | ||
|-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''']] | ||
Line 315: | Line 320: | ||
|-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''']] | ||
Line 321: | Line 327: | ||
|-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''']] | ||
Line 327: | Line 334: | ||
|-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" |