How to Calculate Sample Variance in Microsoft Excel

‍

‍

It is very easy to calculate sample variance in Microsoft Excel. Here’s a quick tutorial on how to do it:

‍

1. Inside your Microsoft Excel worksheet, head over to the top menu bar and click 'Formulas'.
2. Select 'More Functions' from the available options.
3. Subsequently, hover your mouse cursor over the 'Statistical' option and then click 'VAR.S'.
4. Tap the 'Number1' input field and then enter the cell range that contains the data you wish to calculate.
5. Once done, tap 'Insert' to proceed.
6. After completing these steps, the sample variance of the selected dataset will be calculated based on your input.