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