Please kindly provide clean and detailed solution to the following 5 problems. (Kindly Note Question 3 & 4 are together in Picture 3)

1. Calculate the rank correlation coefficient from the following data Z 78 89 97 69 59 79 68 W 125 137 156 112 107 136 1242. If covariance between P and Q is 12.3 and the variance of P and Q are 16.4 and 13.8 respectively. Find the coefficient of correlation between them3. The equation of the regression line for the paired data below is y = 6.18286 + 4.33937x . Find the explained and unexplained variation X 9 7 2 3 4 22 17 Y 43 35 16 21 23 102 81 4. A regression equation is obtained for a collection of paired data. It is found that the total variation is 20.711, the explained variation is 18.592 and the unexplained variation is 2.119. Find the coefficient of determination and interpret the result5. Use the given data below to find the equation of regression line X 6 8 20 28 36 Y 2 4 13 20 30