Problem 4a: Gauss-Seidel/Jacobi (10 pts)
Develop a spreadsheet to solve the following system of equations using Gauss-Seidel or Jacobi with relaxation. Clearly indicate which method you used. Use l = 0.8 and es = 0.001%. If necessary, make sure to rearrange the equations to achieve convergence.
ENGR 351 Numerical Methods for Engineers
College of Engineering
Southern Illinois University Carbondale
HOMEWORK SET 2: Matrix Methods
(Total: 40 pts.) (Total: 50 pts.)
Due: Feb. 21, 2003 Feb.
24, 2003
Problem 1: Gauss Elimination (10 pts)
You must do this problem by hand on engineering paper.
Three carts, interconnected by springs, are subjected to the loads P1, P2 and P3, as shown in the figure. The displacements of the carts are governed by the equilibrium equations
P1 - k1u1 + k5(u3 - u1) + k4(u2 - u1) = 0
P2 - k2u2 - k4(u2 - u1) + k6(u3 - u2) = 0
P3 - k7u3 - k8u3 - k3u3 - k6(u3 - u2) - k5(u3 -u1) = 0
Find the displacement of the carts for the following data using Gauss Elimination.
k1 = 5000 N/m, k2 = 1500 N/m, k3 = 2000 N/m, k4 = 1000 N/m, k5= 2500 N/m, k6 = 500 N/m, k7 = 3000 N/m, k8 = 3500 N/m, P1 = 1000 N, P2 = 2000 N, P3 = 3000 N

Problem 2: LUD Method (10 pts)
Using the results of the previous problem, perform the LUD method, clearly indicating [L] and [U]. This must also be done by hand.
Problem 3: Use of Inverse Matrix (10 pts)
![]()
- Use Excel to calculate the inverse of [A]
- Using Excel, multiply [A][A-1]. Indicate whether this is the identity matrix [I]
- Using Excel, determine {x} for {c}T = { 100 -200 40} and {c}T = { -100 200 -40}
Submit a hardcopy of your work.
Problem 4a: Gauss-Seidel/Jacobi (10 pts)
Develop a spreadsheet to solve the following system of equations using Gauss-Seidel or Jacobi with relaxation. Clearly indicate which method you used. Use l = 0.8 and es = 0.001%. If necessary, make sure to rearrange the equations to achieve convergence.
-5x1 + 5x3 = 12
4x1-x2 - x3 = -2
6x1 -3x2 = -17
Problem 4b: Gauss-Seidel/Jacobi (10 pts)
Develop a spreadsheet to solve the following system of equations using Gauss-Seidel or Jacobi with relaxation. Clearly indicate which method you used. Use l = 0.8 and es = 0.001%. If necessary, make sure to rearrange the equations to achieve convergence.
x1 + 7x2 -4x3 = -51
4x1-4x2 + 9x3 = 6212x1 -x2 +3x3 = 8
Submit both a hardcopy and an electronic copy of your work.