Question

x 1 3 5 7 9

y 143 116 100 98 90

 

What is the correlation coefficient for the data set (rounded to two decimal places)?

• A. 6,20
• B. 1,00
• C. 0,00
• D. –0,93
• E. –0,62

Answer 1

The given problem can be solved using CORREL function in excel.

CORREL function computes correlation between two data sets.

Correct answer - D