Newton Raphson Method in Excel

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.

first Newton's method

 

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

second Newton's method

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.

third Newton's method

Repeat with cell C2.

fourth Newton's method

Repeat with cell A1. That's it. You have now learned how to use the Newton Method in Excel.

fifth Newton's method

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).

sixth Newton's method

Note: Answer is shaded in yellow.