Worked ExampleNumerical MethodsIntermediateSpreadsheet Workspace

Approximate a root with Newton's method and compare successive iterates

Newton's method is easier to trust when you can see the iteration table row by row. A spreadsheet makes the recurrence concrete instead of hiding it inside a single answer.

Primary Tool

Spreadsheet Workspace

Open spreadsheet

Spreadsheet is the right fit because Newton's method is inherently iterative. The row structure makes each update visible and editable.

Problem

Approximate a root of starting from using Newton's method.

This is a good worked example because it blends exact formulas, derivative information, and numerical iteration.

Why the table helps

Newton's update is . Writing that as spreadsheet formulas makes it easy to see whether the iterates stabilize, overshoot, or break down.

In this example the approximations quickly settle near the real root because the starting guess is already in a region where the tangent-line correction behaves well.

Step-by-step walkthrough

The spreadsheet exposes the recurrence row by row so that every new approximation can be checked against the previous one.

  1. 1Write the function and its derivative .
  2. 2Choose the starting guess .
  3. 3Compute and in the first row.
  4. 4Apply Newton's update to get the next approximation.
  5. 5Repeat the same formulas down the table so each row uses the previous row's approximation.
  6. 6Watch the values settle toward the root and compare how quickly the corrections shrink.

Common Pitfall

Newton's method is not just a button press. The iteration table shows whether the approximations are actually converging and whether a small derivative is making the update unstable.

Try a Variation

Change the starting guess to or . How does the iteration behave, and which start looks more stable?

Related Pages

Keep moving through the cluster

Back to Learn Math →