Page 175 - Excel for Scientists and Engineers: Numerical Methods
P. 175
152 EXCEL: NUMERICAL METHODS
=C3-D3*(C3-A3)/( D3-B3)
and cell C4 contains the same formula as used in the previous example to select
they value that has the opposite sign to the value in the previous row:
Figure 8-7. Using the Regula Falsi method to find a real root of a function.
(folder 'Chapter 08 Examples', workbook 'Roots of Equations', worksheet 'Regula Falsi Method')
In general this method converges more efficiently to the root than does the
binary search method, although unfavorable situations can occur, as illustrated in
Figure 8-8. In this example, one end of the interval is ''stuck," and even after 19
cycles of iteration, convergence has only reached the 1E-03 level.
