How to Calculate the Correlation Between Two Variables

The correlation of two variables indicates how strongly a change in one variable can predict the change in the other.
••• Jupiterimages/Comstock/Getty Images

The correlation between two variables describes the likelihood that a change in one variable will cause a proportional change in the other variable. A high correlation between two variables suggests they share a common cause or a change in one of the variables is directly responsible for a change in the other variable. Pearson's r value is used to quantify the correlation between two discrete variables.

    Label the variable that you believe is causing the change to the other variable as x (the independent variable) and the other variable y (the dependent variable).

    Construct a table with five columns and as many rows as there are data points for x and y. Label the columns A through E from left to right.

    Fill in each row with the following values for each (x,y) data point in the first column -- the value of x in Column A, the value of x squared in Column B, the value of y in Column C, the value of y squared in Column D and the value x times y in Column E.

    Make a final row at the very bottom of the table and put the sum of all the values of each column in its corresponding cell.

    Compute the product of the final cells in Column A and C.

    Multiply the final cell in Column E by the number of data points.

    Subtract the value obtained in Step 5 from the value obtained in Step 6 and underline the answer.

    Multiply the final cell of Column B by the number of data points. Subtract from this value the square of the value of the final cell of Column A.

    Multiply the final cell of Column D by the number of data points and subtract the square of the value of the final cell of Column C.

    Multiply the values found in Step 8 and 9 together and then take the square root of the result.

    Divide the value obtained in Step 7 (it should be underlined) by the value obtained in Step 10. This is Pearson's r, also known as the correlation coefficient. If r is close to 1, there is a strong positive correlation. If r is close to -1, there is a strong negative correlation. If r is close to 0, there is a weak correlation.

Related Articles

How to Draw an Array in Math
How to Draw a Normal Distribution in Excel
What Are the Functions of Microfilaments & Microtubules?
How to Make Cytoplasm for a Cell Project
What Happens to a Cell If It Does Not Copy DNA Chromosomes...
Where Is Starch Stored in Plant Cells?
How to Calculate Volume of a Rectangular Prism
How to Do Sixth Grade Math Ratio Tables
How to Make a Plant Cell Model Using a Shoebox
How to Solve by Simpson's Rule With Excel
Purpose of a Cell
How to Decrease Digits in Excel
What Function Do Spindles Perform During Mitosis?
Plant & Animal Cell Activities for Fourth Grade
How to Calculate Correlation Coefficient Between Two...
How to Calculate the Mean in a Probability Distribution
How to Calculate Statistical Mean
How to Calculate Volume of a Circular Cylinder
List the Steps of the Cell Cycle in Order