Explore Westonci.ca, the top Q&A platform where your questions are answered by professionals and enthusiasts alike. Discover in-depth solutions to your questions from a wide range of experts on our user-friendly Q&A platform. Get immediate and reliable solutions to your questions from a community of experienced professionals on our platform.
Sagot :
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
We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. We hope you found this helpful. Feel free to come back anytime for more accurate answers and updated information. We're dedicated to helping you find the answers you need at Westonci.ca. Don't hesitate to return for more.