N

Name Box

displaying, 2

named range creation with, 2

Name Manager dialog box, 5

creating named ranges with, 4–5

named ranges

AutoComplete and, 7

for columns, 7

creating, with Create from Selection option, 3–4

creating, with Name Box, 2–3

creating, with Name Manager, 4–5

deleting, 6

dynamic, 152–153

editing names of, 5

in formulas, 6–7

listing, 2, 5

naming, 10

noncontiguous, 2–3

selecting, 9

spaces in names, 10

workbook scope vs. worksheet scope, 8–9

naming

cells, 2.

See also named ranges

ranges, 10.

See also named ranges

tables, 196

negative binomial random variables, 455

negative correlations, 384.

See also correlations

NEGBINOMDIST function, 455

nested drop-down lists, 273–274

nesting

IF formulas, 85

subtotals, 362

net present value (NPV), 43

calculating, 46–47

defined, 46

/i1r/i0 value, 47

interest rate equal to 0. See internal rate of return (IRR)

NETWORKDAYS function, 42

New Name dialog box, 4

New Web Query dialog box, 266

nonlinear pricing, 563–564

normal cumulative function, 465

normal random variables

percentiles, calculating, 467–468

probabilities, calculating, 465–466

properties of, 464–465

simulating, 478–479

standard, 517

NORMDIST function, 465–466

NORMINV function, 478–479

normal random variable percentile calculation with, 467

in sports gambling modeling, 506

NORMSDIST function, 517

NOW() function, 93

NPV function.

See also net present value (NPV)

calculating, 47–48

syntax, 47

null hypothesis, 411

numbers, returning ASCII character for, 32