First note the empty range where we transpose the matrix. Highlight an area blank cells of corresponding size in which the resulting matrix should be placed. MINVERSE Invert a matrix MMULT Multiply two matrices together MDTERM Calculate the determinant of a specified array When solving simultaneous equations we can use these functions to solve for the unknown values.
The syntax for the function is.
In mathematical terms the phenomena of multiplying two matrices with each other is called matrix multiplication. All of this makes it worth- while to become familiar with matrix techniques for portfolio calculations. The matrix must have an equal number of rows and columns in order to be invertible. Addition of matrices and scalar multiplication are handled by conventional cell arithmetic copying cell formulas whereas advanced matrix operations such as transposition multiplication and inversion are handled by matrix array functions.