V

validating data. See data validation

valuation analysis, 373

VALUE function, 32–33

valuing customers, 525–528

variables

binomial random. See binomial random variables

continuous random, defined, 447

correlations between. See correlations

defined, 365

determining, for forecasting prediction, 437–440

discrete random, defined, 445–446

discrete random, simulating, 477–478

dummy. See dummy variables

hypergeometric, 454–455

independent random, 448

independent, with nonlinear effect on dependent, 405

multiple regression on, 389–392

normal random. See normal random variables

Poisson. See Poisson random variables

qualitative independent, 396

random, defined, 445

relationship, determining, 366

standard normal, 517

variance

of random variables, 446

of random variables, computing, 447

VLOOKUP function

#N/A errors, troubleshooting, 83–84

arguments, 11–12

with MATCH function, 25

syntax, 11

tax rate computation with, 12–13

volatility, stock

Black-Scholes estimate for, 519–520

defined, 515

estimating, 515–516

option value effect, 518