step 1
find the values of x and y
x y
1 3
2 3
3 4
2 5
3 6
4 7
5 8
5 9
6 11
6 12
7 12
7 14
8 14
using a excel tool
see the attached table
the correlation coefficient r is equal to 0.97
the answer is
the most appropriate correlation coefficient for the scatter plot is 0.95
