Page 171 - Excel for Scientists and Engineers: Numerical Methods
P. 171
148 EXCEL: NUMERICAL METHODS
But the number of roots of other functions, such as
y = -1.04 In x - 1.26 cos x + 0.0307 ex (8-2)
may not be obvious. A chart of the function is useful to show the number and
approximate value of the roots of the function. The chart in Figure 8-2 shows
that the function shown in equation 8-2 has two real roots.
3
2
>I
0
c
-1
X
Figure 8-2. A function with two real roots.
Figure 8-3. Portion of data table of x and y values
showing the pair of values that bracket a root of the function shown in Figure 8-2.
(folder 'Chapter 08 Examples', workbook 'Roots of Equations', worksheet 'Graphical Method')
