we know that
The correlation coefficient is a number between -1 and +1 that represent the linear dependence of two variables or sets of data
Using the function CORREL in a excel tool, calculate the correlation coefficient (r)
see the attached table
the correlation coefficient for the data in the table is equal to 1
therefore
the answer is
r=1
