Difference between revisions of "Documentation/How Tos/Calc: Statistical functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
m |
||
(16 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 36: | Line 55: | ||
|-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 90: | Line 110: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CHIDIST function|'''CHIDIST''']] | |[[Documentation/How_Tos/Calc: CHIDIST function|'''CHIDIST''']] | ||
− | |Calculates values for a χ<sup>2</sup>-distribution. | + | |Calculates right-tail values for a cumulative χ<sup>2</sup>-distribution. |
+ | |-valign="top" | ||
+ | |[[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: CHIINV function|'''CHIINV''']] | |[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']] | ||
− | |Calculates the inverse of the CHIDIST function. | + | |Calculates the inverse of the CHIDIST function. |
+ | |-valign="top" | ||
+ | |[[Documentation/How_Tos/Calc: CHISQINV function|'''CHISQINV''']] | ||
+ | |Calculates the inverse of the CHISQDIST function. | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: CHITEST function|'''CHITEST''']] | |[[Documentation/How_Tos/Calc: CHITEST function|'''CHITEST''']] | ||
Line 102: | Line 129: | ||
|-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 121: | Line 149: | ||
|[[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" | ||
+ | |[[Documentation/How_Tos/Calc: GAMMA function|'''GAMMA''']] | ||
+ | |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 162: | Line 194: | ||
|-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 204: | Line 237: | ||
|-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 210: | Line 244: | ||
|-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 216: | Line 251: | ||
|-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" | ||
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]] |