Pearson

Calculating the Pearson correlation (r) using Excel

by

Cell Preparation Here’s an image of the cells prepared for calculating r using Excel. I hypothesized that we want to calculate the r using two variables (X and Y) as shown below: X: 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10. Y: 10, 9, 8, 7, 6, 5, 4, 3, 2, and … Read more

Correlation: What’s the relationship between your height and your parents’ height?

by

The following graph shows the relationship between the two. The point of this figure is that the taller the parents, the taller the offspring (and vice versa). We should note, though, that the offspring of even very tall parents would not equal the height of its parents, but rather would be slightly shorter in stature … Read more