Page 436 - Excel for Scientists and Engineers: Numerical Methods
P. 436
APPENDIX 4 EQUATIONS FOR CURVE FITTING 413
I -
-
I I I I I I
2 4 6 8 10
-1 L
X
Figure A4-6. Double exponential decay.
The curve follows equation A4-5 with a = 1, b = 4.2, c = -2 and d = -2,
0 2 4 6 8 10
-0.8 X
Figure A4-7. Double exponential decay.
The curve follows equation A4-5 with a = 1, b = -2, c = -1 and d = -0.2.
Equation A4-5 is intrinsically nonlinear (cannot be converted into a linear
form).
Power. Data with the behavior shown in Figure A4-8 can be fitted by equation
A4-6.
y=aX b (A4-6)
