R

R2 value, 370

correlations and, 387

RAND function, 476–477

in card game modeling, 503–504

recalculating random number produced by, 477

RANDBETWEEN function, 492–493.

See also bootstrapping

in craps game modeling, 502

resampling with, 509

random numbers

inserting in cells. See RAND function

ranking. See RANK function

random variables

Beta. See Beta random variable

binomial. See binomial random variables

Central Limit Theorem and, 468–469

continuous, defined, 447

continuous, modeling as random, 486

defined, 445

discrete, defined, 445–446

discrete, simulating, 477–478

exponential, calculating probability of, 461

hypergeometric, 454–455

independent, 448

mean of, 446

modeling continuous variables as, 486

normal. See normal random variables

Poisson. See Poisson random variables

standard deviation of, 446

standard deviation, computing, 447

variance of, 446

variance of, computing, 447

Weibull. See Weibull random variable

randomized block, 418–419

range lookup argument, 11–12

when first column is non-numeric, 13–14

ranges

averaging entries in, 140

blank cells, counting. See COUNTBLANK function

conditional formatting for, 178

counting number of cells meeting criterion. See COUNTIF function

as databases, 340–341

data sets, 289

multiplying corresponding values in. See SUMPRODUCT function

named. See named ranges

referencing, specific number of rows/columns away from. See OFFSET function

selecting, 186

summing entries in, 140

transposing data between, 99

RANK function, 292

in card game modeling, 504

RATE function, 63

rating NFL teams. See point spreads, calculating

real options, 521–523

records, removing duplicates, 350

reformatting data. See formatting data

refreshing Web queries, 266

regression

forecasting model, determining variables for, 437–440

multiple. See multiple regression

nonlinearity, testing for, 406

relationships, straight-line. See straight-line relationships

reorder point

assumptions for calculating, 537

calculating, 538–540

calculating, for 95 percent service level, 540–541

calculating, when sales will be lost, 540

defined, 537

safety stock level and, 539

service level approach to, 538

reordering items, calculating. See Economic Order Quantity formula

REPLACE function, 31

Report Filter (PivotTables), 311

REPT function, 31, 36

resampling

defined, 509

example of, 509–511

retirement savings, calculating, 249–251

revenue, modeling over time. See exponential function

RIGHT function, 30

risk-free rate, 515

ROW function, 85

rows

converting into columns, 98, 574

counting number that meet certain criteria. See COUNTIFS function

referencing entire. See INDEX function

summing all entries in, 140

unhiding, 115

RSQ function, 440

R-squared value, calculating, 440