Question: Use Excel VBA. Please answer as simply as possible! Thanks! 4) Hand calculation problem. Rearrange the equations to make them diagonally dominant. Hand solve using


Use Excel VBA. Please answer as simply as possible! Thanks!
4) Hand calculation problem. Rearrange the equations to make them diagonally dominant. Hand solve using the Gauss-Siedel iterative method and an initial guess as zero. This time, perform 3 iterations. Use the above hand calculation format. How do your results compare with Problem 3? 5) Develop a VBA program to implement the Gauss-Siedel method given the number of equations, desired number of iterations, A matrix, and B matrix as spreadsheet inputs. Use the program to confirm your solution to Problem 4. A 1 Gauss-Seidel Solver 2 9 10 11 12 X Matrix (unknown values) 13 14 Iteration 1: 15 Iteration 2: 16 Iteration 3: B X1 3 3 C 3 Number of Equations: 4 Maximum Number of Iterations: 5 6 7 Enter the A and B matrices on the spreadsheet, starting on Row 8; enter the B vector after a blank column. 8 X2 D X3 E F G H
Step by Step Solution
3.28 Rating (148 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
