Statistical Analysis: Microsoft® Excel® 2013

4. How Variables Move Jointly: Correlation

In This Chapter

Understanding Correlation

Using Correlation

Using TREND() for Multiple Regression

Moving on to Statistical Inference

Chapter 2, “How Values Cluster Together,” discussed how the values on one variable can tend to cluster together at an average of some sort—a mean, a median, or a mode. Chapter 3, “Variability: How Values Disperse,” discussed how the values of one variable fail to cluster together: how they disperse around a mean, as measured by the standard deviation and its close relative, the variance.

This chapter begins a look at how two or more variables covary: that is, how higher values on one variable are associated with higher values on another, and how lower values on the two ...