Solving Simultaneous Equations by Matrix Inverse. Problem 2.5 # 37 Presented by E. G. Gascon. The Problem. How to solve. To solve a system of equations AX = B, where A is the matrix of coefficients. B is the matrix of constants. Need to find A -1 the inverse of A.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Problem 2.5 # 37
Presented by E. G. Gascon
To solve a system of equations AX = B, where A is the matrix of coefficients.
B is the matrix of constants.
Need to find A-1 the inverse of A
So… solving for X = A -1 B
Start by setting up the matrix with the identity in the last three columns
After performing Gauss-Jordan, the resulting matrix is
See next slide for Gauss- Jordan Work
Step 1: Enter the 3X3 coefficient matrix in an Excel Spread Sheet.
Step 2: Select a 3X3 matrix of empty cells and type
=MINVERSE( matrix is step 1)
Ctrl + Shift + ENTER
Use matrix multiplication or
MMULT function in Excel.
Ans: (15, -5, -1)