Page 467 - Excel for Scientists and Engineers: Numerical Methods

444 ~~ EXCEL:NUMERICAL METHODS

C fitting data to 295
calculating derivatives 100 fitting function for calculating
cubic fitting function for 105 derivatives 105
Calculation tab 205 interpolating polynomial 129
Calculation tab, in Tools-Options interpolation 87
158, 162, 180 interpolation in a table 89
calibration curve (problem) 309 interpolation in a two-way table 9 1,
Call keyword 30 93
cell, reference to 35 curve
Cells keyword 36,37 areaundera 127, 129, 130, 131,
central difference 99, 103 133
changing cells (Solver) 3 16,326 logistic 419, 420
Chartwizard method 35 normal error 421
CheckSpelling method 35 plateau 416
chemical kinetics 243 slopeofa 155
choice of Ax 123 curved path, distance traveled along a
circular reference 16 1, 2 12, 236,267 141
Clausius-Clapeyron equation 289 curves, area between two 132
Codewindow 1 curves, intersection of 176
code, stepping through 55 custom function 11,49, 389
coefficient of determination 296 dydx 1 19,120,123
coefficients, linear in the 289 d2ydx2 120, 121, 123
regression 287,289,292 Integrate 134
collections of objects 3 1 Integrates 136
COLUMN worksheet function 256, JntegrateT 136
259,278,279 custom lookup formula 80
command macros 4 CVErr keyword 50
comparison operators 17
computing derivatives, formulas for D
104 Data Analysis ... 303, 347
constraints, in Solver model 324 debug toolbar (VBA) 57
Convergence (Solver options) 325 Debug ... 55
convergence, slow 153 debugging 54
convergent series 69 deck of cards (problem) 362
ConvertFormula method 1 17, 1 18 decrease, exponential 4 12
correlation coefficient, R 288 definite integral 127
Cramer's rule 169, 190 derivative
Crank-Nicholson 274,280 calculating first and second 99, 104
create an Add-In macro 53 cubic fitting function for calculating
critical points 100 105
cubic first 99, 100
equation 147 formulas for computing 104