## How Can You Calculate Correlation Using Excel?

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.

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