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:
fx sinx
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 etc.
Use the NewtonRaphson Method to find the first positive, nonzero root of the function. The analytical result is x
The first derivative of the function is fx cosx
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, x what is the result of the approximation after two complete iterations? I.e what is the value of x which is at the end of the row for i 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
