How to Calculate Sample Variance in Microsoft Excel
- George Apostolov
- 05 Sep 2025
Guide
Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Formulas'.
Select 'More Functions' from the available options.
Subsequently, hover your mouse cursor over the 'Statistical' option and then click 'VAR.S'.
Tap the 'Number1' input field and then enter the cell range that contains the data you wish to calculate.
Once done, tap 'Insert' to proceed.
After completing these steps, the sample variance of the selected dataset will be calculated based on your input.
Create your first interactive demo in minutes
No credit card required • Start building today


