Question: Use Microsoft Excel to investigate the following function: f ( x ) = sin ( x ) Note that Excel considers the argument of this

Use Microsoft Excel to investigate the following function:
f(x)= sin(x)
Note that Excel considers the argument of this function to be in radians, not degrees. I.e., the function will cross the horizontal axis when x = ,2,3, etc.
Use the Newton-Raphson Method to find the first positive, non-zero root of the function. The analytical result is x = .
The first derivative of the function is f'(x)= cos(x)
Do not incorporate the first order numerical method for computing the derivative that was demonstrated in the second half of the notes for this topic.
Using an initial guess, x0=2, what is the result of the approximation after two complete iterations? I.e., what is the value of x3, which is at the end of the row for i =2(if your table is set up like the one in the notes)?
Include at least three digits after the decimal in your answer.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Civil Engineering Questions!