1. Using excel program, create an algorithm that will solve the root of the function using Bisection Method -X Function: f(x) = e (3.2 sin(x) - 0.5 cos(x)) Stopping Criteria a. If(Xm)| < 0.00001 b. Ea <0.00000001 C. number of iteration = 20 2. Fill up the table below Xu Iter # XL F(XL) F(Xu) F(Xm) |Eal% |(XL + Xu)/2 1 1 Questions to answer: 1. If you round-off the error measurement at the 15th iteration, how many digits will be correct in the root extracted? Explain your answer. LO

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter5: Inverse, Exponential, And Logarithmic Functions
Section5.6: Exponential And Logarithmic Equations
Problem 64E
icon
Related questions
Question

Please answer the highlighted part only.

1. Using excel program, create an algorithm that will solve the root of the function using Bisection
Method
-X
Function: f(x) = e (3.2 sin(x) - 0.5 cos(x))
Stopping Criteria
а.
|f(Xm)| < 0.00001
b.
Ea <0.00000001
C.
number of iteration = 20
2. Fill up the table below
Iter #
XL
Xu
F(XL)
F(Xu)
F(Xm)
|Eal%
|(XL + Xu)/2
1
1
2
Questions to answer:
1. If you round-off the error measurement at the 15th iteration, how many digits will be correct in the
root extracted? Explain your answer."
Transcribed Image Text:1. Using excel program, create an algorithm that will solve the root of the function using Bisection Method -X Function: f(x) = e (3.2 sin(x) - 0.5 cos(x)) Stopping Criteria а. |f(Xm)| < 0.00001 b. Ea <0.00000001 C. number of iteration = 20 2. Fill up the table below Iter # XL Xu F(XL) F(Xu) F(Xm) |Eal% |(XL + Xu)/2 1 1 2 Questions to answer: 1. If you round-off the error measurement at the 15th iteration, how many digits will be correct in the root extracted? Explain your answer."
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning