How to Calculate Sample Variance in Microsoft Excel



Guide

  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.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline