S


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




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