Difference between revisions of "Documentation/How Tos/Calc: Array functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
| Line 98: | Line 98: | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]] | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]] | ||
}} | }} | ||
| + | [[File:open.jpg]] | ||
[[Category: Documentation/Reference/Calc]] | [[Category: Documentation/Reference/Calc]] | ||
[[Category: Documentation/Reference/Cal functions (Book)]] | [[Category: Documentation/Reference/Cal functions (Book)]] | ||
Revision as of 20:41, 29 June 2013
- Arrays Functions
- FrequencyGrowthLinestLongestMdetermMinverseMmultMunitSumproductvSumx2my2Sumx2py2
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.
Template:Documentation/SeeAlso
-
