This recipe shows how to calculate correlation.
See the datasource (Formula.ds) for the logical diagram.
Correlation(r) = NΣXY - (ΣX)(ΣY) / Sqrt([NΣX2 - (ΣX)2][NΣY2 - (ΣY)2])
N = Number of values or elements,
X = First Score,
Y = Second Score,
ΣXY = Sum of the product of first and Second Scores,
ΣX = Sum of First Scores,
ΣY = Sum of Second Scores,
ΣX2 = Sum of square First Scores,
ΣY2 = Sum of square Second Scores
To download the necessary files for this recipe, refer to the attached ZIP package.
HowToCalculateCorrelation.zip (3.0 KB)