best-case scenarios. See Scenario Manager
Beta random variable.
See also BETADIST function
defined, 471
duration modeling with, 473–474
BETADIST function, 474.
See also Beta random variable
bidding, simulating, 486–488
bin ranges (histograms), 277
defining, 278
binary changing cells, 241
BINOMDIST function, 453–454
binomial random variables
defined, 451
examples of, 452–453
negative, 455
simulating, 485
Black-Scholes formula
history of, 513
implementing, 516–518
parameters determining put/call value, 515
stock volatility estimating with, 519–520
blank cells, counting. See COUNTBLANK function
Boolean arrays, 579–580
bootstrapping. See also RANDBETWEEN function
allocating assets with, 495–498
data tables for, setting up, 493–494
defined, 491
demonstration of, 492–494
Bottom 10 Items conditional formatting rule, 165–166
break-even analysis, 120
bundling products, 564–566