It is very easy to calculate sample variance in Microsoft Excel. Here’s a quick tutorial on how to do it:
- 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.
