Statistical Analysis: Microsoft® Excel 2010, Video Enhanced Edition

Index

A

a priori ordering, 348

absolute addressing (Excel), extending semipartials, 332–335

adjusted group means and effect coding, 386–388

adjusting means, 381–386

alpha, 129, 186, 220

calculating, 270–271

manipulating, 221–223

setting the level, 204

alternative hypotheses, 116, 198–199

analysis

ANOVA, 261

F tests, 268–270

scores, partitioning, 261–264

of dependent group t-test, 249–252

The Analysis of Variance and Alternatives (Wiley, 1980), 372

ANCOVA (analysis of covariance), 361

bias, removing, 375–379

common regression line, testing for, 372–375

effect coding, adjusted group means, 386–388

means, adjusting with LINEST() function, 381–386

multiple comparisons

planned contrasts, 394–395

Scheffe method, 389–393

multiple covariance, 396–398 ...