a) Bisection Method Using Excel spreadsheet, determine the real root of the given equation f(x) = -2° -1.5 x + 10x +2 using bisection to locate the root. Employ initial guesses of x = 0 and xu - 1 and iterate until the estimated error Ea falls below a level of E, 10%.

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter1: Fundamental Concepts Of Algebra
Section1.1: Real Numbers
Problem 25E
icon
Related questions
Question
a) Bisection Method
Using Excel spreadsheet, determine the real root of the
given equation f(x) = -26 -1.5 ¹ +10 +2
using bisection to locate the root. Employ initial guesses
of x = 0 and x₁ = 1 and iterate until the estimated error
Ea falls below a level of E= 10%.
Iteration
1
2
3
4
5
a or x₁
b or Xr
c or Xu
Transcribed Image Text:a) Bisection Method Using Excel spreadsheet, determine the real root of the given equation f(x) = -26 -1.5 ¹ +10 +2 using bisection to locate the root. Employ initial guesses of x = 0 and x₁ = 1 and iterate until the estimated error Ea falls below a level of E= 10%. Iteration 1 2 3 4 5 a or x₁ b or Xr c or Xu
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Algebra: Structure And Method, Book 1
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