Which of the following represent the Excel function to be used when computing correlation coefficients?
A) CORREL(A:10; B:10)
B) CORREL(A:1-10; B:1-10)
C) CORREL(A1:A10; B1:B10)
D) CORREL(A10:B10)

Question

Quizplus · Accepted Answer

The CORREL function in Excel requires two ranges of data to compute the correlation coefficient. Option A and D are incorrect because they do not specify the range of data, and Option B uses a colon instead of a comma to separate the ranges. Option C correctly specifies the ranges A1:A10 and B1:B10 to compute the correlation coefficient.

Which of the Following Represent the Excel Function to Be