Pearson's Correlation Coefficient Formula Explained - Excel Template

I developed an excel template that calculates Pearson's correlation coefficient. It contains the coefficient equation and steps for determining the equation. This spreadsheet can handle up to 10,000 cases.

Download link : Pearson Correlation Coefficient

Meaning :

The Pearson's Correlation Coefficient is used to determine whether there is a significant linear relationship or association between two variables.

Examples :
  1. Are years of education completed related to income?
  2. Is motivational level related to achievement?
  3. Is employee satisfaction related to profit?
  4. Is employee attrition related to employees salary?

Assumptions :
  1. The variables must be either interval or ratio measurements
  2. There is a linear relationship between the two variables
  3. The variables must be approximately normally distributed

Interpretation :

It indicates whether or not a significant linear relationship exists between two variables. 
It is denoted by r . It can take a range of values from +1 to -1. 

Strength of Association Positive Negative
Low 0.1 to 0.3 -0.1 to –0.3
Moderate 0.3 to 0.5 -0.3 to –0.5
High 0.5 to 1 -0.5 to -1

1. A value of 0 indicates that there is no association between the two variables.

2. A value greater than 0 indicates a positive association; that is, as the value of one variable increases, so does the value of the other variable. 

3. A value less than 0 indicates a negative association; that is, as the value of one variable increases, the value of the other variable decreases.

Important Points :


1. The two variables can be measured in entirely different units.
2.  It does not mean that for every unit increase in one variable there is a unit increase in another.
3.  It does not indicate what kind of relationship it is.

The relationship can be of any of the following types :

1. Causal relationship : Two variables do indeed affect each other.
2. Spurious relationship Statistical relation is caused by a third variable.

Coursera Data Science
Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

0 Response to "Pearson's Correlation Coefficient Formula Explained - Excel Template"

Post a Comment

Next → ← Prev