Page 473 - Excel for Scientists and Engineers: Numerical Methods

450 EXCEL:NUMEFUCAL METHODS

structure of a Function 5 linear 287,289
structure of a Sub 5 multiple 410
Visual Basic 4 multiple linear 289
program control 24 parameters, standard deviation of
Project Explorer window 1 , 2 327
properties 18, 19 polynomial 4 10
Range object 20 statistics of nonlinear 327
Properties window 1 , 4, 14 regression statistics
Public 31 from LINEST 297
mathematical relationships 297
Q Regression tool 289,304
quadratic interpolating polynomial limitations of 305
128 using 303
quadrature 127 Regula Falsi method 15 1 , 153
Quick Watch.. . 57 regular polynomial, roots of 166
rename a macro 14
R a module sheet 14
R2 288,296,298 Reset All (Solver parameters) 324
RAND worksheet function 342,343, result, array of values as 52
345 return statement 6
RANDBETWEEN worksheet function return values, MsgBox 41
343 returning an error value 50
random RMSD (root-mean-square deviation)
number generator 34 1 296,299
sampling 345, 347 roots of a regular polynomial 166
Range keyword 37 ROUND worksheet function 343
range, reference to 35 roundoff error 11 1
read-only 19 ROW worksheet function 7 1 , 1 07,
Record Macro dialog box 7 256,259,279,347
Record New Macro.. . 6 RSQ worksheet function 289,29 1
Recorder, using the 6 rules for naming variables or
ReDim keyword 45 arguments 17
reference Runge-Kutta custom functions 224,
to a cell 35 225,229,234
to a range 35 Runge-Kutta method 2 18,220,222,
to the active cell 35 223,225,235,237,251,258
circular 212 running a Sub procedure 8
refractive index of benzene (problem)
97 S
regression Sampling tool 348
analysis 287,288 sampling, random 345,347
coefficients 287,289,292 scalar multiplication 59