Page 131 - Excel for Scientists and Engineers: Numerical Methods
P. 131
108 EXCEL: NUMERICAL METHODS
Figure 6-8. First derivative calculated using LI NEST function.
They values indicate the known experimental points.
(folder 'Chapter 06 Examples', workbook 'Derivs Using LINEST', sheet 'Using named formulas')
0.61 0.01 0
0.60
0.005
-c
X
0.59 $$
C %=
0 >m
0.58 0.000 *$ $
3 !?a
LL q
2-
0.57
Q)
-0.005 v,
0.56
-0.010
390 395 400 405 410 415
x
Figure 6-9. Chart of values of first and second derivative
calculated using LINEST.
(folder 'Chapter 06 Examples', workbook 'Derivs Using LWEST', sheet 'Using named formulas')
