How to Calculate Standard Deviation (simple example)
Over a 12 month period if an investment fund produces the following returns:
January | February | March | April | May | June | July | August | September | October | November | December |
1.5 | 1.2 | 0.7 | 0.4 | 5.4 | -2.8 | -2 | 6 | 4.4 | -4.2 | 1.3 | 0.4 |
The mean would be calculated as:
(arithmetic mean used for the sake of simplicity. We will be calculating the population standard deviation in this instance, again to keep things simple.)
1.5 + 1.2 + 0.7 + 0.4 + 5.4 + -2.8 + -2 + 6 + 4.4 + -4.2 + 1.3 + 0.4 /12 = 1.025
Once we have the mean we are 1/5th of the way to finding the standard deviation of the performance of our fund.
Step 1: Find the mean.
☑ Done!
Step 2: For each data point, find the square of its distance to the mean.
January | February | March | April | May | June | July | August | September | October | November | December |
1.5 | 1.2 | 0.7 | 0.4 | 5.4 | -2.8 | -2 | 6 | 4.4 | -4.2 | 1.3 | 0.4 |
1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 |
distance 0.475
0.475^2 |
distance 0.175
0.175^2 |
distance 0.325
0.325^2 |
distance 0.625
0.625^2 |
distance 4.3754.375^2 = 19.141 |
distance 3.8253.825^2 = 14.631 |
distance 3.033.03^2 = 9.181 |
distance 4.9754.975^2 =24.751 |
distance 3.3753.375^2 = 11.391 |
distance 5.2255.225^2 = 27.301 |
distance 0.2750.275^2 = 0.076 |
distance 0.6250.625^2 = 0.391 |
Step 3: Sum the values from Step 2.
0.226 + | 0.031 + | 0.106 + | 0.391 + | 19.141 + | 14.631 + | 9.181 + | 24.751 + | 11.391 + | 27.301 + | 0.076 + | 0.391 = 107.613 |
Step 4: Divide by the number of data points.
107.613 / 12
= 8.967
Step 5: Take the square root.
√ 8.967
= 2.994
Standard Deviation = 3% (rounded up for the sake of convenience)
Now that you have the heavy lifting out of the way (working on the premise that you didn’t just type the STDEV into Excel instead of calculating it yourself…), you can make some inferences about the return profile, and future performance of the fund. In explanation of this newfound sentience, answers can be found on a normal distribution graph (you may recognize the “bell curve” diagram from school…). Now, the returns of investments do not always fit into the bell curve owing to their asymmetrical bias towards positive returns (called skew), but they will fall upon the curve often enough to render the exercise meaningful; particularly over longer time periods, using larger sample sizes.
The standard deviation of a probability distribution graph tells us how likely a certain percentage price change is over that corresponding period of time. In our example, we have calculated the SD from the mean of the monthly returns of a fund over a 12 month period. Accordingly, we can make inferences about what the next 12 month’s monthly price volatility will be, and the degree to which it will be positive or negative on a monthly basis. Values within one standard deviation of the mean value always represent 68.2% of the values in a series of returns.
1 standard deviation = 68.2% of the time
2 standard deviations = 95.4% of the time
3 standard deviations = 99.7% of the time
Our fund has a mean monthly return of +1.025% and a standard deviation (volatility) of 3%. Based on this we can say that 68.2% of the time, over a 12 month period, a monthly return from the fund will be between-1.97% and +4.025%. Moving on, 95.4% of the time over a 12 month period, a monthly return from the fund will be between -4.975% and +7.025% and that 99.7% of the time the monthly returns will be between -7.975% and +10.025%. All in all, not a bad investment for somebody with a medium to long-term time horizon.The reliability of the inference that can be made is largely dependent upon the sample size, with more reliable conclusions being drawn from larger sample sizes with more data points (i.e investments which have longer track records and more performance history…). Even with sufficiently deep sample sizes there will be periods where performance is seemingly anomalous and at odds with our statistical predictions. Such goes the saying that “markets can remain irrational much longer than you can remain solvent”, however, if you are able to leave your capital committed you will likely realise performance which is in line with the long-term averages.
When flipping a coin there is a 50% probability of landing a head or a tails. This withstanding, you could flip the coin 5 times and get 5 heads. This does not mean that the coin is rigged or that the probabilities have changed from the original 50/50; it simply means that there have not been a sufficient number of occurrences for the probabilities to play out. If you were to flip the coin another 100 times you would move closer to a 50/50 distribution of heads and tails results as you move on. Probabilities are no guarantee of performance, nor are future results (which we base our probability assumptions on) any guarantee of future performance. Still, if you purchase an asset and it has a history of price appreciation over the long term, with a level of volatility that you are comfortable with, you should definitely hold the asset for as long as you can to benefit from the asymmetry of profit distributions.