Page 468 - Excel for Scientists and Engineers: Numerical Methods

INDEX 445

of a function 109 empirical fitting function 294
of a worksheet formula 110, 1 1 1 , Engineering functions 343,425
112 entering VBA code 9
partial 168 equation, exponential 4 1 1
partial 287 equation, Michaelis-Menten 4 16
second 99, 100, 120 equations, simultaneous 65
determinant 57, 58,60, 190 error surface 3 15
degrees of freedom 297 error value, returning 50
diagonal elements, in SolvStat macro error, approximation 11 1
328 error-square sum 3 14
diagonal matrix 58 estimation of n 353,354,362
diatomic molecule (example) 183 Euler's method 2 18,2 19,222, 247,
difference formulas 103 250,258
difference, backward 99, 103 Evaluate method 116, 117, 134,225
central 99 evaluating series formulas 70
forward 103 event-handler procedures 3
differential equation 2 17 examining the values of variables 56
first-order 2 18 Exit keyword 28
higher-order 238 exiting from a loop 28
ordinary 217 from a procedure 28
partial 217 explicit method 270
second-order 245,259 exponential
differential equations, systems of 229 curve 289
systems of first-order 228 decrease 412
systems of simultaneous 229 double 413
digits, frequency of occurrence of equation 411
(problem) 362 growth 412
Dim keyword 43,44 external references (Solver) 323
dimensioning an array 43
discontinuous functions (Solver) 323 F
distance traveled along a curved path F9 (function key) 71
141 Fick's second law 264
Do While ... loop 27 finite-difference method 254, 258
Double keyword 29 first and second derivatives 99
double exponential 4 13 first derivative 99, 104, 155
double reciprocal plot 4 17 of a specific worksheet formula
dynamic array 45 110
of a worksheet formula 1 1 1, 1 15
E first-order differential equations 2 I8
ellipse, area of 144 systems of 228
elliptic partial differential equation fitting function, empirical 294
263,264,267 fitting functions, Trendline 302