All Exams Test series for 1 year @ ₹349 only
Question

Calculate the correlation coefficient between the following values :

x: 3, 5, 1, 7, 5

y: 4, 3, 0, 8, 2

The correct answer is

0.8

Correlation Coefficient: Understanding the Basics

The correlation coefficient is a statistical measure that quantifies the strength and direction of a linear relationship between two variables. It is often denoted by '$r$' and ranges from -1 to +1.

  • A value close to +1 indicates a strong positive linear relationship (as one variable increases, the other tends to increase).
  • A value close to -1 indicates a strong negative linear relationship (as one variable increases, the other tends to decrease).
  • A value close to 0 indicates a weak or no linear relationship.

Pearson Correlation Coefficient Formula

For calculating the correlation coefficient between two sets of values, say X and Y, we typically use Pearson's product-moment correlation coefficient. The formula for Pearson's $r$ is given by:

$$r = \frac{n\sum XY - (\sum X)(\sum Y)}{\sqrt{[n\sum X^2 - (\sum X)^2][n\sum Y^2 - (\sum Y)^2]}}$$

Where:

  • $n$ is the number of data points.
  • $\sum X$ is the sum of all X values.
  • $\sum Y$ is the sum of all Y values.
  • $\sum XY$ is the sum of the products of corresponding X and Y values.
  • $\sum X^2$ is the sum of the squares of all X values.
  • $\sum Y^2$ is the sum of the squares of all Y values.

Data Preparation and Summation for Correlation

Let's list the given values for X and Y and perform the necessary preliminary calculations. We are provided with the following data points:

  • X: 3, 5, 1, 7, 5
  • Y: 4, 3, 0, 8, 2

The number of data points, $n$, is 5. To use the formula, we need to calculate $\sum X$, $\sum Y$, $\sum XY$, $\sum X^2$, and $\sum Y^2$. We can organize these calculations in a table:

X Y XY $X^2$ $Y^2$
3 4 $3 \times 4 = 12$ $3^2 = 9$ $4^2 = 16$
5 3 $5 \times 3 = 15$ $5^2 = 25$ $3^2 = 9$
1 0 $1 \times 0 = 0$ $1^2 = 1$ $0^2 = 0$
7 8 $7 \times 8 = 56$ $7^2 = 49$ $8^2 = 64$
5 2 $5 \times 2 = 10$ $5^2 = 25$ $2^2 = 4$
$\sum X = 21$ $\sum Y = 17$ $\sum XY = 93$ $\sum X^2 = 109$ $\sum Y^2 = 93$

From the table, we have the following sums:

  • $\sum X = 21$
  • $\sum Y = 17$
  • $\sum XY = 93$
  • $\sum X^2 = 109$
  • $\sum Y^2 = 93$

Calculating the Correlation Coefficient

Now, we will substitute these values into the Pearson correlation coefficient formula:

$$r = \frac{n\sum XY - (\sum X)(\sum Y)}{\sqrt{[n\sum X^2 - (\sum X)^2][n\sum Y^2 - (\sum Y)^2]}}$$

Step 1: Calculate the Numerator

The numerator of the formula is $n\sum XY - (\sum X)(\sum Y)$.

$$ \text{Numerator} = (5 \times 93) - (21 \times 17) $$ $$ \text{Numerator} = 465 - 357 $$ $$ \text{Numerator} = 108 $$

Step 2: Calculate the Denominator's First Part ($X$ values)

The first part under the square root in the denominator is $n\sum X^2 - (\sum X)^2$.

$$ \text{Denominator Part 1} = (5 \times 109) - (21)^2 $$ $$ \text{Denominator Part 1} = 545 - 441 $$ $$ \text{Denominator Part 1} = 104 $$

Step 3: Calculate the Denominator's Second Part ($Y$ values)

The second part under the square root in the denominator is $n\sum Y^2 - (\sum Y)^2$.

$$ \text{Denominator Part 2} = (5 \times 93) - (17)^2 $$ $$ \text{Denominator Part 2} = 465 - 289 $$ $$ \text{Denominator Part 2} = 176 $$

Step 4: Calculate the Full Denominator

Now, multiply the two parts of the denominator and take the square root:

$$ \text{Denominator} = \sqrt{\text{Denominator Part 1} \times \text{Denominator Part 2}} $$ $$ \text{Denominator} = \sqrt{104 \times 176} $$ $$ \text{Denominator} = \sqrt{18224} $$ $$ \text{Denominator} \approx 134.996296 $$

Step 5: Calculate the Correlation Coefficient ($r$)

Finally, divide the numerator by the denominator:

$$ r = \frac{108}{134.996296} $$ $$ r \approx 0.8000207 $$

Rounding to one decimal place, the correlation coefficient is approximately 0.8.

Was this answer helpful?

Important Questions from Correlation Analysis

  1. Given below are two statements: One is labelled as Assertion (A) and the other is labelled as Reason (R).

    Assertion (A): If the securities with less than perfect negative correlation between their price movements are combined, portfolio risk can be reduced significantly.

    Reason (R): The term with negative correlation has the effect of reducing the computed value of total portfolio risk, given other terms that are positive.

    In the light of the above statements, choose the most appropriate answer from the options given below:

  2. X, Y and Z are three uncorrelated variables having variances \(\sigma_x^2, \sigma_y^2 \:and\:\sigma_z^2\) respectively, then the correlation between X + Y and Y + Z is:

  3. If X ∼ N (0, 1) and Y = X2 then the correlation coefficient r (X, Y) is

  4. Consider two exponentially distributed random variables X and Y, both having a mean of 0.50. Let Z = X + Y and r be the correlation coefficient between X and Y. If the variance of Z equals 0, then the value of r is _______ (round off to 2 decimal places).

  5. The two-regression equation of variable \(\rm{x}\) and \(\rm{y}\)  are

    \(\rm{y = 0.8x + 9.8}\) and \(\rm{x = 10.2 + 0.6y}\)

    The coefficient of correlation between \(\rm{x}\) and \(\rm{y}\) is

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App