Page 475 - Excel for Scientists and Engineers: Numerical Methods

452 EXCEL:NUMERICAL METHODS

standard deviation of the regression Taylor series 73, 103,208
parameter 327 temperature distribution 267
standard error of the y estimate 296, tenth-order Legendre polynomial 138
298 testing 54
statements, VBA 16 text functions, VBA 22
statistics of nonlinear regression 327 thermal diffusion equation 264
StatusBar 325 To Value box (Goal Seek) 158, 18 1
steepest descent, method of 3 16 Toggle Breakpoint 55
stencil 266, 271, 283 traffic model (problem) 362
Step mode 55,58 trajectory (problem) 24 1
stepping through code 55 transpose of a matrix 62
Stop keyword 55,56 TRANSPOSE worksheet function 49
Stop Recording toolbar 6,7 transposition, matrix 60
straight line, least-squares fit to a trapezoid method for integration 127,
288,289 134
String keyword 29 traveling salesman (problem) 362
structure of a Function procedure 5 TREND worksheet function 85, 86,
of a Sub procedure 5 90
Sub procedure, running 8 Trendline 289,298
Sub procedure, structure of 5 fitting functions 302
subroutines 30 , limitations of 301
SUBSTITUTE worksheet function linear regression using 298
116, 134,225 Trendline.. .Tocell utility 305
subtraction, matrix 58 trial-and-error 3 14
sum of a series 69 tridiagonal matrix 58
sum of the squares of deviations 288 trigonometric functions 422
surface, error 3 15 two kinds of macros 4
symbolic integration 127,218 two ways to specify arguments of
symmetric matrix 58 methods 34
syntax of the InputBox method 42 two-way table 81
systems cubic interpolation in 91,94
of differential equations 229 linear interpolation in
of first-order differential equations
228 U
of linear equations 190 UBound function 44,5 1
of nonlinear equations 207 Unable to find a solution (Solver)
of simultaneous differential 323
equations 229 Union method 37
unit matrix 58, 196
T Use Automatic Scaling (Solver
table, obtaining values from a 77 options) 325
target cell (Solver) 3 16 user-defined functions 4