Tutorials › VEE Accounting and Finance › Estimating Variance From Historical Returns

VEE Accounting and Finance · Return Measurement and Risk · Tutorial 517 of 996

Estimating Variance From Historical Returns

Calculate and interpret sample variance from observed returns, while recognizing when a specified probability distribution calls for a different calculation.

Beginner 10 min read

What You'll Learn

  • Calculate the arithmetic sample mean of observed returns.
  • Find the sample variance using squared deviations and the \(n-1\) denominator.
  • Keep variance units consistent with whether returns are expressed as decimals or percentage points.
  • Explain why the sample variance is unbiased under independent, identically distributed sampling with finite variance.
  • Distinguish variance estimated from historical observations from variance calculated using a specified probability distribution.
  • Identify denominator and arithmetic errors that can distort a historical variance estimate.

Why Estimate Variance From Historical Returns?

A finite history of returns gives an investor observations, not a complete description of every return the investment could produce. The sample mean summarizes the observed returns, and the sample variance measures how spread out those observations are around that mean. Under suitable assumptions, sample variance also serves as an estimate of the return variance in the underlying process.

The distinction between a historical sample and a specified probability distribution matters. If the possible returns and their probabilities are given, variance is calculated using those probabilities. If only a finite series of realized returns is available, the probabilities are not known; the sample variance uses the observations and, for the usual unbiased estimate, divides by \(n-1\), not \(n\).

Definition: For \(n\) observed returns \(R_1,\ldots,R_n\), the sample mean is \(\bar{R}=\frac{1}{n}\sum_{t=1}^{n}R_t\). The sample variance is \(s_R^2=\frac{1}{n-1}\sum_{t=1}^{n}(R_t-\bar{R})^2\), for \(n\geq 2\). Each deviation is measured from the sample mean, and the deviations are squared before they are summed.

The sample variance has squared return units. If returns are entered as percentage points, such as \(3\) for \(3\%\), the variance is in squared percentage points. If returns are entered as decimals, such as \(0.03\) for \(3\%\), the variance is in decimal-return squared. These are two ways of expressing the same result: converting percentage-point returns to decimals multiplies the variance by \(0.01^2=0.0001\).

Calculating the Sample Variance

For a historical series, first calculate the arithmetic mean of the observations. Then subtract that mean from each return, square each deviation, add the squared deviations, and divide by \(n-1\). The number \(n-1\) is the degrees-of-freedom adjustment used when estimating the variance of an underlying return process from a sample.

1
Find the sample mean.
Add the \(n\) observed returns and divide by \(n\). This is the center used for the sample variance calculation.
2
Calculate and square each deviation.
For each observation, calculate \(R_t-\bar{R}\), then square that difference. Squaring prevents positive and negative deviations from canceling.
3
Sum and divide by \(n-1\).
Add the squared deviations and divide by \(n-1\). Preserve the return units consistently, and report variance in squared units.

Worked Example: Six Annual Returns

A hypothetical fund has the following six observed annual returns, in percentage points: \(2,4,4,6,8,12\). Calculate the arithmetic sample mean and the sample variance. Treat these as six historical observations; no probability distribution is specified. The estimation method is the squared-deviation formula, and the denominator for the sample variance is \(n-1\).

Step 1: Calculate the mean. The sum of the returns is \(2+4+4+6+8+12=36\) percentage points. With \(n=6\),

$$ \bar{R}=\frac{36}{6}=6\% $$

Step 2: Calculate deviations and squared deviations. Subtract \(6\) from each observed return. The deviations, in order, are \(-4,-2,-2,0,2,6\) percentage points. Squaring gives \(16,4,4,0,4,36\) squared percentage points.

Step 3: Sum and divide by \(n-1\). The squared deviations sum to \(16+4+4+0+4+36=64\). The denominator is \(6-1=5\), so

$$ s_R^2=\frac{64}{5}=12.8000\text{ squared percentage points} $$

The sample mean is \(6\%\) and the sample variance is \(12.8000\) squared percentage points. As a units check, the same observations in decimal form have mean \(0.06\) and sample variance \(12.8(0.0001)=0.00128\) decimal-return squared. The calculation avoids treating a historical sample as though its true probabilities were known.

Why the Denominator Is \(n-1\)

The reason for the \(n-1\) denominator is not that a historical series literally contains only \(n-1\) returns. Rather, when the sample mean is estimated from the same observations, the deviations from that mean are constrained: they sum to zero. Under a standard sampling model, dividing by \(n-1\) corrects the downward bias that would result from dividing by \(n\).

Suppose the observed returns \(R_1,\ldots,R_n\) are independent and identically distributed, with population mean \(\mu\) and finite population variance \(\sigma^2\). These are assumptions for the unbiasedness result, not facts guaranteed by observing a return history. The sample mean is \(\bar{R}\). The identity below follows by writing \(R_t-\bar{R}=(R_t-\mu)-(\bar{R}-\mu)\), expanding the squares, and using \(\sum_{t=1}^n(R_t-\mu)=n(\bar{R}-\mu)\):

$$ \sum_{t=1}^{n}(R_t-\bar{R})^2 = \sum_{t=1}^{n}(R_t-\mu)^2-n(\bar{R}-\mu)^2 $$

Taking expectations gives \(n\sigma^2\) for the first sum. Under independence and identical distribution, \(\operatorname{Var}(\bar{R})=\sigma^2/n\), and \(E[(\bar{R}-\mu)^2]=\sigma^2/n\). Thus the expected sum of squared deviations from the sample mean is \(n\sigma^2-n(\sigma^2/n)=(n-1)\sigma^2\). Dividing by \(n-1\) therefore gives \(E[s_R^2]=\sigma^2\). This is the justification for calling \(s_R^2\) an unbiased estimator of the population variance under these assumptions.

If returns are dependent, have changing distributions over time, or otherwise fail the assumptions, this unbiasedness result need not apply. The formula still describes the spread in the observed finite series, but its interpretation as an unbiased estimate of a stable population variance requires care.

Worked Example: A Short Quarterly Return History

A hypothetical account records four quarterly returns, in percentage points: \(-3,1,2,4\). Calculate the sample mean and sample variance. Treat the observations as one historical series, with no probability distribution provided. Use the usual sample estimator, and round the variance to four decimal places.

Step 1: Find the mean. The return sum is \(-3+1+2+4=4\) percentage points. Therefore \(\bar{R}=4/4=1\%\).

Step 2: Find the squared deviations. Subtracting the mean \(1\) from each return gives deviations \(-4,0,1,3\). Their squares are \(16,0,1,9\), which sum to \(26\) squared percentage points.

Step 3: Apply the sample denominator. There are four observations, so \(n-1=3\). Hence

$$ s_R^2=\frac{26}{3}=8.6667\text{ squared percentage points} $$

The sample mean is \(1\%\), and the sample variance is \(8.6667\) squared percentage points. A common mistake avoided here is dividing by the number of quarterly observations, \(4\), when the requested quantity is the usual sample variance estimate.

Historical Estimates and Specified Distributions

Historical returns are a finite set of observed outcomes. In contrast, a specified probability distribution provides possible outcomes and their probabilities. For a discrete distribution, the variance is the probability-weighted average of squared deviations from the expected return. It is not the sample variance formula, because its probabilities describe the model rather than being estimated from a sample of observations.

Worked Example: Known Return Probabilities Versus a Historical Sample

A hypothetical one-year investment model specifies returns of \(-4\%,2\%,8\%\) with probabilities \(0.25,0.50,0.25\), respectively. The outcomes and probabilities are the complete model for this calculation; no historical sample is being used. Find the expected return and the model variance, in squared percentage points. The method is the probability-weighted variance formula.

Step 1: Find the expected return. Weight each return by its stated probability:

$$ E[R]=0.25(-4)+0.50(2)+0.25(8)=-1+1+2=2\% $$

Step 2: Find the squared deviations from the expected return. The deviations from \(2\%\) are \(-6,0,6\) percentage points. Their squares are \(36,0,36\) squared percentage points.

Step 3: Weight the squared deviations by their probabilities.

$$ \operatorname{Var}(R)=0.25(36)+0.50(0)+0.25(36)=9+0+9=18 $$

The model variance is \(18\) squared percentage points. This is not calculated by dividing by \(n-1\): the three outcomes are possible return values with specified probabilities, not three observed historical returns. Confusing these two settings changes the calculation and the meaning of the result.

Common Mistakes and Checks

Variance calculations are especially vulnerable to small arithmetic and interpretation errors. In an exam response, show the mean, deviations, sum of squares, and denominator; doing so makes it possible to identify the source of a discrepancy.

  • Using \(n\) instead of \(n-1\) for sample variance. In the six-return example, the squared deviations sum to \(64\). Dividing by \(6\) gives \(10.6667\), which is not the usual sample variance estimate. The correction is \(64/(6-1)=12.8000\) squared percentage points.
  • Using a wrong sum of squared deviations. The deviations for \(2,4,4,6,8,12\) about \(6\) are \(-4,-2,-2,0,2,6\), whose squares sum to \(64\), not \(60\). Rechecking each squared deviation prevents a plausible-looking but incorrect final value.
  • Mixing percentage points and decimals. A variance of \(12.8\) squared percentage points is not \(12.8\) decimal-return squared. In decimal units it is \(0.00128\).
  • Centering on the wrong value. Sample variance uses deviations from the sample mean. A supplied expected return may be the correct center for a probability-distribution variance, but it is not automatically the center for a historical sample variance.
  • Overstating what the estimate establishes. A historical sample variance summarizes the observations and, under assumptions, estimates an underlying variance. It does not prove that future returns follow a stable distribution.
Key takeaway: For \(n\) historical returns, calculate their arithmetic mean, sum their squared deviations from that mean, and divide by \(n-1\) to obtain the usual sample variance estimate. Use probability-weighted variance instead when outcomes and probabilities are specified as a model.

Check Your Understanding

For each problem, identify whether the data are historical observations or a specified probability model, then calculate the requested mean and variance. Variances from percentage-point returns are in squared percentage points.

  1. A hypothetical portfolio has three observed annual returns of \(1\%,3\%,5\%\). Find the sample mean and sample variance. (Answer: mean \(3\%\); sample variance \(4.0000\) squared percentage points.)
  2. A hypothetical asset has four observed returns of \(-3\%,1\%,2\%,4\%\). Find the sample mean and sample variance, using four decimal places for the variance. (Answer: mean \(1\%\); sample variance \(8.6667\) squared percentage points.)
  3. A hypothetical strategy has five historical monthly returns of \(0\%,2\%,4\%,6\%,8\%\). Find the arithmetic sample mean and sample variance. (Answer: mean \(4\%\); sample variance \(10.0000\) squared percentage points.)
  4. A hypothetical account's four observed annual returns, expressed as percentage points, are \(1,3,5,7\). Calculate the sample mean and sample variance, then express the variance in decimal-return squared. (Answer: mean \(4\%\); sample variance \(6.6667\) squared percentage points, or \(0.0006667\) decimal-return squared.)
  5. A specified one-year return model has outcomes \(0\%,4\%,10\%\) with probabilities \(0.20,0.50,0.30\). Calculate its expected return and variance. (Answer: expected return \(5\%\); variance \(13.0000\) squared percentage points.)
Clinical Biostats