The Excel VARP function calculates the variance of an entire population of data. If data represents a sample, use the VAR function or the newer VAR.S function. VARP ignores text values and logicals in references.
Get variation of a population
=VARP (number1, [number2], ...)
number1 - First number or reference.
number2 - [optional] Second number or reference.
The VARP function calculates the variance of an entire population of data. Variance provides a general idea of the spread of data. In the example shown, the formula in F5 is:
VARP ignores text and logicals passed into as cell references. For example, VARP will ignore FALSE when it appears in a range like A1:A10. However, VARP will evaluate logical values, and text representations of numbers hardcoded directly as arguments.
The Excel VAR function estimates the variance of a sample of data. If data represents the entire population, use the VARP function or the newer VAR.P function. VAR ignores text values and logicals in references.