Page 472 - Excel for Scientists and Engineers: Numerical Methods
P. 472
nonlinear equations
linearized form of 329 P
systems of 207 n, estimation of 353,354,362
nonlinear least squares curve fitting panel 127, 140
using the Solver 314,316,317 parabolic partial differential equation
nonlinear regression, statistics of 327 263,269,274
nonlinear, intrinsically 3 13 ParamArray keyword 5 1 , 52,66
normal error curve 421 parentheses, arguments with or
normal random distribution, without 34
simulating 349, 421 partial derivative 168, 265, 287, 328
NORMINV worksheet function 349 in SolvStat macro 328
Not keyword 17,25 partial differential equation 2 17,263
number series 69 elliptic 263,264,267
NumberFormat property 19 hyperbolic 263,282
numerical differentiation 155 parabolic 263,269,274
passing values 46
0 Pearson product moment correlation
object browser 32 coefficient 289
objective function (Solver) 3 16, 326 pendulum motion (problem) 242
object-oriented programming language Personal Macro Workbook 8
18 perturbation factor (Solver) 3 16
objects 18,3 1 pH titration curve (example) 100
collections of 3 1 phase diagram 289
hierarchy of 3 1 pit-mapping 3 15
obtaining values from a table 77 plateau curve 4 16
occurrence of digits, frequency of polygon, area of 354
(problem) 362 polynomial
OFFSET worksheet function 106 cubic interpolating 129
On Error GoTo statement 1 19 Lagrange fourth-order 87
one-dimensional array 48 Legendre 137, 138
operators 17 regression 4 10
arithmetic 17 roots of a regular 166
comparison 17 position of a value in an array 64
logical 17, 25 power series 69
optimization 3 16 Precision and Tolerance (Solver
Option Base 1 44,47, 51 options) 324
Option Explicit 10 predictor-corrector methods 23 5
optional argument 50 Preserve keyword 45
Optional keyword 50 principal diagonal 57
Or keyword 17,25 Private 31
ordinary differential equation 2 17 procedure, exiting from 28
Orvis, William J. 88 running a Sub 8
