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: