Statistical Analysis: Microsoft® Excel® 2013

Index

A

a priori ordering approach, 396

absolute references

calculating expected frequencies, 145-146

semipartial correlations, 381-384

adapting ANOVA Data Analysis tool

for nested factors, 326-327

for random factors, 322-323

adjusted group means, 458-461

adjusting means with LINEST() and effect coding, 453-458

alpha, 126-127

alternative hypotheses, 113

directionality of, 332

The Analysis of Covariance and Alternatives (Wiley, 2011), 445

Analysis ToolPak. See Data Analysis add-in

ANCOVA (analysis of covariance), 433

adjusted group means, 458-461

common regression line, testing for, 445-447

increasing statistical power, 435-444

multiple comparison procedures

planned contrasts, 466-468

Scheffé procedure, 462-466

multiple covariates, 469-471

purposes ...