Microsoft Office Tutorials and References
In Depth Information
DVARP
A
Database range
Figure 3.8
The DVAR function
returns an estimated
variance of a sample
population.
B
Criteria to be used
C
Field referenced as text
DVARP
DVARP returns the calculation of the true variance of an entire population, based on the values
that meet the specified criteria.
=DVARP(database,field,criteria)
Whereas DVAR calculates the variance based only on a sample of the population, the DVARP
function returns the true variance based on the entire population. In the syntax, there are
three components: the database, the cell reference range or named range of the database; the
field, referenced as the column number from left to right; and the criteria, a range that is
referenced. The function operates from the parameters set. Notice in Figure 3.9, that the true
variance of the entire population of the regions North and South is 5,051,679 for the year
2002. In this example, I’ve used wildcards to pull all information from the North and South
for the year 2002 with an asterisk.
Search JabSto ::




Custom Search