VARP

Excel Functions

Get variation of a population

Syntax

EXCEL

=VARP(number1, [number2], ...)

Arguments

Parameter	Description
`number1`	First number or reference.
`number2`	[optional] Second number or reference.

Return Value

Computed variance

Details

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. Note: Microsoft classifies VARP as a "compatibility function", now replaced by the VAR.P function. The table below summarizes the variation functions available in Excel.

Examples

Example 1

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 show