we know that
The correlation coefficient is a number between [tex]-1[/tex] and [tex]+1[/tex] 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 [tex]1[/tex]
therefore
the answer is
[tex]r=1[/tex]
