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 ...

Get Statistical Analysis: Microsoft® Excel 2010, Video Enhanced Edition 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.

Start your free trial