Difference between revisions of "Documentation/How Tos/Calc: Array functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
(70 intermediate revisions by 7 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{Documentation/CalcFunc ArraysTOC | ||
+ | |ShowPrevPage={{{ShowPrevPage}}} | ||
+ | |PrevPage={{{PrevPage}}} | ||
+ | |ShowNextPage={{{ShowNextPage}}} | ||
+ | |NextPage={{{NextPage}}} | ||
+ | |ShowNextPage=block | ||
+ | |NextPage=Documentation/How_Tos/Calc: FREQUENCY function | ||
+ | |ShowPrevPart=block | ||
+ | |PrevPart= Documentation/Reference/Calc_functions | ||
+ | |ShowNextPart=block | ||
+ | |NextPart= Documentation/How_Tos/Calc: Complex Number functions | ||
+ | |ShowPrevNext=block | ||
+ | |ShowPrevPage=block | ||
+ | |PrevPage= Documentation/Reference/Calc_functions | ||
+ | |ShowNextPage=block | ||
+ | |NextPage= Documentation/How_Tos/Calc:_FREQUENCY_function | ||
+ | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
+ | }} | ||
+ | |||
+ | [[File:open.jpg]] | ||
+ | |||
==List of Calc Array functions== | ==List of Calc Array functions== | ||
Line 5: | Line 26: | ||
{| border="0" cellpadding="0" cellspacing="10" align="left" | {| border="0" cellpadding="0" cellspacing="10" align="left" | ||
|-valign="top" | |-valign="top" | ||
− | |[[Documentation/How_Tos/Calc: | + | |[[Documentation/How_Tos/Calc:_FREQUENCY_function|'''FREQUENCY''']] |
− | |returns | + | |returns an array, categorising values of a data set into given intervals. |
|-valign="top" | |-valign="top" | ||
Line 61: | Line 82: | ||
|} | |} | ||
<br style="clear:both;" /> | <br style="clear:both;" /> | ||
− | |||
− | + | {{SeeAlso|EN| | |
+ | * [[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]] | |
+ | [[Category: Documentation/Reference/Cal functions (Book)]] |
Latest revision as of 12:26, 27 February 2024
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'. See here to learn about arrays in Calc.
FREQUENCY | returns an array, categorising values of a data set into given intervals. |
GROWTH | returns an array of values for an exponential least squares fit to known data pairs. |
LINEST | returns an array of statistics for a straight line that best fits a data set. |
LOGEST | returns an array of statistics for an exponential curve that best fits a data set. |
MDETERM | returns the determinant of a matrix (array). |
MINVERSE | returns the inverse of a matrix (array). |
MMULT | multiplies two matrices (arrays). |
MUNIT | returns a unit matrix (array) of a given size. |
SUMPRODUCT | returns the sum of the products of corresponding array elements. |
SUMX2MY2 | returns the sum of the differences between corresponding squared elements of two matrices (arrays). |
SUMX2PY2 | returns the sum of the squares of all elements of two matrices (arrays). |
SUMXMY2 | returns the sum of the squared differences between corresponding elements of two matrices (arrays). |
TRANSPOSE | returns an array with its rows and columns transposed. |
TREND | fits a straight line to a data set using linear regression and returns points on that line. |
See Also