Matrix Calculations are complex when it is solved manually. Let us see how to use MS Excel ® to solve complex matrix calculations.
EXAMPLE 1: ADDITION AND SUBTRACTION OF MATRICES
EXAMPLE 2: MULTIPLICATION OF MATRICES
It is to be noted that the order of the matrix is denoted by “m × n”, where m = number of rows in the matrix and n = number of columns in the matrix.
For any two matrix to be multiplied and if the order of Matrix 1 is “m1 × n1” and the order of Matrix 2 is “m2 × n2” then n1 = m2, resulting in the final order of the matrix as “m1 × n2”.
In the below example, Matrix A is of the order 3 × 2 and Matrix B is of the order 2 × 1. The resulting matrix will be of the order 3 × 1. We will see how to multiply the matrix.
EXAMPLE 3: DETERMINANT OF A MATRIX
The Determinant of a Matrix can only be found out for a Square Matrix (Matrix with equal number of columns and rows).
EXAMPLE 4: INVERSE OF A MATRIX
The Inverse of a Matrix can only be found out for a Square Matrix (Matrix with equal number of columns and rows).
EXAMPLE 5: TRANSPOSE OF A MATRIX
Transpose of a Matrix is nothing but changing the order of the matrix (Rows becomes Columns and viceversa).