Question: how to calculate between group variance in excel?
Answer: Find the mean by using the AVERAGE function: =AVERAGE(B2:B7) ... 
Subtract the average from each number in the sample: ... 
Square each difference and put the results to column D, beginning in D2: ... 
Add up the squared differences and divide the result by the number of items in the sample minus 1: