Question 7 options 1 The correlation is 0271 There is a str
Question 7 options:
| |||
| |||
| |||
| |||
|
Solution
Enter the given data in a Excel sheet into two columns and use the Excel function CORREL (array1, array2) to find the correlation between two set of data.
Here array1 will refer to the column of temperature and array2 will refer to the column of passengers. Therefore,
CORREL (array1, array2) = - 0.271
This implies, that the correlation is -0.271 .
The value of correlation lies between -1 and +1.
The correlation of -1 refers to negative relation between two variables, the more it is close to -1, stronger is the negative association between two variables.
The correlation of +1 refers to positive relation between two variables, the more it is close to +1, stronger is the positive association between two variables.
And the correlation of zero says that there exists no association between two variables.
Therefore, the right answer is,
2). The correlation is -0.271 . There is a weak negative linear association between temperature and passengers .
