QUESTION 03 (20 points) Coefficient of Correlation (a)[10] We have the following hypothetical data for x and y: Obs. X2 Xy 3.57 4.63 6.05 8.22 9.84 9.36 TOTAL Manually draw a scatter diagram of the data with y on the vertical axis. Fill in the table above. Use 5 decimals throughout your calculations if applicable: Give an equation for the correlation coefficient of x and Y, which is denoted as r(x,y). Calculate r(x,y): Interpret and comment on r(x,y). Use CORREL(*, to check your result (b)[10] We have the following hypothetical data for p and g: Obs. p2 pq 5.67 7.22 2.89 1.37 9.16 1.53 TOTAL Manually draw a scatter diagram of the data with q on the vertical axis. Fill in the table above. Use 5 decimals throughout your calculations if applicable: Give an equation for the correlation coefficient of p and q, which is denoted as r(p,q). Calculate r(p,q): Interpret and comment on r(p,q). Use CORREL(*,*) to check your result.