To calculate statistical variance in Microsoft Excel, ... Excel to calculate the variance of the data you have entered into a spreadsheet. ... is part of the Dotdash Meredith publishing family.