Create Presentation
Download Presentation

Download Presentation
## Solving Systems of Linear Equations

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -

**Select a range that is the same size as the coefficient**matrix**Select a range containing the first cell that contains the**same number of cells as unknowns**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**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.**Temperature Distribution in a Square Plate**100 oC 50 oC 75 oC 25 oC**j**i Solution**100 oC**T11 T12 T13 T21 T22 T23 50 oC 75 oC T31 T33 T32 25 oC