Index

Symbols and Numbers

#DIV/0 error, 84

#N/A errors, 83–84

#NAME? error, 84

#NUM! error, 84

#REF! error, 84

#VALUE! error, 84

& operator, 31

4 period moving average, 427

95 percent confidence interval for mean profit, 482

95 percent service level

defined, 538

reorder point calculation using, 540–541

A

abandonment options, 523

Add Constraint dialog box, 224

adding numbers when pasting, 99–101

allocating assets, with bootstrapping, 495–498

alternative hypothesis, 411

American stock options, 514.

See also call options;

put options

comparing with European options, 514

analysis of variance, one-way. See ANOVA

AND formulas, 78

annual revenue, predicting, 114–116

annuities

valuing. See PV function

valuing, in future dollars. See FV function

ANOVA

analyzing data with, 412–413

defined, 411

dependent variable analysis with, 417

forecasting with, 414–415, 419–420

hypotheses, testing, 411–412

term origin, 413–414

two-way model, 418

two-way model with replication, 420–422

two-way model without replication, 418–419

array arguments, 572

array constants, 580–581

array formulas, 572

editing, 581

entering, 572

example of, 572–573

pasting, 572

summing second digit of list of integers with, 575–576

array functions, 572.

See also specific functions

summarizing data with, 577–580

ASCII characters, returning number for, 32

asset allocation, determining with bootstrapping, 495–498

auditing tool, 103.

See also dependents;

precedents multiple worksheets and, 106–107

AutoComplete

implementing, 194–195

and named ranges, 7

AVERAGEIF function, 140, 142

AVERAGEIFS function, 140, 142–143

averages, determining for flagged rows, 334

averaging numbers greater or equal to median value, 577