The following sample observations were randomly selected. 3 6. 3 4 4 6. 13 15 7 12 13 11 9. 5 Click here for the Excel Data File Determine the coefficient of correlation and the coefficient of...

The following sample observations were randomly selected.

Determine the coefficient of correlation and the coefficient of determination. Interpret the association between x and y. (Round your coefficient of determination to 4 decimal places. Round all other answers to 2 decimal places. Negative amounts should be indicated by a minus sign.)

PS
Please explain step by step with math formulas and provide also solutions with Excel formulas and Minitab instructions.

Extracted text: The following sample observations were randomly selected. 3 6. 3 4 4 6. 13 15 7 12 13 11 9. 5 Click here for the Excel Data File Determine the coefficient of correlation and the coefficient of determination. Interpret the association between x and y. (Round your coefficient of determination to 4 decimal places. Round all other answers to 2 decimal places. Negative amounts should be indicated by a minus sign.) y - y (y – y)² (x – 1) (y – 9) 13 2.38 0.02 5.64 0.30 3 3 15 4.38 3.52 19.14 6. 7 1.13 1.27 13.14 -4.08 3 3 12 -1.88 3.52 1.89 4 13 -0.88 2.38 5.64 -2.08 4 11 -0.88 0.38 0.14 -0.33 6 9. 1.13 -1.63 1.27 8 3.13 -5.63 9.77 -17.58 39 85 Total Sx Sy = The correlation coefficient of indicates a (Click to select) relationship between x and y. The coefficient of determination is found by squaring the value of • x accounts for * of the variation in y.