Question

Use a scatterplot and the linear correlation coefficient r to determine whether there is a correlation between the two variables. Use alphaequals0.05. x 2 4 7 1 6 y 5 8 12 3 11 Click here to view a table of critical values for the correlation coefficient. LOADING... Does the given scatterplot suggest that there is a linear​ correlation? A. ​Yes, because the data does not follow a straight line. B. ​No, because the data follows a straight line. C. Yes comma because the points appear to have a straight line pattern. D. No comma because the points do not appear to have a straight line pattern. 0 4 8 12 0 4 8 12 x y x y graph Does the correlation coefficient indicate that there is a linear correlation between the​ variables? A. ​Yes, because the absolute value of the correlation coefficient is less than the critical value. B. Yes comma because the absolute value of the correlation coefficient is greater than the critical value. C. No comma because the absolute value of the correlation coefficient is less than the critical value. D. ​No, because the absolute value of the correlation coefficient is greater than the critical value. Click to select your answer.

Answer 1

(A) copy and paste the data in excel sheet

then select the data set and click on insert

then select scatter plot

we get

Data represents a straight line, so option C

(B) using excel function CORREL

select x values as array 1 and y values as array2

we get

r = CORREL(x values, y values)

= 0.9974

critical r = 0.878 (using table)

so,we can see that r calculated is greater than r critical. This means that the correlation is significant

option B