Question: how to calculate variance of data in excel?
Answer: Summary. The Excel VAR function estimates the variance of a sample of data. ... 
Get variation of a sample.
Computed variance.
=VAR (number1, [number2], ...)
number1 - First number or reference. number2 - [optional] Second number or reference.
The VAR function estimates the variance for a sample of data.