These are the cells where we will compute the inverse of a 4X4 matrix named A. This is the matrix for which we need to compute the inverse matrix. Step 1: Input a 4X4 matrix across the cells A1:E4, as shown in the screenshot below. See the output in an array of cells B1:C5.Įxample #2 – Compute Inverse of a 4X4 Matrix We can achieve matrix multiplication by using the MMULT function in Excel. The multiplication should result in an identity matrix. The way to check it is to multiply matrix A and A -1. We can also check whether the inverse we get through the MINVERSE function is correctly captured. You can see across the cells B1:C2 the matrix is inverse of the original matrix A. But in this case, you need to hit Ctrl + Shift + Enter keys so that the formula gets converted into an array formula which looks like this and works along with all the cells associated with the inverse of A. Step 4: To see the formula output every time, we must press the Enter key. Note that the array we provide as an argument to the function MINVERSE consists of the cells with values for the original matrix A. Step 3: Provide an array argument for the MINVERSE function as B1:C2 and close the parentheses to complete the formula. Selecting all the cells where your inverse will be computed is mandatory. Double click to select the MINVERSE out of those to compute the inverse of matrix A.
You will see the range of formulae associated with the keyword. Step 2: In cell B4, start typing the formula for matrix inverse =MINV. These are the ranges where the inverse of matrix A will be computed. Here I have chosen cells A1:C5 as a range for the inverse of matrix A. Step 1: Decide a range of 4 cells (since we have a 2X2 matrix) in the same Excel sheet, which will hold your inverse of matrix A. Suppose we have a 2X2 square matrix, as shown in the image below.
You can download this Inverse Matrix Excel Template here – Inverse Matrix Excel Template Example #1 – Compute Inverse of a 2X2 MatrixĪ 2X2 matrix is something that has two rows and two columns.
0 kommentar(er)
