Name

DVAR

Synopsis

Use DVAR to estimate the sample variance by using the numbers in the specified column of a database table that match the conditions specified by the Criteria argument.

To Calculate

=DVAR(Database, Field, Criteria)

All three arguments are required for this function.

Example

Figure 17-3 illustrates how to use DVAR to find the variance of the sales numbers within the state of Texas based on the sample.

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.