# What is Variance?

Robinhood Learn
Democratize Finance For All. Our writers’ work has appeared in The Wall Street Journal, Forbes, the Chicago Tribune, Quartz, the San Francisco Chronicle, and more.
Definition:

Variance refers to the degree to which an investment’s returns vary over time –- This metric gives investors an idea of how predictable the performance of an asset may be.

## 🤔 Understanding variance

Variance statistics help investors determine how to allocate their assets in a way that aligns with how they wish to balance risk and potential returns. Volatility is associated with risk, so variance can help you understand what kind of risk an investment involves. Calculating variance gives you a tangible benchmark for asset allocation (how much of each asset you wish to hold). The variance formula looks complex and involves several steps, but it’s not as scary as it seems –- Excel has a function that helps you calculate variance. If you’ve ever taken a statistics class, you may be familiar with variance’s first cousin, the standard deviation. The standard deviation is the square root of the variance.

Example

To calculate variance, we look at the difference between each number in the data set and the mean (average), square the differences, then divide the sum of the squares by the total number of values in our data set.

Let’s look at the fictional company ABC Widget Corp., for example. What is variance with regard to this fictional stock?

To answer this question, we begin with the returns ABC yielded in previous years. Let’s say that during the years spanning 2016 – 2018, ABC saw year-over-year returns of 300%, 400%, and - 40%.

The average of the returns in this data set is 220%. The differences between each return and the average are 80%, 180%, and - 260%. The squares of these deviations equal 6,400, 32,400, and 1,600. The sum of these squared deviations is 40,400. Dividing 40,400 by the number of returns we used (3) arrives at a variance of 13,467.

The square root of the variance yields a standard deviation of 116%. This number suggests that the fictional ABC Widget Corp. is a very volatile stock.

## Takeaway

Variance is like a nutrition label for a financial asset...

Just as a nutritional label might tell you if a product contains things you may or may not wish to eat as part of a balanced diet, variance will tell you something about how risky an asset might be. And just as different people might draw different conclusions from the same nutritional label, based on different goals and preferences, different investors will have different appetites for the level of risk a variance reveals.

New customers need to sign up, get approved, and link their bank account. The cash value of the stock rewards may not be withdrawn for 30 days after the reward is claimed. Stock rewards not claimed within 60 days may expire. See full terms and conditions at rbnhd.co/freestock. Securities trading is offered through Robinhood Financial LLC.

Tell me more…

## Why is variance useful when making investment decisions?

In the investment world, the variance of returns among different assets is used as a factor that helps you figure out the best asset allocation. How do investors make the best choice when figuring out how much of their total portfolio to put into each specific asset they want to own? Variance is one useful measuring stick that can help inform such decisions.

## How is variance used to assess risk?

The higher the average variability of an asset, the higher-risk it is. Assets and securities that are low-risk tend to have lower returns and less variance. Their performance is simpler to predict because there’s less of a chance it’s going to vary from the average.

At the same time, securities that vary from their average a lot can produce higher returns, but can also produce higher losses.

## How to calculate variance using Excel?

Using Microsoft Excel, it’s easy to calculate the sample variance. There are several different formulas, but the best one in most cases for users of Excel 2019 will be =VAR.S(sample data). For example, if the sample data you wanted to use was contained in cells B10 through B20, the formula would be:

=VAR.S(B10:B20)

(Unless you have all the data sets of all time, you’re assessing the variance of an asset-based on a smaller ‘sample’ set of data –- That’s why it’s called ‘sample variance.’)

## How is variance different than standard deviation in risk assessment?

What is the variance in statistics? By itself, the number that you come up with after calculating variance isn’t particularly useful. You’ve figured out how much a data set varies, which is cool, but it’s hard to interpret that one number.

When you take the square root of the variance, however, you arrive at the standard deviation.

This unit gives statisticians (or investors) something they can more easily work with because it’s expressed in the same manner as the data set. From there, it’s possible to figure out how the data points relate to each other.

For example, say you were to calculate the variance of a stock over the last five years. There were some wild swings in price during that time, and you come up with a number like 10,000. What does this mean? It looks like the price of this stock can vary a lot, but that’s a broad generalization that doesn’t give you much to work with.

The square root of the variance (standard deviation) in this fictional example would be 100%. This number is expressed as a percentage, which is the same way the numbers in your data set would be represented (as a percentage of returns).

## What are the drawbacks of using variance?

While sample variance is a way to assess how to best allocate your assets, it’s not a magical panacea. To be effective, this variable needs to be considered against the backdrop of many other market conditions.

Over-reliance on variance can make someone avoid a worthwhile investment or become too invested in another.

Variance also doesn’t take into account fundamental analysis of a given company, incorporating factors like gross profits, earnings per share, price to earnings ratio, and so on.

When you answer the question, “what is variance?”, you aren’t considering the broader market horizon, nor are you examining the more in-depth aspects of a specific company or asset.

The variables that might have contributed to the numbers you’re looking at remain hidden. That’s why investors seldom look to any single metric or calculation when making informed decisions.

New customers need to sign up, get approved, and link their bank account. The cash value of the stock rewards may not be withdrawn for 30 days after the reward is claimed. Stock rewards not claimed within 60 days may expire. See full terms and conditions at rbnhd.co/freestock. Securities trading is offered through Robinhood Financial LLC.

20200408-1144354-3440275

## You May Also Like

PARTICIPATION IS POWER™

This information is educational, and is not an offer to sell or a solicitation of an offer to buy any security. This information is not a recommendation to buy, hold, or sell an investment or financial product, or take any action. This information is neither individualized nor a research report, and must not serve as the basis for any investment decision. All investments involve risk, including the possible loss of capital. Past performance does not guarantee future results or returns. Before making decisions with legal, tax, or accounting effects, you should consult appropriate professionals. Information is from sources deemed reliable on the date of publication, but Robinhood does not guarantee its accuracy.

Options trading entails significant risk and is not appropriate for all customers. Customers must read and understand the Characteristics and Risks of Standardized Options before engaging in any options trading strategies. Options transactions are often complex and may involve the potential of losing the entire investment in a relatively short period of time. Certain complex options strategies carry additional risk, including the potential for losses that may exceed the original investment amount.

Commission-free trading of stocks, ETFs and options refers to \$0 commissions for Robinhood Financial self-directed individual cash or margin brokerage accounts that trade U.S. listed securities and certain OTC securities electronically. Keep in mind, other fees such as trading (non-commission) fees, Gold subscription fees, wire transfer fees, and paper statement fees may apply to your brokerage account. Check out Robinhood Financial’s Fee Schedule for details.

Brokerage services are offered through Robinhood Financial LLC, (RHF) a registered broker dealer (member SIPC) and clearing services through Robinhood Securities, LLC, (RHS) a registered broker dealer (member SIPC). Cryptocurrency services are offered through Robinhood Crypto, LLC (RHC) (NMLS ID: 1702840). Robinhood Crypto is licensed to engage in virtual currency business activity by the New York State Department of Financial Services. The Robinhood spending account is offered through Robinhood Money, LLC (RHY) (NMLS ID: 1990968), a licensed money transmitter. A list of our licenses has more information. The Robinhood Cash Card is a prepaid card issued by Sutton Bank, Member FDIC, pursuant to a license from Mastercard®. Mastercard and the circles design are registered trademarks of Mastercard International Incorporated. RHF, RHY, RHC and RHS are affiliated entities and wholly owned subsidiaries of Robinhood Markets, Inc. RHF, RHY, RHC and RHS are not banks. Products offered by RHF are not FDIC insured and involve risk, including possible loss of principal. RHC is not a member of FINRA and accounts are not FDIC insured or protected by SIPC. RHY is not a member of FINRA, and products are not subject to SIPC protection, but funds held in the Robinhood spending account and Robinhood Cash Card account may be eligible for FDIC pass-through insurance (review the Robinhood Cash Card Agreement and the Robinhood Spending Account Agreement).

2784249