Page 471 - Excel for Scientists and Engineers: Numerical Methods

448 EXCEL:NUMERICAL METHODS

lower and upper limits of integration MDETERM worksheet function 60,
134, 140, 141 63, 190, 191
megaformula 107,347
M methane hydrate 289
Macro Name list box 15 method of steepest descent 3 16
macro, function 11 methods, VBA 18,23,33
macros, Add-In 53 Michaelis-Menten 330, 416
command 4 MIDENT worksheet function 63
two kinds of 4 MIN worksheet function 279
main diagonal 57 MINDEX worksheet function 64
male children (problem) 362 MINVERSE worksheet function 60,
manual scaling (Solver) 326 191,257,261,276
Marquardt-Levenberg algorithm 3 16 MMULT worksheet function 62, 191,
MATCH worksheet function 80, 84, 257,261,276
106,107,346 Module from the Insert menu 1 1
mathematical functions, VBA 21 module sheet, rename a 14
matrices 57 inserta 2
matrix Monte Carlo method 342,350, 354
addition 58 MSCALE worksheet function 64
elements 57 MsgBox
functions, additional 63 function 39
inversion 60,62, 19 1 , 276 return values 41
mathematics 58 buttons parameter of 40
multiplication 59 multidimensional array 44
subtraction 58 multiple linear regression 289, 293,
transposition 60 410
diagonal 58 multiplication, matrix 59
identity 63 scalar 59
in SolvStat macro 328
square 57 N
symmetric 58 named formulas 107
transpose of a 62 naming functions and arguments 11
tridiagonal 5 8 variables or arguments 17
unit 58 nested loops 28
Max Time and Iterations (Solver Newton quotient 1 10
options) 324 Newton-Raphson
MAX worksheet function 80,279 custom function 163
Maximum Change parameter 159, method 154, 155, 161, 176, 178
162,205,237 Newton's iteration method 207
Maximum Change (Solver options) nodes, in Gaussian quadrature 137
325 noise 103,342,344
non-contiguous ranges 297