DVAR()
Syntax. DVAR(database,field,criteria)
Definition. This function estimates the variance of a sample based on the numbers in a column in a list or database that match the specified conditions.
Arguments
database (required) The cell range that makes up the list or database
field (optional) Indicates which column is used in the function
criteria (required) The cell range containing the field names and the filter criteria
Background. The most commonly used spreads in statistics are the variance and the standard deviation. The variance is the sum of the squared deviation of each value from the mean divided by the number of values with an adjustment for the sample.
See Also
You will find more information about the variance in the description of VARA() ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.
