What is 'RSquared'
Rsquared is a statistical measure that represents the proportion of the variance for a dependent variable that's explained by an independent variable. In investing, Rsquared is generally considered the percentage of a fund or security's movements that can be explained by movements in a benchmark index.
For example, an Rsquared for a fixedincome security versus a bond index identifies the security's proportion of price movement that is predictable based on a price movement of the index. The same can be applied to a stock versus the S&P 500 index, or any other relevant index.
BREAKING DOWN 'RSquared'
Rsquared values range from 0 to 1 and are commonly stated as percentages from 0% to 100%. An Rsquared of 100% means all movements of a security (dependent variable) are completely explained by movements in the index (independent variable). A high Rsquared, between 85% and 100%, indicates the stock or fund's performance moves relatively in line with the index. A fund with a low Rsquared, at 70% or less, indicates the security does not generally follow the movements of the index. A higher Rsquared value will indicate a more useful beta figure. For example, if a stock or fund has an Rsquared value of close to 100%, but has a beta below 1, it is most likely offering higher riskadjusted returns.
Rsquared Calculation Example
The actual Rsquared equation is calculated as:
RSquared = 1  (Explained Variation / Total Variation)
However, the actual calculation requires several steps. This includes taking the data points of dependent and independent variables and finding the line of best fit. From there you would calculate predicted values, subtract actual values and square the results. This yields a list of errors squared, which is then summed and equals the explained variance.
To calculate the total variance, you would subtract the average actual value from the predicted values, square the results and sum them. From there, divide the first sum of errors (explained variance) by the second sum (total variance), subtract the result from one, and you have the Rsquared.
RSquared Limitations and Interpretations
Rsquared will give you an estimate of the relationship between movements of a dependent variable based on an independent variable's movements. It doesn't tell you whether your chosen model is good or bad, nor will it tell you whether the data and predictions are biased. A high or low Rsquare isn't necessarily good or bad, as it doesn't convey the reliability of the model, nor whether you've chosen the right regression. You can get a low Rsquared for a good model, or a high Rsquare for a poorly fitted model, and vice versa.

Coefficient of Determination
The coefficient of determination is a measure used in statistical ... 
Risk Measures
Risk measures give investors an idea of the volatility of a fund ... 
Index Hugger
An index hugger is a managed mutual fund that tends to perform ... 
Beta
Beta is a measure of the volatility, or systematic risk, of a ... 
Multiple Linear Regression  MLR
Multiple linear regression (MLR) is a statistical technique that ... 
Variable Overhead Spending Variance
Variable overhead spending variance is the difference between ...

Financial Advisor
Calculating Beta: Portfolio Math For The Average Investor
Beta is a useful tool for calculating risk, but the formulas provided online aren't specific to you. Learn how to make your own. 
Investing
How Investment Risk Is Quantified
FInancial advisors and wealth management firms use a variety of tools based in modern portfolio theory to quantify investment risk. 
Investing
Dodge & Cox's High Quality Bonds Mutual Funds (DODIX)
Learn about the risk metrics of the DODIX Fund. Discover what standard deviation, capture ratios and Rsquared indicate about systematic risk and volatility. 
Investing
VGHCX: Vanguard Health Care Fund Risk Statistics Case Study
Discover one of the largest health carefocused mutual funds, and learn about the fund's historical values for seven key risk measures. 
Investing
Vanguard Mutual Fund With 65% Equity & 35% Bonds (VWELX)
Explore several risk metrics of VWELX. Learn what beta, Rsquared, capture ratios and standard deviation say about volatility and systematic risk for VWELX. 
Investing
ETF Tracking Errors: Protect Your Returns
Tracking errors tend to be small, but they can still adversely affect your returns. Learn how to protect against them. 
Investing
FKINX: A Risk Statistics Case Study
Examine important risk metrics for mutual fund FKINX. Discover what beta, standard deviation and Rsquared say about volatility and systematic risk. 
Investing
Mutual Fund That Seeks Long Term Principal and Income (DODGX)
Review a volatility and modern portfolio theory statistics case study of the Dodge & Cox Stock Fund, and consider whether it suits your investment profile. 
Investing
DXD vs. DDM: Comparing Leveraged Dow Jones Equity ETFs
Discover two exchangetraded funds that give leveraged exposure to Dow Jones equity, and see a comparison of their structures, risk and return characteristics. 
Investing
3 Best DividendPaying Australian Equity Mutual Funds
Discover analyses of the top dividendpaying Australian equity mutual funds, and learn about the characteristics and historical performances of the funds.

How do you calculate Rsquared in Excel?
Calculate Rsquared in Microsoft Excel by creating two data ranges to correlate. Use the correlation formula to correlate ... Read Answer >> 
What's the relationship between Rsquared and beta?
Learn about the relationship between Rsquared and beta. Explore how the concepts are related and often used in conjunction ... Read Answer >> 
Is variance good or bad for stock investors?
Learn how high variance stocks are good for some investors and how diversified portfolios can reduce variance without compromising ... Read Answer >> 
What is price variance in cost accounting?
Understand what price variance is in relation to cost accounting. Learn the most common way price variance arises and how ... Read Answer >> 
How can I create a linear regression in Excel?
Learn the steps involved in creating a linear regression chart in Microsoft Excel. A linear regression is a data plot that ... Read Answer >>