In order to compute the regression coefficients, the following table needs to be used:
Sum=X1820252790Y865221XY14412012554443X23244006257292078Y26436254129
Xˉ=n1i∑Xi=490=22.5
Yˉ=n1i∑Yi=421=5.25
SSXX=i∑Xi2−n1(i∑Xi)2=2078−4902=53
SSYY=i∑Yi2−n1(i∑Yi)2=129−4(21)2=18.75
SSXY=i∑XiYi−n1(i∑Xi)(i∑Yi)=443−490(21)=−29.5
r=SSXXSSYYSSXY=53(18.75)−29.5
=−0.9358
Strong negative correlation
Comments