How to Calculate Pearson's R (Pearson Correlations) in Microsoft Excel

By Contributor; Updated April 24, 2017
Use Pearson's correlation to study the relationship between two variables.

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?

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.

About the Author

This article was created by a professional writer and edited by experienced copy editors, both qualified members of the Demand Media Studios community. All articles go through an editorial process that includes subject matter guidelines, plagiarism review, fact-checking, and other steps in an effort to provide reliable information.