|
<< Click to Display Table of Contents >> VARP (variance of entire population) |
Note: VARP is supplemented by the new identical function VAR.P, which is available in newer versions of Microsoft Excel (2010 or later).
Syntax:
VARP(Number1, Number2 [, Number3 ...])
Description:
This returns the variance of an entire population.
Number1, Number2, etc., are single values, cell ranges or arrays that contain the values to be evaluated. Please note that all values of the entire population have to be specified. To calculate the variance of a sample, use the VAR.S/VAR function instead. This returns an estimate of the variance.
If this function refers to empty cells or cells with error values, they are ignored. Likewise, cells that contain text strings or logical values, but these can be entered directly into the list of arguments and thus taken into account.
Additional info:
The variance is calculated using the "biased" or "n" method.
Example:
VARP(2, 2, 3, 4, 1) returns 1.04
See also: