*Figure 1.VAR.P Function in Excel*

Let’s assume that we have a range of data representing a population sample, we are going to make use of the Excel VAR.P function to determine the of variance the entire population.

**Generic Formula**

`=VAR.P (number1, [number2], ...)`

- number1 is the first reference or number,
- number2 is the second reference or number (optional).

Variance is a measure of how far a set of data is spread out, providing us with a general idea of our data spread.

**How to use the Excel VAR.P Function.**

We are now going to demonstrate the use of the Excel VAR.P Function in calculating the variance based on the entire population.

We can achieve this by following 2 simple steps;

- List the sample data of the population in a column of our worksheet.

See illustration below;

* *Figure 2. Sample Data in Excel

Our purpose here is to determine the variance of a range of ages in a sample population.

Be sure to leave a blank cell for Excel to return the variance value. Cell C4 of our worksheet example.

- The VAR.P formula which we will enter into cell C4 is;.

`=VAR.P(A2:A7)`

* *Figure 3. Excel VAR.P Function

The cell range A2:A7 represent the individual ages of our sample population.

**Note**

- Even though our data set represents a sample of the population, the Excel VAR.P Function will assume that it represents the entire population.

* *Figure 3. Final Result

**Instant Connection to an Expert through our Excelchat Service:**

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes

## Leave a Comment