Computing Correlation Coefficients in Excel

Fundamentals of Social Statistics by Adam J. McKee

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 hours 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:  06/03/2021

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.