Calc Guide

Syntax Description
MDETERM(array) Returns the array determinant of an array. This
function returns a value in the current cell; it is
not necessary to define a range for the results.
Array is a square array in which the determinants
are defined.
MINVERSE(array)
Returns the inverse array. Array is a square array
that is to be inverted.
MMULT(array; array) Calculates the array product of two arrays. The
number of columns for array 1 must match the
number of rows for array 2. The square array has
an equal number of rows and columns. Array at
first place is the first array used in the array
product. Array at second place is the second array
with the same number of rows.
MUNIT(dimensions) Returns the unitary square array of a certain size.
The unitary array is a square array where the
main diagonal elements equal 1 and all other
array elements are equal to 0. Dimensions refers
to the size of the array unit.
SUMPRODUCT(array
1; array 2; ...array 30)
Multiplies corresponding elements in the given
arrays, and returns the sum of those products.
Array 1; array 2;...array 30 are arrays whose
corresponding elements are to be multiplied. At
least one array must be part of the argument list.
If only one array is given, all array elements are
summed.
SUMX2MY2(array_X;
array_Y)
Returns the sum of the difference of squares of
corresponding values in two arrays. Array_X is the
first array whose elements are to be squared and
added. Array_Y is the second array whose
elements are to be squared and subtracted.
SUMX2PY2(array_X;
array_Y)
Returns the sum of the sum of squares of
corresponding values in two arrays. Array_X is the
first array whose arguments are to be squared and
added. Array_Y is the second array, whose
elements are to be added and squared.
SUMXMY2(array_X;
array_Y)
Adds the squares of the variance between
corresponding values in two arrays. Array_X is the
first array whose elements are to be subtracted
and squared. Array_Y is the second array, whose
elements are to be subtracted and squared.
Appendix B Description of Functions 469