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 Do Sixth Grade Math Ratio Tables
How to Draw a Normal Distribution in Excel
How to Calculate Correlation Coefficient Between Two...
How to Solve by Simpson's Rule With Excel
Where Is Starch Stored in Plant Cells?
How to Make Cytoplasm for a Cell Project
How to Subtract Matrices on Excel
What Happens to a Cell If It Does Not Copy DNA Chromosomes...
How to Convert CM to Inches in Excel
How to Calculate Pearson's R (Pearson Correlations)...
How to Make a Plant Cell Model Using a Shoebox
How to Decrease Digits in Excel
How to Calculate Statistical Mean
What Happens When Mitosis Goes Wrong and in Which Phase...
Purpose of a Cell
How to Find Lattice Constant
What Are the Two Major Components of an Atom?
What Is Rearrangement in Meiosis?

Dont Go!

We Have More Great Sciencing Articles!