Build a Better Process

# Variance Definition, Quiz and Tutorial

No need to interpret variance. That's what standard deviation is for.
1. Define - Learn about variance for investment modeling.
2. Context - Use variance in a sentence.
3. Video - Watch the video for variance in Excel.
4. Script - Follow along with the transcript below.
5. Quiz - Test yourself.
Updated: February 18, 2021
Variance in the investment space is highly dependent on the timeframe selected when measuring it, which we discuss below.

/ factorpad.com / fin / glossary / variance.html

## Define and Interpret Variance for Investment Modeling

Intermediate

Variance is a measure of the distribution of observations around the mean. It is often used for descriptive statistics, inferential statistics and hypothesis testing.

For investment modeling, variance is a widely used descriptive statistic, as is its square-root, the standard deviation. Variance is also used heavily in valuation models of individual securities, portfolio choice and the measurement of risk-adjusted portfolio performance.

Variance is calculated by taking the sum of all squared differences between each observation and the mean over the measurement period. After summing those, next divide by the number of observations. Because it is the result of squaring, variance will always be zero or greater.

Variance is not easily interpreted because the scale is in units squared, like percent-return-squared. So instead, to interpret, translate to standard deviation by taking the square-root of variance. Its units would then be in percent-return, and that can easily be interpreted.

Synonym: second central moment

For context, variance provides a measure for how far from the average the whole group of obervations are spread out. Imagine a bell-shaped curve and here a higher variance will have a wider distribution. On the other hand, when the variance is low, the distribution will be narrow and tall.

### In a Sentence

Doc:  Besides variance what else could we use on the x-axis for MPT charts? And why?
Wes:  Standard deviation, because it's more interpretable and the relationship still holds.

### Video

This video can be accessed in a new window or App , at the YouTube Channel or from below.

Variance definition for investment modeling (4:22)

### Video Script

The script includes two sections where we visualize and demonstrate the calculation of variance using demeaned returns.

#### Visualize

We're sitting right here in Excel, and this is a snippet from our boot camp course.

This is one depiction of variance, from a discussion on portfolio theory.

Think about each dot here as a stock or portfolio. Each has a return and a risk measure. Risk is on the x-axis and return is on the y-axis.

Risk here can be interpreted as either variance or standard deviation. As you will see shortly, they are both related. You go seven steps with the exact same calculation, until the final step.

The key with variance is the calculation, so let's head there now.

#### Demonstrate

Let's walk through a calculation for two stocks, Microsoft and eBay. We have six monthly observations of return for each stock from April to September 2003. Column F is the return on Microsoft, eBay is Column G.

Next we compute the average of each, here 2.38% for Microsoft and 3.98% for eBay. Then move those over to columns H and I.

In column J we take the return minus the average which gives us 3.24%. That's 5.62% minus 2.38%, or 3.24%. For eBay it is 8.91% minus 3.98%, or 4.93%. Carry that formula down for all months. Next, square these in columns L and M.

Next, using the `=SUM()` function, add up the products for each stock to get 0.0062 for Microsoft and 0.0109 for eBay.

Next, divide by 6 observations to get the variance of 0.0010 for Microsoft and 0.0018 for eBay. Recall, these are in units of returns squared so aren't interpretable. So it is common to use standard deviation, which is the square root of variance.

To get that, use the `=SQRT()` function or take the variance to the one-half power, as I have done here.

### Quiz

If inputs are in decimal form, like 0.0225, then variance is lower than standard deviation. | True or False?

True

If inputs are in integer form, like 15, then variance is higher than standard deviation. | True or False?

True

Still unclear on variance? Leave a question in the comments section on YouTube or check out the Quant 101 Series, specifically Four Essential Stock Risk Measures.

### Related Terms

Our trained humans found other terms in the category statistics basics you may find helpful.

## What's Next?

We're producing videos for smart folks like you. Subscribe for reminders and to show your support.

• For all Glossary terms, click Outline.
• To review Variable Investments, hit Back.
• Coffee makes me creative, click Tip.
• For the related term, Volatility, click Next.

/ factorpad.com / fin / glossary / variance.html

stock variance
dispersion measure
stock volatility
stock risk
portfolio risk
demeaned returns
portfolio risk analysis
portfolio statistics
variance definition
variance finance
variance formula
analysis of variance
variance meaning
variance statistics
excel var p
excel var s
variance definition statistics
portfolio variance
measures of variance
var function excel
investment variance

A newly-updated free resource. Connect and refer a friend today.