This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Chapter 32 problem The system of equations is 13x - 8y -3z = 20 -8x + 10y - z = -5 -3x - y + 11z = 0 Marker x y z 7 7 5.34 2.39 If the recursion doesn't work, you may need Tools|Options|Calculation Iteration. #MACRO? #MACRO? #MACRO? Checking the solution Equation 1 41.1 Equation 2 -5 Equation 3 0 Note that by pressing F9 eventually the solution will converge to the c x=3, y = 2, z = 1. Page 1 Chapter 32 problem sion doesn't work, you may need to reset ions|Calculation. Check the box marked y pressing F9, you recalculate the spreadsheet; the solution will converge to the correct solution: Page 2 ...
View Full Document
This note was uploaded on 01/23/2011 for the course FGB 780 taught by Professor Edwardchang during the Spring '09 term at Missouri State University-Springfield.
- Spring '09