The variance measures how far each number in the set is from the mean ... you need to calculate. There are a few different options for the formula to calculate variance in Excel: =VAR.S(select ...