Page 125 - Quantitative Data Analysis

Quantitative Data Analysis
Simply Explained Using SPSS

Manual Calculations of Correlation

Following set of scores (X) and (Y) represent values of two variables
with the range of 1 to 10.
Cross Product of Squared Deviation
Raw Score Squares Deviation scores
deviation scores scores
2
2

X Y X Y ̅ ̅ ( ̅ ̅ ̅ ̅
2 2 4 4 -2.95 -3.5 10.33 8.70 12.25
2 1 4 1 -2.95 -4.5 13.28 8.70 20.25
1 1 1 1 -3.95 -4.5 17.78 15.60 20.25
1 1 1 1 -3.95 -4.5 17.78 15.60 20.25
3 5 9 25 -1.95 -0.5 0.98 3.80 0.25
4 4 16 16 -0.95 -1.5 1.43 0.90 2.25
5 7 25 49 0.05 1.5 0.07 0.00 2.25
5 6 25 36 0.05 0.5 0.02 0.00 0.25
7 7 49 49 2.05 1.5 3.08 4.20 2.25
6 8 36 64 1.05 2.5 2.63 1.10 6.25
4 3 16 9 -0.95 -2.5 2.38 0.90 6.25
3 3 9 9 -1.95 -2.5 4.88 3.80 6.25
6 6 36 36 1.05 0.5 0.53 1.10 0.25
6 6 36 36 1.05 0.5 0.53 1.10 0.25
8 10 64 100 3.05 4.5 13.73 9.30 20.25
9 9 81 81 4.05 3.5 14.18 16.40 12.25
10 6 100 36 5.05 0.5 2.53 25.50 0.25
9 6 81 36 4.05 0.5 2.03 16.40 0.25
4 9 16 81 -0.95 3.5 -3.33 0.90 12.25
4 10 16 100 -0.95 4.5 -4.28 0.90 20.25
2
2
2
2
∑X=99 ∑Y=110 ∑X =625 ∑Y =770 ∑xy= 100.5 ∑x = 134.95 ∑y =165
Means:

The Theory and Applications of Statistical Inferences 109