Answer to Question #213096 in Statistics and Probability for Love

Question

Compute and interpret r for the 19 following data given

1.x=1,3,6,10,12

y=5,13,25,41,49

2.x=1,3,5,7,9

y=44,34,24,14,4

3.x=1,3,6,9,11

y=12,28,37,28,12

Answer 1

By Excel function =CORREL()

1. r = 1

A correlation coefficient of +1 indicates a perfect positive correlation. As variable x increases, variable y increases.

2. r= -1

A correlation of –1 means the data are lined up in a perfect straight line, the strongest negative linear relationship you can get.

3. r=0

A correlation of 0 indicates no linear relationship between variables.