Table of Contents
In simple terms, Standard Deviation (SD) is a statistical measure representing the Volatility or risk in an instrument. It tells you how much the fund's return can deviate from the historical mean return of the scheme. The higher the SD, higher will be the fluctuations in the returns.
If a fund has a 12 percent average rate of return and a standard deviation of 4 percent, its return will Range from 8-16 percent.
To find standard deviation on a mutual fund, add up the rates of return for the period you want to measure and divide by the total number of rate data points to find the Average Return. Further, take each individual data point and subtract your average to find the difference between reality and the average. Square each of these numbers and then add them up.
Divide the resulting sum by the total number of data points less one -- if you have 12 data points, you divide by 11. The standard deviation is the square root of that number.
Let's understand better with illustration-
Let's find the SD of two different Mutual Funds. First, we will calculate their average return for the last five years.
Mutual Fund A: (11.53% + 0.75% + 12.75% + 32.67% + 15.77%)/5 = 14.69%
Mutual Fund B: (4.13% + 3.86% + {-0.32%} + 11.27% + 21.63%)/5= 9.71%
Since Standard Deviation is the square root of variance, we must first find the variance of each investment.
Then, you divide the sum of the squares from the first step by the 1 less the number of years (∑/n-1).
Mutual Fund A: (11.53%-14.69%)² + (0.75%-14.69%)² + (12.75%-14.69%)² + (32.67%-14.69%)² + (15.77%-14.69%)²= 0.052/4=.013
Mutual Fund B: (4.13%-9.71%)² + (3.85%-9.71%)² + (-0.32%-9.71%)² + (11.27%-9.71%)² + (21.63%-9.71%)²= 0.032/4=.008
Mutual Fund A: √.013= 11.4%
Mutual Fund B: √.008= 8.94%
Talk to our investment specialist
Excel offers the following functions:
STDEV.P to calculate standard deviation based on the entire population
STDEV.S to estimate standard deviation based on the sample
Using the functions one can determine the SD of the fund.
Mutual Fund Name | Standard Deviation |
---|---|
Aditya Birla Sun Life Focused Equity Fund | 13.63 |
JM Core 11 Fund | 21.69 |
Axis Bluechip Fund | 13.35 |
Invesco India Largecap Fund | 13.44 |
Invesco India Largecap Fund | 13.44 |