Calculating Correlation Coefficient by Hand: A Step-by-Step Guide

In the realm of statistics, the correlation coefficient is a crucial measure that quantifies the linear relationship between two variables. While software tools can calculate this for us, understanding how to compute it manually offers valuable insight into the underlying data. This guide will walk you through the process of calculating the correlation coefficient (r) by hand.

Understanding Correlation Coefficient
Before diving into the calculation, let's briefly understand what the correlation coefficient represents. It's a value that ranges from -1 to 1, where:

- 1 indicates a perfect positive linear relationship (as one variable increases, the other does too).
- -1 indicates a perfect negative linear relationship (as one variable increases, the other decreases).
- 0 suggests no linear relationship between the variables.
The formula for the correlation coefficient (r) is:

r = Σ[(x - x̄)(y - ȳ)] / √[Σ(x - x̄)² * Σ(y - ȳ)²]
Step 1: Calculate the Means (x̄ and ȳ)
First, find the means of both variables. The mean (x̄) of variable x is calculated as:

x̄ = (Σx) / N
where Σx is the sum of all x values, and N is the number of data points. Similarly, calculate the mean of variable y (ȳ).
Step 2: Calculate the Sums of Squares and Products

Next, calculate the sum of squares for each variable (Σx² and Σy²) and the sum of the products of deviations from the mean (Σxy).
Σx² = Σ(x - x̄)²


![Scatter Graphs Worksheets | KS3 & KS4 [FREE]](https://i.pinimg.com/originals/08/f8/b2/08f8b2c03c92d1d9c948536aa58ab84c.jpg)

















Σy² = Σ(y - ȳ)²
Σxy = Σ(x - x̄)(y - ȳ)
Step 3: Plug Values into the Formula
Now, plug the values from steps 1 and 2 into the correlation coefficient formula:
r = Σ[(x - x̄)(y - ȳ)] / √[Σ(x - x̄)² * Σ(y - ȳ)²]
This will give you the correlation coefficient (r) between the two variables.
Example
Let's calculate the correlation coefficient between two variables (x and y) using the following data:
| x | y |
|---|---|
| 5 | 10 |
| 6 | 12 |
| 7 | 14 |
| 8 | 16 |
Following the steps outlined above, you'll find that the correlation coefficient (r) is approximately 0.998, indicating a strong positive linear relationship between the two variables.