Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Correlation Formula – (Table of Contents)**

## What is Correlation Formula?

The correlation formula is a statistical measure between two variables and is defined as the change of quantity in one variable corresponding to change in another. Value of correlation is limited between -1 and +1 and can be interpreted as follows:

**-1:**If it is -1 then variables are known as perfectly negatively correlated. That means if one variable is moving in one direction then another is moving in the opposite direction.**0:**That means variable is not having any correlation.**+1:**If it is +1 then variables are known as perfectly positively correlated. Both variables are moving in positive directions.

If we are having 2 variable x and y then correlation coefficient between 2 variables can be found as:

**Correlation Coefficient formula = ∑(x(i)- mean(x)).(y(i)-mean(y))/√ ∑(x(i)-mean(x)) ^**

^{2}∑(y(i)-mean(y))^^{2}Where,

- x(i)= value of x in the sample
- Mean(x) = mean of all values of x
- y(i) = value of y in the sample
- Mean(y) = mean of all values of y

### Examples of Correlation Formula (with Excel Template)

Let’s see some simple to advanced examples of correlation equation to understand it better.

It is very easy to calculate the correlation in Microsoft Excel. Syntax of the function used is as follows:

Correlation Coefficient = CORREL (array1, array2)

#### Example#1

**Let’s take the same example that we have taken above for calculating correlation using excel.**

**Solution:**

Below are the values of x and y:

The calculation of the correlation coefficient is as follows,

Basis excel formula = CORREL (array(x), array(y))

**Coefficient = +0.95**

Since this coefficient is near to +1, hence x and y are highly positively correlated.

4.9 (927 ratings)

#### Example#2** **

**Correlation formula is mainly useful for analyzing the stock price of companies and creating a stock portfolio based on that.**

**Let us find out the correlation of Apple stock with Nasdaq index based on last one-year stock performance. Apple is an US-based multinational company which is specialized in IT products such as iPod, iPad, Mac, etc.**

**Solution:**

Below is the monthly return of Apple and Nasdaq stocks for the last 1 year:

Let’s now input the values in the formula for the calculation of correlation.

Correlation Coefficient = ∑(x(i)- mean(x)).(y(i)-mean(y))/√ ∑(x(i)-mean(x)) ^^{2} ∑(y(i)-mean(y))^^{2}

Correlation between Apple and Nasdaq= 0.039/ (√0.0039)

**Coefficient =0.62**

Since the Correlation between Apple and Nasdaq is positive hence Apple is positively correlated with Nasdaq.

#### Example#3

**Let us now look upon the correlation between Walmart and Nasdaq index based on last one-year stock performance. Walmart is a US based company which is having a retail supermarket chain.**

**Solution:**

Below is the monthly performance between Walmart and Nasdaq for last one year-

Let’s now input the values in the formula for the calculation of correlation.

Correlation Coefficient = ∑(x(i)- mean(x)).(y(i)-mean(y))/√ ∑(x(i)-mean(x)) ^^{2} ∑(y(i)-mean(y))^^{2}

Therefore, the calculation of the correlation is as follows,

Correlation between Walmart and Nasdaq= 0.0032/ (√0.0346*0.0219 )

**Coefficient =0.12**

We can see that Walmart and Nasdaq are also positively correlated but not as much compared to Apple correlation with Nasdaq.

### Relevance and Uses of Correlation Formula

A correlation coefficient is useful in establishing the linear relationship between two variables. It measures how a variable will move compared to the movement of another variable. Practical use of this coefficient is to find out the relationship between stock price movement with the overall market movement. Basis of this analysis, a stock analyst will include the proportion of stocks to create an optimal portfolio with minimum risk. Also, it is useful in data science to find out the relationship between 2 variables.

Also, the correlation coefficient is used very highly for studying the construct validity of data in factor analysis. It is highly used in regression analysis to predict the values of dependent variables based on the relationship between dependent and independent variables. Correlation equation is quite useful in quantitative analysis to get the nature of the relationship between various variables. The basis on this relationship, if a variable is unrelated to other variables then it can be eliminated from the list.

You can download this Correlation Formula Excel Template from here – Correlation Formula Excel Template

### Recommended Articles

This has been a guide to Correlation Formula. Here we discuss how to calculate correlation using its formula along with examples and downloadable excel template. You can learn more about financing from the following articles –

- Step to Calculate the Gini Coefficient
- Adjusted R Squared Formula
- Formula of R Squared
- Correlation vs Covariance – Compare
- Correlation Matrix Excel
- Formula of Coefficient of Variation

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply