Solveeit Logo

Question

Question: Calculate the coefficient of correlation between \(x\) and \(y\) for the data x| 1| 2| 3| 4| 5| ...

Calculate the coefficient of correlation between xx and yy for the data

x12345678910
y31051294876

A) 0.12
B) 0.19
C) 0.22
D) 0.62

Explanation

Solution

To calculate the coefficient to correlation, we will be using Karl Pearson’s coefficient of correlation which is given by rxy=nxiyixiyinxi2(xi)2nyi2(yi)2{r_{xy}} = \dfrac{{n\sum {{x_i}{y_i}} - \sum {{x_i}} \sum {{y_i}} }}{{\sqrt {n\sum {{x_i}^2} - {{\left( {\sum {{x_i}} } \right)}^2}} \sqrt {n\sum {{y_i}^2} - {{\left( {\sum {{y_i}} } \right)}^2}} }}. Since there are ten terms, n=10n = 10. A table is drawn to find the required terms to be substituted in Karl Pearson’s coefficient of correlation equation and do further simplification.

Complete step-by-step answer:
We need to find the correlation coefficient between xx and yy.
Karl Pearson’s coefficient of correlation is given as
rxy=nxiyixiyinxi2(xi)2nyi2(yi)2{r_{xy}} = \dfrac{{n\sum {{x_i}{y_i}} - \sum {{x_i}} \sum {{y_i}} }}{{\sqrt {n\sum {{x_i}^2} - {{\left( {\sum {{x_i}} } \right)}^2}} \sqrt {n\sum {{y_i}^2} - {{\left( {\sum {{y_i}} } \right)}^2}} }}
Where nn is the number of terms.
xi{x_i} is the sum of values of xx.
yi{y_i} is the sum of values of yy.
Now, find the values,

xxyyx2{x^2}y2{y^2}xyxy
13193
210410020
3592515
411614
5225410
69368154
74491628
88646464
97814963
1061003660
xi=55\sum {{x_i}} = 55yi=55\sum {{y_i}} = 55xi2=385\sum {{x_i}^2} = 385yi2=385\sum {{y_i}^2} = 385xiyi=321\sum {{x_i}{y_i}} = 321

Substitute the values in the formula,
rxy=10×32155×5510×385(55)210×385(55)2\Rightarrow {r_{xy}} = \dfrac{{10 \times 321 - 55 \times 55}}{{\sqrt {10 \times 385 - {{\left( {55} \right)}^2}} \sqrt {10 \times 385 - {{\left( {55} \right)}^2}} }}
Simplify the terms,
rxy=3210302538503025×38503025\Rightarrow {r_{xy}} = \dfrac{{3210 - 3025}}{{\sqrt {3850 - 3025} \times \sqrt {3850 - 3025} }}
Subtract the values,
rxy=185825×825\Rightarrow {r_{xy}} = \dfrac{{185}}{{\sqrt {825} \times \sqrt {825} }}
We know that,
a×a=(a)2=a\sqrt a \times \sqrt a = {\left( {\sqrt a } \right)^2} = a
Use this formula in the denominator,
rxy=185825\Rightarrow {r_{xy}} = \dfrac{{185}}{{825}}
Divide numerator by the denominator,
rxy=0.22\therefore {r_{xy}} = 0.22

Hence, option (C) is correct.

Note: The degree of correlation can be determined as follows:
There will be a perfect correlation between two variables if the value of the correlation coefficient is near ±1 \pm 1, that is, as one variable increases, the other variable tends to also increase (if positive) or decrease (if negative).
There will be a high degree of correlation or strong correlation between two variables if the value of the correlation coefficient lies between ±0.5 \pm 0.5 and ±1 \pm 1.
There will be a moderate degree of correlation or medium correlation between two variables if the value of the correlation coefficient lies between ±0.3 \pm 0.3 and ±0.49 \pm 0.49.
There will be a low degree of correlation or a small correlation between two variables if the value of the correlation coefficient lies below ±0.29 \pm 0.29.
There will be no correlation between the two variables if the value of the correlation coefficient is zero.