Documentation/How Tos/Calc: Array functions
From Apache OpenOffice Wiki
< Documentation | How Tos
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
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. |