D

Data Analysis, for multiple regression, 390–391

data arrays, counting values in, 574–575

data bars, 164–165, 169–170.

See also conditional formatting

data formatting. See formatting data

data sets

comparing, 290

descriptive statistics for. See descriptive statistics

outliers, 289

range, 289

ranking numbers in, 292

sample variance, 288

second-largest values, finding, 291

spread, 288

trimmed mean, 292–293

data, summarizing. See descriptive statistics;

histograms;

PivotTables

data tables

automatic recalculation, turning off, 113

for bootstrapping, setting up, 493–494

for card game modeling, 504–505

for craps game modeling, 503

for customer valuation, 527

functions and, 113–114

input value effect on, 113

one-way, 110

one-way vs. two-way, 110

one-way, setting up, 110–111

saving values in, 113

for sports gambling modeling, 506

two-way, separating row and column input cells in, 113

two-way, setting up, 112

data validation

clearing, 274

for dates, 271

error alerts, configuring, 270

formulas for, 271–272

list criteria, 272

running, 269–270

selecting all cells with, 273

setting up, 269

user prompts, creating, 270

database statistical functions

computed criteria for, 335

criteria ranges for, 336

defined, 331–332

databases

clearing filters, 343

ranges as, 340–341

date formats, 39

changing, 40

General, 40

serial, 40, 91

serial, converting to month/day/year, 40

DATE function, 42

DATEDIF function, 43

dates.

See also times;

workdays

calculating, 41–42

calculating number of, between two other dates, 43

conditional formatting for, 179–180

displaying, with formula, 40–41

extracting month, year, and day from, 42

sorting in chronological order, 190

and times, in same cell, 74

validating, 271

DATEVALUE function, 40

DAVERAGE function, 334

DCOUNT function, 334

deleting

conditional formatting, 165, 176

named ranges, 6

delimited text files, 259

density function. See probability density function

dependencies between cells. See circular references

dependent variables

defined, 365

factors influencing, analyzing. See ANOVA

nonlinear effect of independent variables on, 405

dependents

defined, 104

tracing, 104–105

descriptive statistics

creating, 285–286

data set comparison with, 290

defined, 285

mean, 287

mean vs. median as measure of central location, 287

median, 287

mode, 287

Developer tab, 205

DGET function, 336–337

dialog boxes

Add Constraint, 224

Change Constraint, 228

Consolidate, 356

Correlation, 384

Create PivotTable, 299

Format Trendline, 366

Histogram, 278–279

Name Manager, 5

New Name, 4

New Web Query, 266

Solver Parameters, 223

discrete random variables

defined, 445–446

Poisson. See Poisson random variables

simulating, 477–478

distances, calculating, 19–20

dividing numbers when pasting, 99–101

drop-down lists, 273–274

DSUM function, 332–333

calculating total dollar value with, 333

for either/or calculation, 334

dummy variables, 396

creating, 397

duration, modeling. See Beta random variable

dynamic ranges, 152–153

OFFSET function and, 153–155

updating charts with, 153–155