help me to solve this..
(i)Calculate coefficient of correlation, using Excel function, for the above data.
What type of relationship is found between the variables X and Y?
(ii) Construct a Scatter diagram for the above Data.
(iii) Now subtract 10 from values of X and divide by 5.Also subtracts 4from values of Y and divide by 2.
Now again calculate coefficient of correlation .And give reason why answer do or do not match.