and then dividing the sum of the squares by the number of values in the data set. Software like Excel can make this calculation easier. Variance is calculated by using the following formula ...