Correlation Scratchpad

This scratchpad let's you see the build up to the correlationi coefficient. If there's a strong association then each pair of z-scores will be generally in the same direction (pos/neg) and the same quantity (small/medium/large). The correlation is simply the average of the z-score products.


Raw Scores and Z-Products (ZP)

Variable 1
Variable 2
ZP
.00
([s11]-[mean1])/[SD1]
.00
([s21]-[mean1])/[SD1]
.00
([s31]-[mean1])/[SD1]
.00
([s41]-[mean1])/[SD1]
.00
([s51]-[mean1])/[SD1]
.00
([s61]-[mean1])/[SD1]
.00
([s12]-[mean2])/[SD2]
.00
([s22]-[mean2])/[SD2]
.00
([s32]-[mean2])/[SD2]
.00
([s42]-[mean2])/[SD2]
.00
([s52]-[mean2])/[SD2]
.00
([s62]-[mean2])/[SD2]
.00
[Z11]*[Z21]
.00
[Z12]*[Z22]
.00
[Z13]*[Z23]
.00
[Z14]*[Z24]
.00
[Z15]*[Z25]
.00
[Z16]*[Z26]

Key Measures

Variable 1
Variable 2
Correlation
m1: .00
[mean1]
s1: .00
[SD1]
m2: .00
[mean2]
s2: .00
[SD2]
SZP: .00
[SZP]
r: .00
[SZP]/5
([s12]+[s22]+[s32]+[s42]+[s52]+[s62])/6
([s11]+[s21]+[s31]+[s41]+[s51]+[s61])/6
([s11]-[mean1])**2
([s21]-[mean1])**2
([s31]-[mean1])**2
([s41]-[mean1])**2
([s51]-[mean1])**2
([s61]-[mean1])**2
[dev2s1v1]+[dev2s2v1]+[dev2s3v1]+[dev2s4v1]+[dev2s5v1]+[dev2s6v1]
[SumOfSquares1]/5
sqrt([Variance1])
([s12]-[mean2])**2
([s22]-[mean2])**2
([s32]-[mean2])**2
([s42]-[mean2])**2
([s52]-[mean2])**2
([s62]-[mean2])**2
[dev2s1v2]+[dev2s2v2]+[dev2s3v2]+[dev2s4v2]+[dev2s5v2]+[dev2s6v2]
[SumOfSquares2]/5
sqrt([Variance2])
([s11]-[mean1])/[SD1]
([s21]-[mean1])/[SD1]
([s31]-[mean1])/[SD1]
([s41]-[mean1])/[SD1]
([s51]-[mean1])/[SD1]
([s61]-[mean1])/[SD1]
([s12]-[mean2])/[SD2]
([s22]-[mean2])/[SD2]
([s32]-[mean2])/[SD2]
([s42]-[mean2])/[SD2]
([s52]-[mean2])/[SD2]
([s62]-[mean2])/[SD2]
([Z11]*[Z21])+([Z12]*[Z22])+([Z13]*[Z23])+([Z14]*[Z24])+([Z15]*[Z25])+([Z16]*[Z26])