As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Find Variance in Excel: A Step-by-Step Guide

When working with data in Excel, understanding statistical measures like variance is crucial. Variance indicates how spread out your data is. This step-by-step guide will walk you through calculating variance in Excel, including the use of the built-in variance function.

Step 1: Enter Your Data into Excel

Begin by entering your data into Excel. This can be done manually or by importing data from another source. Ensure that your data is in a tabular format for accurate reading by Excel.

Step 2: Calculate the Mean

Calculate the mean (average) of your data. You can do this manually or use the built-in AVERAGE function in Excel. To use AVERAGE, select the cell for the mean, type =AVERAGE(, and choose the data cells. Press Enter to get the mean.

Step 3: Calculate the Variance

Compute the variance, which is the average of the squared differences from the mean. Utilize the built-in VAR function in Excel for this. To use VAR, select the cell for variance, type =VAR(, and choose the data cells. Press Enter to calculate the variance.

Step 4: Calculate the Standard Deviation

The standard deviation is the square root of the variance. You can calculate it manually or use the STDEV function in Excel. For STDEV, select the cell for standard deviation, type =STDEV(, and choose the data cells. Press Enter to compute the standard deviation.


You've successfully learned how to calculate variance in Excel. Variance is a valuable statistic for understanding data spread. Excel's built-in functions make the calculation process straightforward. Congratulations on completing this guide!