You can use Microsoft Excel to calculate the variance of the data you have entered into a spreadsheet. How to Calculate Variance in Excel To calculate variance in Excel, you will need to have your ...