DVARP() function

About DVARP() Function

The DVARP() function is a database function that calculates the variance entire population of selected database entries. It keeps 3 arguments.

Where to apply :

The DVARP() function is applied to know the variance in entire population. This helps to control the variance of population.

Syntax :

=DVARP(range, field, criteria)

Parameters :

range - It indicates a range, table or a database.

field - It is a column of database that keeps numeric values.

criteria - This argument keeps a condition or group of conditions.

Example :

Let's take a table that shows billing on daily basis.

To know the variance in the amounts of Monday, you can use below function.

=DVARP(Table8[#All],"Billing",C19:C20)   // Returns (50.8888)

It returns 50.8888.

The DVARP() function is well explained with above examples.

Hope, it would have added in your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be excel expert, connect us on:

ExcelHour
9599408486 / 8929231250
Website: https://www.excelhour.in/