Page 469 - Excel for Scientists and Engineers: Numerical Methods
P. 469
446 EXCEL:NUMERICAL METHODS
For Each ... Next loop 27 Generalized Reduced Gradient
For ... Next loop 26 (Solver) 316
Formula property 1 16, 133,225 getting Trendline coefficients into a
formulas for computing derivatives spreadsheet 3 02
104 global minimum (Solver) 323,324
forward difference 99, 103 Goal Seek.. . 156, 159, 174, 175,
fourth-order polynomial, Lagrange 178,251
87 GoalSeek custom function 180, 182,
fourth-order Runge-Kutta, see Runge- 183
Kutta graphical method 147
frequency of occurrence of digits growth, exponential 4 12
(problem) 362 Guess (Solver parameters) 324
Frontline Systems Inc 3 16
F-statistic 298 H
Function Arguments dialog box 13 heat conduction in a brass rod
function linear in the coefficients 287 (example) 272
function macro 1 1 hierarchy of objects 3 1
Add-In 53 higher-order differential equations
Function procedure, structure of a 5 23 8
function 21 Hill slope 419
custom 11,49, 389 HLOOKUP worksheet function 77
derivative of a 109 use of, in Solver models 323
engineering 425 hyperbolic partial differential equation
logistic 418 263,282
naming 11
partial derivative of 287 I
shortcut to enter a 13 identity matrix 63
trigonometric 422 IF worksheet function 278,279
If ... Then statement 25
G If.. .Then... E lself statement 25
GaussElim custom function 194, 196 If ... Then...Else statement 25
Gaussian implicit intersection 107
curve 421 implicit method (PDE) 274
elimination 19 1 , 192 indefinite integral 127
quadrature 137, 138 indefinite number of arguments 5 I
Gauss-Jacobi method 200,205 INDEX worksheet function 80, 8 1 ,
GaussJordan custom function 197, 84, 106,346,349
198 INDIRECT worksheet function 72,
Gauss-Jordan method 196 107,256,259,279
Gauss-Seidel custom function 205 inflection point 100, 10 1
Gauss-Seidel method 200,203 information functions, VBA 23
initial conditions 2 1 8
