Microsoft added a bunch of useful capabilities to Excel this month, including one that was highly requested by customers.

Variance is a measurement of the spread between numbers in a data set. Investors use the variance equation to evaluate a portfolio’s asset allocation.