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.