1 / 16

Solving Systems of Linear Equations

Solving Systems of Linear Equations. Enter the Coefficients and Constants from the Equations. In an empty cell, type =minverse( data range ), Enter. Select a range that is the same size as the coefficient matrix. Press F2, then Ctrl+Shift+Enter.

Download Presentation

Solving Systems of Linear Equations

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Solving Systems of Linear Equations

  2. Enter the Coefficients and Constants from the Equations

  3. In an empty cell, type =minverse(data range), Enter

  4. Select a range that is the same size as the coefficient matrix

  5. Press F2, then Ctrl+Shift+Enter

  6. In a blank cell, type =mmult(range1,range2), Enter

  7. Select a range containing the first cell that contains the same number of cells as unknowns

  8. Press F2, Ctrl+Shift+Enter

  9. Benefits of Matrix Method • Coefficients and Constants can be changed and the solutions are immediately calculated • Applies easily to large systems of equations. • Shortfalls: • Cannot be used for non-linear equations

  10. Benefits of Solver Method • Can be used for all non-linear equations • Shortfalls: • Tedious for large systems of equations. • Initial guesses must be given, and solution may not converge if the guesses are not close to the actual solution. • Any change in the problem requires that Solver be rerun again.

  11. Temperature Distribution in a Square Plate 100 oC 50 oC 75 oC 25 oC

  12. j i Solution

  13. 100 oC T11 T12 T13 T21 T22 T23 50 oC 75 oC T31 T33 T32 25 oC

More Related