Question

A doctor wanted to determine whether there is a relation between a​ male's age and his HDL​ (so-called good) cholesterol. The doctor randomly selected 17 of his patients and determined their HDL cholesterol. The data obtained by the doctor is the in the data table below.

Age_-_x   HDL_Cholesterol_-_y
39   55
42   52
48   36
31   57
54   36
51   41
61   41
63   36
27   47
36   46
65   62
28   51
53   37
27   47
54   40
49   54
37   30

​(a) Draw a scatter diagram of the​ data, treating age as the explanatory variable. What type of​ relation, if​ any, appears to exist between age and HDL​ cholesterol?

A.

There does not appear to be a relation.

B.

The relation appears to be nonlinear.

C.

The relation appears to be linear.

Answer 1

Bring data in to excel. Go to insert tab and choose scatter diagram.

The relation appears to be linear.

and find correlation coefficient to find the relationship

-0.2 is the correlation between Age and Cholesterol .

So - 0.2 is the weak relation

Age_-_x	HDL_Cholesterol_-_y
39	55
42	52		Correlation	-0.2
48	36
31	57
54	36
51	41
61	41
63	36
27	47
36	46
65	62
28	51
53	37
27	47
54	40
49	54
37	30

Correlation formula : "=CORREL(A2:A18,B2:B18)"