safety stock level, 539
sales, returning for specific month, 25
sampling with replacement from data. See resampling
scatter plots.
See also charts
creating, 367
for exponential growth modeling. See exponential function
Scenario Manager.
See also sensitivity analysis
best-case scenario, defining, 126
defined, 125
PivotTable, creating with, 128
summary report, creating, 128
worst-case scenario, defining, 127
scheduling workforce, 231–233
scroll bars
defined, 210
speed control, 210
SEARCH function, 31
SECOND function, 94.
See also times selecting
all data, 255
columns, all data in, 100
data validation cells, 273
formulas, all, 521
named ranges, 9
ranges, 186
selections, named range creation with, 3–4
sensitivity analysis
data tables and. See data tables
defined, 110
varying multiple inputs in. See Scenario Manager
sequences, filling in, 95
serial format for dates, 40, 91
converting to month/day/year format, 40
shipping costs, minimizing. See transportation problems
SKEW function, 288
skew of data set, 288
SLOPE function, 371
SMALL function, 291
smoothing methods. See Winter's method
Solver. See Excel Solver
Solver Parameters dialog box, 223
sorting
by color, 188–189
by icons, 189
months, in chronological order, 190
by multiple criteria, 185–188
options for, 188
without Sort dialog box, 191
spaces in text strings, removing, 31
spin buttons
creating, 207–208
defined, 207
linking to cells, 208–209
sports gambling, modeling, 505–507
spreadsheets, analyzing outputs and inputs. See sensitivity analysis
standard deviation
estimating, 486
of random variables, 446
of random variables, computing, 447
standard error, determining, 370
standard normals, 517
statistical functions for databases. See database statistical functions
statistics, descriptive. See descriptive statistics
steady state, 544
STEYX function, 370
stock options.
See also call options;
put options;
real options
abandonment, 523
American, 514
European, 514
stocks
correlations between, 384–386
downloading information on, 267–268
exercise price, 513
geometric mean as measure of average annual return, 293–294
simulating future returns. See bootstrapping volatility. See volatility, stock
story problems, solving, 121–122
straight-line relationships
estimating, 367
least-squares line, 369
slope/intercept, determining, 371
standard error, determining, 370
structure, 103
structured references, 201–202
subtotals, 359
inserting, 359–360
nesting, 362
subtracting numbers when pasting, 99–101
SUMIF function, 140–142, 578
SUMIFS function, 140, 142
summarizing large data sets. See descriptive statistics;
histograms;
PivotTables
SUMPRODUCT function
for capital budgeting models, 242
product mix problem and, 222–223