B


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




Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net