|
|
| Line 1: |
Line 1: |
| − | {{menuscript}}
| |
| − | {{Documentation/MasterTOC
| |
| − | |bookid=1234'''
| |
| − | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
| |
| − | |ShowParttitle=block
| |
| − | |parttitle=[[Documentation/How_Tos/Calc:_Array_functions|<div style="font-size: 140%;">Arrays Functions]]
| |
| − | |ShowNextPage=block
| |
| − | |NextPage=Documentation/How_Tos/Calc:_FREQUENCY_function
| |
| − | |ShowPrevPage=block
| |
| − | |PrevPage= Documentation/Reference/Calc_functions
| |
| − | |ShowPrevPart=block
| |
| − | |PrevPart= Documentation/Reference/Calc_functions
| |
| − | |ShowNextPart=block
| |
| − | |NextPart= Documentation/How_Tos/Calc:_Complex_Number_functions
| |
| − | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
| |
| | | | |
| − | * [[Documentation/How_Tos/Calc:_FREQUENCY_function|<div style="font-size: 120%;">Frequency]]
| |
| − | * [[Documentation/How_Tos/Calc:_GROWTH_function|<div style="font-size: 120%;">Growth]]
| |
| − | * [[Documentation/How_Tos/Calc:_LINEST_function|<div style="font-size: 120%;">Linest]]
| |
| − | * [[Documentation/How_Tos/Calc:_LOGEST_function|<div style="font-size: 120%;">Longest]]
| |
| − | * [[Documentation/How_Tos/Calc:_MDETERM_function|<div style="font-size: 120%;">Mdeterm]]
| |
| − | * [[Documentation/How_Tos/Calc:_MINVERSE_function|<div style="font-size: 120%;">Minverse]]
| |
| − | * [[Documentation/How_Tos/Calc:_MMULT_function|<div style="font-size: 120%;">Mmult]]
| |
| − | * [[Documentation/How_Tos/Calc:_MUNIT_function|<div style="font-size: 120%;">Munit]]
| |
| − | * [[Documentation/How_Tos/Calc:_SUMPRODUCT_function|<div style="font-size: 120%;">Sumproduct]]
| |
| − | * [[Documentation/How_Tos/Calc:_SUMX2MY2_function|<div style="font-size: 120%;">vSumx2my2]]
| |
| − | * [[Documentation/How_Tos/Calc:_SUMX2PY2_function|<div style="font-size: 120%;">Sumx2py2]]
| |
| − | * [[Documentation/How_Tos/Calc:_SUMXMY2_function|<div style="font-size: 120%;">Sumxmy2]]
| |
| − | * [[Documentation/How_Tos/Calc:_TRANSPOSE_function|<div style="font-size: 120%;">Transpose]]
| |
| − | * [[Documentation/How_Tos/Calc:_TREND_function|<div style="font-size: 120%;">Trend]]
| |
| − | }}
| |
| − | ==List of Calc Array functions==
| |
| − |
| |
| − | The Array functions operate on or return arrays, that is rectangular blocks of data. Some of these functions require the formula to be entered as an 'array formula'. [[Documentation/How_Tos/Using Arrays|See here to learn about arrays]] in Calc.
| |
| − |
| |
| − | {| border="0" cellpadding="0" cellspacing="10" align="left"
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc:_FREQUENCY_function|'''FREQUENCY''']]
| |
| − | |returns an array, categorising values of a data set into given intervals.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: GROWTH function|'''GROWTH''']]
| |
| − | |returns an array of values for an exponential least squares fit to known data pairs.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: LINEST function|'''LINEST''']]
| |
| − | |returns an array of statistics for a straight line that best fits a data set.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: LOGEST function|'''LOGEST''']]
| |
| − | |returns an array of statistics for an exponential curve that best fits a data set.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: MDETERM function|'''MDETERM''']]
| |
| − | |returns the determinant of a matrix (array).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: MINVERSE function|'''MINVERSE''']]
| |
| − | |returns the inverse of a matrix (array).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: MMULT function|'''MMULT''']]
| |
| − | |multiplies two matrices (arrays).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: MUNIT function|'''MUNIT''']]
| |
| − | |returns a unit matrix (array) of a given size.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: SUMPRODUCT function|'''SUMPRODUCT''']]
| |
| − | |returns the sum of the products of corresponding array elements.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: SUMX2MY2 function|'''SUMX2MY2''']]
| |
| − | |returns the sum of the differences between corresponding squared elements of two matrices (arrays).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: SUMX2PY2 function|'''SUMX2PY2''']]
| |
| − | |returns the sum of the squares of all elements of two matrices (arrays).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: SUMXMY2 function|'''SUMXMY2''']]
| |
| − | |returns the sum of the squared differences between corresponding elements of two matrices (arrays).
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: TRANSPOSE function|'''TRANSPOSE''']]
| |
| − | |returns an array with its rows and columns transposed.
| |
| − |
| |
| − | |-valign="top"
| |
| − | |[[Documentation/How_Tos/Calc: TREND function|'''TREND''']]
| |
| − | |fits a straight line to a data set using linear regression and returns points on that line.
| |
| − | |}
| |
| − | <br style="clear:both;" />
| |
| − |
| |
| − | {{Documentation/SeeAlso|
| |
| − | * [[Documentation/How_Tos/Using Arrays|How To Use Arrays in Calc]]
| |
| − |
| |
| − | * [[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]]
| |
