20x₁ + 15x₂ + 10x3 = 45 -3x₁ -2.249x₂ + 7x3 = 1.751 5x₁ + x2 3x3 = 9 -
Algebra: Structure And Method, Book 1
(REV)00th Edition
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Chapter2: Working With Real Numbers
Section: Chapter Questions
Problem 30CLR
Related questions
Question
100%
Solve the following Systems of Linear Equations using Gaussian Elimination through Excel. (can you give me a solution like the given below thank you so much)
Transcribed Image Text:2.
20x₁ + 15x₂ + 10x3 = 45
-3x₁ -2.249x₂ + 7x3 = 1.751
5x₁ + x₂ 3x3 = 9
Transcribed Image Text:0
1
D
E
G
f(x(n))
f(x(n))
Ea
1.5
=-C7 C7+EXP(2*C7/3)-1
=-2*C7+(2*EXP(2*C7/3))/3 =C7-D7/E7
=ABS(F7-C7) "100
=F7
=F8
=F9
=-C8 C8+EXP(2*C8/3)-1 =-2*C8+(2*EXP(2*C8/3))/3 =C8-D8/E8
=-C9*C9+EXP(2°C9/3)-1 =-2°C9+(2*EXP(2°C9/3))/3 =C9-D9/E9
--C10 C10+EXP(2 C10/3)-1 -2 C10+(2*EXP(2 C10/3))/C10-D10/E10
|--C11 C11+EXP(2*C11/3)-1 =2*C11+(2*EXP(2*C11/3))/ -C11-D11/E11
=ABS(F8-C8)*100
=ABS(F9-C9)*100
=ABS(F10-C10)*100
= ABS(F11-C11)*100
=F10
The output can be presented as follows.
B
с
D
E
G
12
x(n) f(x(n)) f(x(n))
Ea
f(x(n)) x(n+1)
0
1.500000000-0.531718172 -1.187812114 1.052354985 44.764501482
1
1.052354985 -0.090534252 -0.760098795 0.933246452 11.910853291
2 0.933246452 -0.007993261 -0.624522451 0.920447455 1.279899721
0.920447455 -0.000096189 -0.609476691 0.920289632 0.015782275
0.920289632 -0.000000015 -0.609290603 0.920289608 0.000002410
3
4
Hence, the root of the equation is ≈ ≈ 0.920289608
AWNH
2
3
fix
4
n
B
n
с
x(n)
x(n+1)
FL
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill