# DVARP Function in Microsoft Excel

## Part 1: Introduction

### Definition

The DVARP function in Microsoft Excel is a database function that calculates the variance of a selected database or array of numbers. It’s a statistical function that helps you understand the variability of your data.

### Purpose

The DVARP function is used when you want to find the variance based on the entire population. It’s helpful in business scenarios where you must analyze a complete dataset, such as sales, customers, or inventory.

### Syntax & Arguments

The syntax for the DVARP function is as follows:

syntax
`DVARP(database, field, criteria) `

#### Arguments

1. Database: This is the range of cells that make up the database. It includes column headers.
2. Field: This indicates the column in the database that the function will be used on. It can be the column name (in quotes) or the column number.
3. Criteria: This is the cell range containing the conditions you specify. It includes at least one column header and at least one cell below the header specifying a column condition.

### Return Value

The DVARP function returns the variance of a population based on selected database entries.

### Remarks

The DVARP function considers cells with text as 0s, empty cells are ignored, and cells with logical values TRUE and FALSE are regarded as 1 and 0, respectively.

## Part 2: Examples

### Example 1

#### Purpose

To calculate the variance in sales data for a specific product category.

#### Data Tables and Formulas

ABC
1CategoryProductSales
2ElectronicsTV5000
4FurnitureChair2000
5Category
6Electronics

#### Explanation

In this example, we want to calculate the sales variance for the ‘Electronics’ category. The formula `DVARP(A1:C4, "Sales", A5:A6)` will calculate the sales variance for all products in the ‘Electronics’ category. The result will give us an understanding of the sales variability within this category.

### Example 2

#### Purpose

Calculate the variance in the number of units sold for a specific region.

#### Data Tables and Formulas

ABC
1RegionUnitsSales
2West1005000
3West1206000
4East1507000
5Region
6West

#### Explanation

In this example, we want to calculate the variance of units sold in the ‘West’ region. The formula `DVARP(A1:C4, "Units", A5:A6)` will calculate the variance of units sold for all sales in the ‘West’ region. The result will explain the variability of units sold within this region.

### Example 3

#### Purpose

Calculate the variance in the cost of goods sold for a specific supplier.

#### Data Tables and Formulas

ABC
1SupplierGoodsCost
2ABC Ltd.Apples100
3ABC Ltd.Pears120
4XYZ Ltd.Apples150
5Supplier
6ABC Ltd.
In this example, we want to calculate the cost variance for goods from the ABC Ltd. Supplier. The formula `DVARP(A1:C4, "Cost", A5:A6)` will calculate the cost variance for all goods from the ABC Ltd. supplier. The result will provide an understanding of the variability of cost for goods from this supplier.