Regression Analysis Microsoft® Excel®

Index

Symbols

^ (exponentiation operator), 8

A

ABS() function, 7

adding

covariates, 298

sum of squares, 74–75

add-ins, Data Analysis, 203, 215

Correlation tool, 271, 276

dummy coding, 246

adjusted regression sum of squares, 312–313

alphas, 184

analysis

effect coding, 279–283

factorial, 272–277

LINEST() functions, 132

multiple regression, 166

outcome variables, 299

residuals, 92

results, comparing, 249

summarizing, 320–321

via proportions of variance, 133–149

via Sum of Squares, 132

with/without covariates, 308–312

analysis of covariance. See ANCOVA

analysis of variance. See ANOVA

ANCOVA (analysis of covariance), 295–297

adjusted regression sum of squares, 312–313

analysis

summarizing, 320–321

with/without covariates, 308–312

ANOVA, comparing ...