1. **Collect Data**: Gather data for two variables (X and Y) that you want to calculate the correlation coefficient for. Ensure that you have paired data points, meaning each value of X corresponds to a value of Y.

2. **Calculate the Mean**: Find the mean (average) of both variables, X and Y. Let's denote the means as \( \bar{X} \) and \( \bar{Y} \).

3. **Calculate the Deviations**: For each data point, calculate the deviation from the mean for both variables. The deviation for variable X is \( (X_i - \bar{X}) \), and the deviation for variable Y is \( (Y_i - \bar{Y}) \), where \( X_i \) and \( Y_i \) are individual data points.

4. **Calculate the Product of Deviations**: Multiply the deviations of X and Y for each data point and sum them up. This is the sum of the products of deviations, denoted as \( \sum{(X_i - \bar{X})(Y_i - \bar{Y})} \).

5. **Calculate the Sum of Squares**: Calculate the sum of squares of deviations for both X and Y. This is the sum of the squares of deviations, denoted as \( \sum{(X_i - \bar{X})^2} \) and \( \sum{(Y_i - \bar{Y})^2} \).

6. **Calculate the Correlation Coefficient**: Use the following formula to calculate the Pearson correlation coefficient (r):

\[

r = \frac{\sum{(X_i - \bar{X})(Y_i - \bar{Y})}}{\sqrt{\sum{(X_i - \bar{X})^2} \sum{(Y_i - \bar{Y})^2}}}

\]

7. **Interpret the Correlation Coefficient**: The correlation coefficient (r) ranges between -1 and 1.

- A correlation coefficient close to 1 indicates a strong positive linear relationship between the variables.

- A correlation coefficient close to -1 indicates a strong negative linear relationship between the variables.

- A correlation coefficient close to 0 indicates a weak or no linear relationship between the variables.

8. **Significance Testing**: You may also want to perform significance testing to determine if the correlation coefficient is statistically significant. This involves calculating a t-statistic or using hypothesis testing methods.

That's how you calculate the correlation coefficient between two variables using the Pearson correlation coefficient formula.