The
MINVERSE() function calculates
the inverse of the "matrix" stored
in the array.
- The syntax for the function
is MINVERSE(array_1).
The
argument "array_1"
can be an array of numerical values, references
to a range of cells or a named range of
which you want to find the inverse. If
the number
of columns "array_1"is
different from the number of rows in "array_2" or
the number of elements in the resulting
array
is greater than 5,461 cells a #VALUE error
will be returned.
The
MINVERSE function calculates the inverse
of a array. The resulting array has the
property that when multiplied the original
array it will become a unit matrix. For
example: MINVERSE({1,2,5:2,3,14:6,8,8})
= {-2.3,0.63,0.34:1.79,-0.6,-0.1:-0.1,0.11,0}.
If we were to multiply
the two arrays ie. MMULT( {1,2,5:2,3,14:6,8,8},{-2.3,0.63,0.34:1.79,-0.6,-0.1:-0.1,0.11,0}
the result should be (approximately) equal
to {1,0,0:0,1,0:0,0,1} a 3x3 unit matrix.
To learn more about inverse matrices
or "arrays" in
mathematics see: [The Inverse Matrices
Mathematics Knowledgebase].
[The
MMULT() function knowledgebase]
[The MDETERM() function knowledgebase]
[The TRANSPOSE() function knowledgebase]
|
