Description
Calculates the Pearson correlation coefficient of values in 2 or more pairs of columns.
Example
Calculate the correlation between specimen weight and length:
Inputs
One.
Options
•Select 2 or more Columns whose values you wish to calculate the correlation for. All possible pairs of selected columns will be calculated.
Notes
•The Pearson correlation coefficient is calculated in the range +1.0 to -1.0 where:
o+1.0 means a perfect correlation
o0.0 means no correlation
o-1.0 means a perfect inverse correlation
•A column is assumed to always perfectly correlate with itself. Even if it has no numeric values.
•Pairs of values are ignored if they are not both valid numeric values.
•N/A is returned if two columns have no valid numeric pairs.
•N/A is returned if all the numeric values in a column are identical (as this gives a standard deviation of 0, which causes a divide by 0 error).
•Use the Num Format transform to change the number of decimal places .