Home > Articles

  • Print
  • + Share This
This chapter is from the book

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.

Figure 3.9 The DVARP function returns the true variance of an entire population.

  • + Share This
  • 🔖 Save To Your Account