To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR.

How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...

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

The following article will show you, step-by-step, how to calculate the historical variance of stock returns with a detailed example.

How to Calculate Volatility of a Stock Calculate an asset's potential for value changes based on historical performance.

How to calculate average stock returns in Excel In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.