Financial Modeling Tutorials

- 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
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- 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
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- 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)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- 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
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- 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
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

**Coefficient of Determination (Table of Contents)**

## What is the Coefficient of Determination?

Coefficient of determination (also known as R Squared) determines the extent of the variance of the dependent variable which can be explained by the independent variable. By looking at R^2 value one can judge whether the regression equation is good enough to be used. Higher the coefficient better the regression equation as it implies that the independent variable chosen in order to determine the dependent variable is chosen properly.

The formula to calculate the coefficient of determination of a regression equation is

Where

- R= Correlation
- R^2= Coefficient of determination of the regression equation
- N= Number of observations in the regression equation
- Xi= Independent variable of the regression equation
- X= Mean of the independent variable of the regression equation
- Yi= Dependent variable of the regression equation
- Y= Mean of the dependent variable of the regression equation
- σx = Standard deviation of the independent variable
- σy = Standard deviation of the dependent variable

The value of the coefficient ranges from 0 to 1, where a value of 0 indicates that the independent variable does not explain the variation of the dependent variable and a value of 1 indicates that the independent variable perfectly explains the variation in the dependent variable.

### Examples of Coefficient of Determination Formula (with Excel Template)

Let’s see some simple to advanced examples of the coefficient of determination equation to understand it better.

#### Example #1

Let us try and understand the coefficient of determination formula with the help of an example. Let us try to find out what is the relation between the distance covered by the truck driver and the age of the truck driver. Someone actually does regression equation to validate whether what he thinks of the relationship between two variables, is also validated by the regression equation. In this particular example, we will see which variable is the dependent variable and which variable is the independent variable.

4.9 (1,067 ratings)

The dependent variable in this regression equation is the distance covered by the truck driver and the independent variable is the age of the truck driver. We can find the correlation with the help of the formula and square that to get the coefficient of the regression equation. The data set and the variables are presented in the excel sheet attached.

**Solution:**

Below is given data for calculation of the coefficient of determination.

Therefore, the calculation of the coefficient of determination formula is as follows,

R = -424520/√(683696*81071100)

R will be –

**R = -0.057020839**

R^2 will be –

**R^2 = 0.325%**

#### Example #2

Let us try and understand the concept of coefficient of determination with the help of another example. Let us try to find out what is the relation between the height of the students of a class and the GPA grade of those students. In this particular example, we will see which variable is the dependent variable and which variable is the independent variable.

The dependent variable in this regression equation is the GPA of the students and the independent variable is the height of the students. We can find the correlation with the help of the formula and square that to get the R^2 of the regression equation. The data set and the variables are presented in the excel sheet attached.

**Solution:**

Below is given data for calculation of the coefficient of determination.

Therefore, the calculation of the coefficient of determination formula is as follows,

R = 34.62/√(169204*3245)

**R = 0.000467045**

**R^2 = 0.000000218**

### Relevance and Uses

Coefficient of determination is a very important output in order to find out whether the data set is a good fit or not. Someone actually does a regression analysis to validate whether what he thinks of the relationship between two variables, is also validated by the regression equation. Higher the coefficient better the regression equation as it implies that the independent variable chosen in order to determine the dependent variable is chosen properly. Ideally, a researcher will look for the coefficient of determination which is closest to 100%.

### Recommended Articles

This has been a Guide to Coefficient of Determination. Here we learn how to calculate the coefficient of determination using its formula with examples and downloadable excel template. You can learn more about financing from the following articles –

- Gini Coefficient
- Formula of Regression Analysis
- Formula of Multiple Regression
- Formula for Coefficient of Variation
- Formula for Correlation Coefficient

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion