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 a Excel tool (CORREL function)
see the attached table
the correlation coefficient is [tex]r=1[/tex]
therefore
the answer is
[tex]r=1[/tex]
