Page 238 - Excel for Scientists and Engineers: Numerical Methods

CHAPTER 9 SYSTEMS OF SIMULTANEOUS EOUATIONS 215

5. The following sets of simultaneous equations may or may not be solvable by
the Gaussian Elimination method. For each case, explain why. If solvable,
solve.

(a) x + y + 32 = 5
2x+2y+22= 14
3x+3y+9z= 15

2x-y+z=O

x + 3y + 22 = 0
3x + 2y+ 3z= 0

6. Solve the following system of six simultaneous equations:

2.97 0.75 1.23 2.08 1.26 0 7.93
2.34 2.38 1.23 1.23 1.94 2.07 9.79
1.23 0.52 0 3.66 0.18 0.51 26.19
1.84 1.89 2.64 2.65 0.51 0.38 5.10
1.48 0.40 2.88 1.46 0 2.65 8.43
- 2.94 1.55 1.71 1.06 2.46 2.97 - 15.74

7. Solve the following system of nonlinear equations:
x2 +y2 = 1
x2 -y2 = 0