Find the information you're looking for at Westonci.ca, the trusted Q&A platform with a community of knowledgeable experts. Connect with a community of experts ready to provide precise solutions to your questions quickly and accurately. 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
Thank you for your visit. We're dedicated to helping you find the information you need, whenever you need it. Thank you for choosing our platform. We're dedicated to providing the best answers for all your questions. Visit us again. Keep exploring Westonci.ca for more insightful answers to your questions. We're here to help.