Computing Correlation Coefficients in Excel

Fundamentals of Social Statistics


To compute the correlation coefficient between two variables (Pearson’s), use the CORREL function.  Let’s say for example that a researcher is interested in the relationship between students’ GPA and hour spent studying.

Figure 23. The CORREL Function in Excel
Figure 23. The CORREL Function in Excel

Note that the CORREL function yields the same results as the PEARSON function.

[ Back | Contents | Next ]

Last Modified:  02/18/2019

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.