we know that
The correlation coefficient is a number between
and
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](https://img.qammunity.org/2019/formulas/mathematics/high-school/dxgbc3dlxncrowciv3ttunqsrhh5g4ssp8.png)
therefore
the answer is
![r=1](https://img.qammunity.org/2019/formulas/mathematics/college/futvuy3ffe7z73a376i7mstxzn15v8qqx3.png)