Wednesday, May 15, 2013

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


1. 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.
2. 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:=CORREL(A1:A50,B1:B50)Either method should yield the same result.
3. Press 'Enter.' The cell now contains the value of the correlation between the two columns.

Blogger news