Data-Driven Business Decisions

Index

Adjusted r-squared 401

Association 320

Auto-correlation 331

Auto-regression 453

Automatic model selection 429

Average 14

Backwards elimination 430

Bayes concept 80

Bayes algorithm 81

Binary traits 414

Binomial distribution 122

Coefficient of variation

prob dist 115

sample 17

Combining performance measures 41

Combining normal variables 149

Comparing normal variables 152

Conditional probability 61

Conditional mean 114

Confidence interval

for mean 230

for mean difference 247

for proportions 279

for slope 355

for trend mean 370, 405

Correlation 303, 320

auto 331

meaning 328

moving 327

ordinary/marginal 334

partial 335

test 330

Cumulative distribution function 152

Cumulative risk profile 177

Data distribution 8

Data generating mechanism 199

Data types 5

Decision trees

basic 171

multistage 181

Delayed effects 448

Dependence 67

rules 70–71

Deseasoning time series 446

Detection power of test 235

Difference of proportions 281

Difference of means 246

Diagnostic probabilities 64

Diversification of risk 308

Dummy variables

for seasonality 441

for segment 426

for yes–no features 415

Estimated RMSE 354, 393

Estimating trend mean 370, 405

Exact methods 286

Excel

BINOMDIST 125

CORREL 303, 320

COUNTIF 11

dragging a formula 12

Goalseek 157

grouping in pivotables 33

INTERCEPT 349

NORMDIST 145

NORMINV 160

NORMSDIST 155

Pivotables 31

POISSON 133

SLOPE 349

Solver 309

SUMPRODUCT 14, 104, 405

VLOOKUP 49, 239

$-symbol 12

Expected value

of perfect information 188

of sample information 186

Fitted values ...