Statistical Analysis: Microsoft

12. Multiple Regression Analysis and Effect Coding: The Basics

IN THIS CHAPTER

Multiple Regression and ANOVA 308

Multiple Regression and Proportions of Variance 312

Assigning Effect Codes in Excel 319

Using Excel’s Regression Tool with Unequal Group Sizes 322

Effect Coding, Regression, and Factorial Designs in Excel 324

Using TREND() to Replace Squared Semipartial Correlations 328

Chapter 10, “Testing Differences Between Means: The Analysis of Variance,” and Chapter 11, “Analysis of Variance: Further Issues,” focus on the analysis of variance, or ANOVA, partly because it’s a familiar approach to analyzing the reliability of the differences between three or more means, but also because Excel offers a variety of worksheet functions and Data ...