How Can You Calculate Correlation Using Excel?

Uploaded by Program Studi Sistem Informasi UMN on May 17, 2017 at 7:51 am

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.