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.