To calculate the volatility of a given security in a Microsoft Excel spreadsheet, first determine the time frame for which the metric will be computed. Step 1: Timeframe ...

To calculate statistical variance in Microsoft Excel, ... You can use Microsoft Excel to calculate the variance of the data you have entered into a spreadsheet.