How Can You Calculate Correlation Using Excel?

Share it with your friends Like

Thanks! Share it with your friends!

Close

How Can You Calculate Correlation Using Excel?
Those without the Toolpak use the standard CORREL function:
= CORREL (array 1, array 2)
There may be some rounding errors in pre-2003 versions of Excel, but those errors have been fixed in later editions.
In Excel, all Variable X values could be listed in Column B, descending from Row 2 to Row 31.
Each measured height could become a value for Variable X and each corresponding weight could be a value for Variable Y.
In a separate cell, the following formula would be entered:
= CORREL (B2:B31, C2:C31)
This returns the Pearson correlation between the two data arrays.
All Variable Y values could be listed in Column C from Row 2 to Row 31.

Comments

Write a comment

*