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

**R Squared Formula (Table of Contents)**

## What is R Squared Formula in Regression?

R-squared (R^{2}) is an important statistical measure which in a regression model represents the proportion of the difference or variance in statistical terms for a dependent variable which can be explained by an independent variable or variables.

In short, R-squared (also called a Coefficient of determination) determines how well data will fit the regression model. For the calculation of R squared you need to determine Correlation coefficient and then you need to square the result.

**R Squared Formula = r ^{2}**

Where r the correlation coefficient can be calculated per below:

Where,

- r = The Correlation coefficient
- n = number in the given dataset
- x = first variable in the context
- y = second variable

### Explanation of the R Squared formula in Regression

If there is any relationship or correlation which may be linear or non-linear between those two variables then it shall indicate if there is a change in the independent variable in value, then the other dependent variable will likely change in value say linearly or non-linearly.

The numerator part of the formula conducts a test whether they move together and removes their individual movements and relative strength of both of them moving together and the denominator part of the formula scales the numerator by taking the square root of the product of the differences of the variables from their squared variables. And when you squared this result we get R squared which is nothing but the coefficient of determination.

### R Squared Formula Examples (with Excel Template)

Let’s see some simple to advanced examples of R Squared equation in Regression.

#### Example #1

Consider the following two variables x and y, you are required to calculate the R Squared in Regression.

**Solution:**

Using the above-mentioned formula, we need to first calculate the correlation coefficient.

We have all the values in the above table with n = 4.

Let’s now input the values in the formula to arrive at the figure.

4.9 (927 ratings)

r = ( 4 * 26,046.25 ) – ( 265.18 * 326.89 )/ √ [(4 * 21,274.94) – (326.89)^{2}] * [(4 * 31,901.89) – (326.89)^{2}]

r = 17,501.06 / 17,512.88

**Correlation Coefficient will be-**

r = 0.99932480

So, the calculation of R Squared equation will be as follows,

r^{2 }= (0.99932480)^{2}

**R Squared Formula in Regression**

r^{2} = 0.998650052

#### Example #2

India a developing country wants to conduct an independent analysis whether changes in crude oil prices have affected its rupee value. Following is the history of Brent crude oil price and Rupee valuation both against dollars that prevailed on an average for those years per below.

RBI the central bank of India has approached you to provide a presentation on the same in the next meeting. Determine whether the movements in crude oil affects movements in Rupee per dollar?

**Solution:**

Using the formula for correlation above, we can calculate the correlation coefficient first. Treating average crude oil price as one variable say x and treating Rupee per dollar as another variable as y.

We have all the values in the above table with n = 6.

Let’s now input the values in the formula to arrive at the figure.

r = (6 * 23592.83) – (356.70 * 398.59) / √ [(6 * 22829.36) – (356.70)^{2}] * [(6 * 26529.38) – (398.59)^{2}]

r = -620.06 / 1,715.95

**Correlation Coefficient will be-**

** **

r = -0.3614

So, the calculation of R Squared equation will be as follows,

r^{2 }= (-0.3614)^{2}

**R Squared Formula in Regression**

r^{2 }= 0.1306

**Analysis:** It appears that there is a minor relationship between changes in crude oil prices and changes in the price of the Indian rupee. As Crude oil price increases, the changes in Indian rupee also affects. But since R squared is only 13% then the changes in crude oil price explains very less about changes in Indian rupee and the Indian rupee is subject to changes in other variables as well which needs to be accounted for.

#### Example #3

XYZ laboratory is conducting research on height and weight and is interested in knowing if there is any kind of relationship between these variables. After gathering a sample of 5000 people for every category and came up with an average weight and average height in that particular group.

Below are the details that they have gathered.

You are required to calculate R Squared and conclude if this model explains the variances in height affects variances in weight.

**Solution:**

Using the formula for correlation above, we can calculate the correlation coefficient first. Treating height as one variable say x and treating weight as another variable as y.

We have all the values in the above table with n = 6.

Let’s now input the values in the formula to arrive at the figure.

r = ( 7 * 74,058.67 ) – (1031 * 496.44) / √[(7 * 153595 – (1031)^{2}] * [(7 * 35793.59) – (496.44)^{2}]

r = 6,581.05 / 7,075.77

**Correlation Coefficient will be-**

** **

Correlation Coefficient (r) = 0.9301

So, the calculation of R Squared equation will be as follows,

r^{2 }= 0.8651

**Analysis:** The correlation is positive, and it appears there is some relationship between height and weight as the height increases the weight of the person also appears to be increased. While R2 suggests that 86% of changes in height attributes to changes in weight and 14% are unexplained.

### Relevance and Uses

The Relevance of R squared in Regression is its ability to find the probability of future events occurring within the given predicted results or the outcomes. If more samples are added to the model, then the coefficient would show the likelihood or the probability of a new point or the new dataset falling on the line. Even if both the variables have a strong connection, the determination does not prove causality.

Some of the spaces where R squared is mostly used is for tracking mutual fund performance, for tracking risk in hedge funds, to determine how well is stock moving with the market, where R2 would suggest how much of the movements in the stock can be explained by the movements in the market.

### Recommended Articles

This has been a guide to R Squared Formula in Regression. Here we learn how to calculate R Square using its formula along with examples and downloadable excel template. You can learn more about financial analysis from the following articles –

- Relative Change
- Adjusted R Squared
- Examples of Correlation Formula
- Top 10 Most Important Types of Financial Analysis
- Top 15 Financial Analysis Techniques
- Top 4 Financial Analysis Tools
- Regression Formula
- Regression vs ANOVA
- Excel Dashboard Training
- CORREL Function in Excel

- 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