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...
-
How is it possible for a company with positive retained earnings to be unable to pay a cash dividend?
-
Using your statistical software package: a. Simulate 50 observations from a binomial distribution for which n 5 5 and 5 0.2. b. Generate a frequency distribution for these observations. Is the...
-
From the following trial balance of F Chaplin drawn up on conclusion of his first year in business, draw up a trading and profit and loss account for the year ended 31 December 19X8. A balance sheet...
-
Comprehensive Three-Part Revenue Recognition Van Hatten Industries has three operating divisionsDepp Construction Division, Dement Publishing Division, and Ankiel Securities Division. Each division...
-
When a company is deciding if a project is profitable, do they only compare the rate of return to the WACC? Are there other ways to decide if they should attempt a project? Even if the rate or return...
-
Ayayai Hotels Ltd. (AHL) is a small boutique hotel that provides 44 suites that can be rented by the day, week, or month. Food service is available through room service as well. In addition, there...
-
The following transactions and adjusting entries were completedby Gravure Graphics International, a paper-packaging company. Thecompany uses straight-line depreciation for trucks and othervehicles, 2...
-
You need to design a capacitor capable of storing 2.0 107 C of charge. At your disposal, you have a 100 V power supply and two metal plates, each of area 0.425 m. What is the limit of the separation...
-
Can help me to find the DOI for this arcticle: Robinson, D. (2020). Marketing myopia at its finest: Convincing America that marketing myopia has benefits. Journal of Marketing, 5(3), 46-67. and This...
-
Simplify. 2 Z 8x Write your answer without parentheses. X
-
column column L=5m Vd a) Perform shear design of the beam by considering the concrete contribution. b) Draw the reinforcement scheme for the beam for transverse sections. Pd = 45 kNm h = 550 mm b=600...
-
If a disk is rotating about its center with an angular speed of per second, what statement(s) below is (are) true? Select all that apply. Each point on the disk has the same tangential acceleration....
-
Identify the programs the social worker in the case study engaged with. Identify the policies that drove the programs and indicate which were federal and which were state or local. Explain how these...
-
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.
-
Fox Corporation purchased a machine on January 1,2020 , that cost \(\$ 40,000\). The machine had an estimated service life of five years and no residual value. Fox uses straight-line depreciation for...
-
Wittco Company reports pretax GAAP income in 2020, its first year of operations, of \(\$ 100,000\). Temporary differences in the GAAP basis and tax basis of assets arose in 2020 from the following...
-
On January 1 of each of the first four years of its existence, Allway Company purchases a new unit of equipment. Each unit has a four-year life and zero salvage value, costs \(\$ 100,000\), and is...
Study smarter with the SolutionInn App