Matrix Operations
This menu allows to do the following matrix manipulation routines:
· Transpose of a matrix,
· Matrix multiplication,
· Finding the inverse of a matrix,
· Matrix determinant calculation.
How To
Transpose matrix, find the inverse of a matrix or calculate matrix determinant:
Run a corresponding command from the Data→[Matrix Operations] menu.
Select a range with matrix.
Multiply two matrices:
Run: Data→[Matrix Operations] Matrix multiplication command.
Select two ranges.
Note
Please check if the "Labels in first row" option has the correct value. If a range with matrix has no labels - turn this option off.