NORMSINV is an Excel function used along with normal distributions. It allows you to conduct calculations faster and with more precision than by doing them by hand. Further, you can use NORMDIST ...

With those values, you can use a spreadsheet program like Microsoft Excel to calculate the asset's standard deviation. Investors use standard deviation as a proxy for volatility. To interpret ...