Statistical Analysis: Microsoft® Excel® 2013

15. Multiple Regression Analysis and Effect Coding: Further Issues

In This Chapter

Solving Unbalanced Factorial Designs Using Multiple Regression

Experimental Designs, Observational Studies, and Correlation

Using All the LINEST() Statistics

Managing Unequal Group Sizes in a True Experiment

Managing Unequal Group Sizes in Observational Research

Chapter 14, “Multiple Regression Analysis and Effect Coding: The Basics,” discusses the concept of using multiple regression analysis to address the question of whether group means differ more than can reasonably be explained by chance. The basic idea is to code nominal variables such as type of medication administered, or sex, or ethnicity, so as to represent them as numeric variables. Coded in that ...