Index

Symbols

#DIV/0! error, avoiding, 108

$ (dollar sign) in absolute references, 165

A

access to reference samples, 8-9

accuracy of logistic regression, assessing

with cross-validation, 43-48

with statistical inference, 48-52

agreement measures, 15-16

alpha levels, 66-67

Among SSCP matrix

basis for, 105

calculating in Excel, 102-104

analysis of variance. See ANOVA (univariate analysis of variance); MANOVA (multivariate analysis of variance)

Analysis ToolPak. See Data Analysis add-in

ANOVA (univariate analysis of variance)

ANOVA: Single Factor tool, 73-75

descriptive statistics, 75-76

group names, 75

inferential statistics, 76-79

cholesterol treatment example, 66-72

error rate adoption, 66-67

results, 93

standard error of the mean, 70-72

statistical ...

Get Decision Analytics: Microsoft® Excel® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.