In statistics, the amount of data dispersion is measured as variance. The Excel function required for calculating variance depends on the data set.

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.