Skip to main content

DVARP

Definition

Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

Sample Usage

Syntax

DVARP(database, field, criteria)

  • database - The array or range containing the data to consider, structured in such a way that the first row contains the labels for each column's values.

  • field - Indicates which column in database contains the values to be extracted and operated on.

    • field may either be a text label corresponding to a column header in the first row of database or a numeric index indicating which column to consider, where the first column has the value 1.
  • criteria - An array or range containing zero or more criteria to filter the database values by before operating.

See Also

VARP: Calculates the variance based on an entire population.

DVAR: Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.

DSUM: Returns the sum of values selected from a database table-like array or range using a SQL-like query.

DSTDEVP: Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.

DSTDEV: Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.

DPRODUCT: Returns the product of values selected from a database table-like array or range using a SQL-like query.

DMIN: Returns the minimum value selected from a database table-like array or range using a SQL-like query.

DMAX: Returns the maximum value selected from a database table-like array or range using a SQL-like query.

DGET: Returns a single value from a database table-like array or range using a SQL-like query.

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.

DAVERAGE: Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.

 

In order to use the DVARP formula, start with your edited Excellentable:

 

A
B
C
D
1
2
Key
Student ID
Class
Grade
3
1
N1707
2012
79
4
2
N1327
2013
78
5
3
N1890
2013
81
6
4
N1122
2012
89
7
5
N1357
2012
92
8
6
N1652
2013
89
9
7
N7475
2012
92
10
8
N1314
2012
90
11
12
Criteria
13
Key
Student ID
Class
Grade
14
2013
15
16
DVARP
21.55555556

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.