Calculate the standard deviation of the historical returns compared to the mean determined in Step 3. In Excel, this can be achieved by using the STDEV function.

Historical volatility is a long-term assessment of risk. Discover why it is important to investors and learn how to calculate volatility in Excel.

A stock's historical variance measures the difference between the stock's returns for different periods and its average return. A stock with a lower.