Use Excel VBA. Please answer as simply as possible! Thanks! 4) Hand calculation problem. Rearrange the equations
Fantastic news! We've Found the answer you've been seeking!
Question:
Use Excel VBA. Please answer as simply as possible! Thanks!
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Numerical Methods For Engineers
ISBN: 9780071244299
5th Edition
Authors: Steven C. Chapra, Raymond P. Canale
Posted Date:
Students also viewed these electrical engineering questions
-
Use Excel to create all possible Marks models, and then consider those that have two explanatory variables. Note that there are 10 such models. Which of these models is best, and why? Is this model a...
-
Use Excel to answer MC- 1. Round to the nearest dollar.
-
Use Excel to answer MC- 2. Round to the nearest dollar.
-
Earned-value analysis. A project budget calls for the following expenditures: Task Date Budgeted Amount Build forms April 1 $10,000 Pour foundation April 1 $50,000 May 1 $100,000 Frame walls May 1...
-
Palmer Companys first weekly pay period of the year ends on January 8. On that date, the column totals in Palmers payroll register indicate its sales employees earned $69,490, its office employees...
-
Choose the best answer. 1. Which of the following entities would consider portions of the AICPA Audit and Accounting Guide: Health Care Entities category b authoritative guidance? a. A business-type...
-
Donna Adams started an interior design company called Interiors by Donna, Inc., on September 1, 2010. The following amounts summarize the financial position of her business on September 14, 2010,...
-
The following data relate to the operations of Slick Software, Inc., during 2018. Continuing operations: Net...
-
It is being considered to invest in a project that is intended to be financed with 75% debt. The loan runs over the project's life of three years and has an interest rate before tax of 8% per year....
-
Suppose availability and purchase costs for V8 short blocks at Juarez and New Orleans are the same as in problem #2 (without tariffs). However, suppose that HP does not pay shipping from Juarez or...
-
Draw the major organic product of the following reaction, and select the mechanism which would dominate (SN 1 , SN 2 , E 1 , or E 2 ). Draw all four bonds at chiral centers. Select the mechanism...
-
.. Consider the following information about Truly Good Coffee, Inc.: . Use the information in the table to find the following: a. The company's book value. b. Its book value per share. c. The stock's...
-
Which model results below best depicts the Principle of Parsimony in forecasting? A. thirty factors explain 90% of the variation in demand B. three factors explain 80% of the variation in demand C....
-
2. The graph in Figure below shows a particle's velocity moving along a coordinate line. At t = 0, the position is x = 0. v(t), 5 0 m sec -5 10 20 30 40 50 60 t,sec (a) Sketch the acceleration a vs....
-
Complete the Java method convertBinaryStrToDecimal(String s) to convert an input of binary string s to the equivalent decimal number using "for loop". For example, after you call the method convert...
-
es Troy Engines, Limited, manufactures a variety of engines for use in heavy equipment. The company has always produced all of the parts for its engines, including the carburetors. An outside...
-
Expected return and beta as a Measure of Risk Available on Nov 16, 2022 12:01 AM. Access restricted before availability starts. Available until Nov 22, 2022 11:59 PM. Submission restricted after...
-
The words without recourse on an indorsement means the indorser is: a. not liable for any problems associated with the instrument. b. not liable if the instrument is dishonored. c. liable personally...
-
There is no closed form solution for the error function, Use the two-points Gauss quadrature approach to estimate erf(1.5). Note that the exact value is0.966105. %3D erf(a):
-
Use MATLAB to integrate the following pair of ODEs from t = 0 to 100: dy1/dt = 0.35y1 1.6y1y2dy2/dt = 0.04 y1y2 0.15y2 Where y1= 1 and y2 = 0.05 at t = 0. Develop a state- space, plot (y1 versus...
-
Develop a user-friendly program for the Heun method with iterative corrector. Test the program by duplicating the results in Table 25.2.
-
Audits can be categorized into five types: (1) financial statement audits, (2) audits of internal control, (3) compliance audits, (4) operational audits, and (5) forensic audits.
-
Cendant Corporation (Cendant). On December 17, 1997, CUC International merged with HFS Incorporated to form Cendant. Cendant operates primarily in three business segmentsalliance marketing, travel,...
-
Sandy Pitts is auditing Hofmeister Hardware Company, a fast-growing retail hardware chain in the Atlanta area. While Pitts has previously worked on this engagement, this is her first year as the...
Study smarter with the SolutionInn App