You can calculate the correlation between two variables by a measurement known as the Pearson Product Moment Correlation (also called Pearson's correlation or Spearman rank correlation). You may know that you can make this calculation, often designated by the letter "r," using statistical software, such as SPSS or R. But did you know that you can even do it with good-old Microsoft Excel?
Things You'll Need
- Microsoft Excel
Put the values of the two variables you wish to correlate into two columns of the same length. For example, say you have data about the heights and weights of 50 people, and want to calculate the Pearson correlation between the two. Put the data into two columns: the heights in cells 1 to 50 of column A, and the widths in cells 1 to 50 of column B.
Select an unused cell and type "=CORREL(" (without the quotes). After typing the first open parentheses, select all of the cells in your first column, type a comma, select all of the cells in your second column, and type the closing parentheses ")". In this example, since the data was in cells 1 to 50 of column A and cells 1 to 50 of column B, you could also simply type:
Either method should yield the same result.
Press "Enter." The cell now contains the value of the correlation between the two columns.
- Photo Credit John Foxx/Stockbyte/Getty Images
How to Use Excel's FISHER Function
How to Use Excel's FISHER Function. Excel has a myriad of useful statistical functions built into the program. One such function is...
How to Calculate Correlation
The correlation coefficient, or r, always falls between -1 and 1 and assesses the linear relationship between two sets of data points...
How to Calculate a T-Test for Pearson
The terms "Pearson" and "T-Test" refer to two different things in statistical analysis. Pearson refers to the Pearson Correlation Coefficient, and represents...
How to Calculate a Correlation Matrix
The correlation (r) is a measure of the linear relationship between two variables. For example, leg length and torso length are highly...
How to Calculate Point Biserial Correlation
The strongest way to show how two variables are associated – like study time and course success – is the correlation. Varying...
How to Compute the Spearman Rank Correlation Coefficient
Spearman's Rank Correlation Coefficient is a number between -1 and +1 that represents the strength of the relationship between two variables in...
How to Calculate Correlation in Minitabs
If you want to find out more about the relationship between any two scales, such as height and weight of people in...
How to Calculate Correlation Coefficients With an Equation
Pearson's r is a correlation coefficient used to measure the strength of association between two variables that fall into the interval ratio...
What Are the Different Types of Correlations?
Different kinds of correlations are used in statistics to measure the ways variables relate to one another. For example, by using two...