MIT OpenCourseWare Close Window
 
» Required Reading » Table of Contents » Chapter 3: Vectors, Dot Products, Matrix Multiplication and Distance

12.3 Spreadsheet Implementation of this Procedure

Previous Section Next Chapter

How can you do such things?
First put x and j in fixed locations X and Y.
Then set up the following columns on the spreadsheet:
f(xj):
In the first column enter the successive values of f(xj) starting with the first, known value. For roots you can start with x0  = f(x0) = 1. Compute later values f(xj) by using the linear approximation tangent line at xj-1 evaluated at argument x
xj:
In the second column apply the inverse function to f to the value in the previous column.
Once you have entered your instructions for f(x1) and x1, you can copy these down a hundred rows, and you are done.

How do I use  the linear approximation as required above?
Here is what to do for roots: the linear approximation will read:

f(x1) =  f(x) = f(x0) + (x - x0)f '(x0).

 For jth root,  f '(x0) = f(x0) / x0 / j so that this formula reduces to:

f(x1) = f(x) = f(x0)(1- (1/j) + (x / j / x0)).