Follow the steps below to learn how to use Newton Raphson Method in Excel.
Newton Raphson Method to solve the equation
We are going to use the Newton Method to solve the equation x^2=5
First, you need to label the column like this.
Note: Argument (x) is required for a column for function evaluations (f(x)), and a column for slope (f\’(x)).
Preparing Newton's method calculator
Fill in the value in (x).
In column B write the formula =A2^2-5 and in column C write the formula 2*A2
In column A cell A3 enter the formula =A2-B2/C2. Select cell B2, move the cursor to the bottom right, a black plus sign will appear. Drag the black plus sign to cell B7.
Repeat with cell C2.
Repeat with cell A1. That's it. You have now learned how to use the Newton Method in Excel.
Note that once the value of x no longer varies from row to row and f(x) is small (close to zero), you have the solution (assuming the process has converged).
Note: Answer is shaded in yellow.