Contents
1 Measuring Variation: How Values Differ
From the Sum of Squares to the Variance
Using the VAR.P() and VAR.S() Functions
The Standard Error of the Mean
Expressing the Strength of a Correlation
Determining a Correlation’s Direction
From the Covariance to the Correlation Coefficient
Understanding Bias in the Correlation
Get Regression Analysis Microsoft® Excel® 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.