Statistical Analysis: Microsoft Excel 2016

15Multiple Regression Analysis and Effect Coding: The Basics

IN THIS CHAPTER

Multiple Regression and ANOVA

Multiple Regression and Proportions of Variance

Assigning Effect Codes in Excel

Using Excel’s Regression Tool with Unequal Group Sizes

Effect Coding, Regression, and Factorial Designs in Excel

Using TREND() to Replace Squared Semipartial Correlations

Chapter 11, “Testing Differences Between Means: The Analysis of Variance,” and Chapter 12, “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 Analysis add-in tools that ...