Page 470 - Excel for Scientists and Engineers: Numerical Methods
P. 470
INDEX 447
initial estimates for Solver 323 L
InputBox function 4 1 Lagrange fourth-order polynomial 87
InputBox method, syntax of the 42 Laplace's equation 264,266
insert a module sheet 2 LBound function 44
Insert Function dialog box 12 least squares
Integer keyword 29 curve fitting 3 16
integral, definite 127 fit to a straight line 288,289,292,
indefinite 127 294,3 16
Integrate custom function 134 intercept 288
Integrates custom function 136 slope 288
IntegrateT custom function 136 Legendre polynomials 137
integrating a function 133 limitations of the Regression tool 305
integration, lower and upper limits of of Trendline 301
134, 140, 142 limits of integration, lower and upper
symbolic 127 134, 140, 143
INTERCEPT worksheet function 289, linear
29 1 equations, systems of 190
intercept, least-squares 288 in the coefficients 287,289
InterpC custom function 88, 92 interpolation 83, 85, 86
InterpC2 custom function 93,95 interpolation in a two-way table 90
InterpL custom function 86, 90 least squares curve fitting 3 16
interpolation 77, 83 regression 287,289
cubic 87 using Trendline 298
linear 83, 85, 86 linearized forms of nonlinear
Intersect method 37 equations 329
intersection of two lines 174, 178 line-continuation character 10
interval method with linear LINEST shortcut 297
interpolation 15 1 LINEST worksheet function 65, 105,
interval-halving method 149 292, 293,294, 296,297
intrinsically nonlinear 3 13 LINEST's regression statistics 297
inverse matrix, in SolvStat macro 328 Lineweaver-Burke 330,417
inverse of a matrix 60 liquid flow (problem) 243
ISERROR worksheet function 360 local minimum 323
Iteration box 200, 205,237 logarithmic 41 5
logical operators 17,25
J logistic curve 4 18,4 19,420
Jacobi method 200 lookup functions 77
LOOKUP worksheet function 79
K loop, exiting from 28
Keep Solver Solution 322 looping 26
keywords, VBA 365 loops, nested 28
