How to Calculate Sample Variance in Microsoft Excel

Quick summary

To calculate sample variance in Microsoft Excel, use the built-in VAR.S function found under Formulas > More Functions > Statistical. Simply enter your cell range into the Number1 field and Excel instantly returns the sample variance for your dataset.

Steps

1. Open your Microsoft Excel worksheet, go to the top menu bar, and click Formulas.
2. Select More Functions from the available options in the Formulas ribbon.
3. Hover over the Statistical category and click VAR.S from the submenu.
4. Click the Number1 input field and enter the cell range that contains the data you want to analyze.
5. Click Insert to confirm and apply the function.
6. Excel will display the calculated sample variance of your selected dataset based on your input.