The use of the excel tool given in the image above will give you the correlation coefficient of r for the data set is as r=-0.96
What is the correlation coefficient about?
Note that one have to find first, the mean of all of your the x-values, and then one can find the mean of all of the y-values.
Note that one can use the excel to find the mean which will be 28.4 and 214.6 for both.
The next step is to find the standard deviation for x and y. Then, you have to put it into the formula that is given for the correlation coefficient."
When you use the excel, R will be -0.9647 and when you round up to the nearest hundredth, the answer will be -0.96.
Learn more about Excel from
https://brainly.com/question/25879801
#SPJ1
