Index
A
Absolute addresses, 469
Absolute cell addressing, 459
Absolute cell references, 467
Additivity, 219
Advertising budget problem, 319–22
Algorithms, 187
Alldifferent constraint, 327, 331
Analysis using spreadsheets, 71–87
base-case analysis, 72
optimization analysis, 83
risk analysis, 84
simulation, 84
what-if analysis, 72–81. See also individual entry
Analytic Solver Platform, 187
ANDandOR function, 483
Arithmetic operations, 468
model formulation, 267
optimization, 268
Auditing software use, 68
Average, 501
Average outcome, 363
B
Back propagation, 160
Backward elimination, 146
Baker, K, 5
Balance equation, 271
Base-case analysis using spreadsheets, 72
Base-case model, 367–8, 376–8, 416–18, 422–5
ANDandOR, 483
CEILING, 486
financial functions, 486
FLOOR, 486
INT, 486
RAND, 486
RANDBETWEEN, 486
ROUND, 486
SUMIF, 484
Text and Date functions, 486
nesting of functions, 473
NPV Function, 472
Bayes Rule, 130
Benchmark criteria, 73–4, 338–9
maximax payoff criterion, 338
maximin payoff criterion, 338
minimax regret criterion, 339
Bernoulli distribution, 394, 498
Binary categorical ...
Get Management Science: The Art of Modeling with Spreadsheets, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.