With that, Excel can generate a series of random numbers based on the data entered and the standard deviation. With this data you can then create a curved chart, known as a bell curve.

Standard Deviation indicates the volatility of the fund’s returns. Higher standard deviation means higher variation in returns and vice versa. In technical terms, it is a dispersion of returns from ...