# Excel VARA Function

## Summary

The Excel VARA function estimates the variance based on a sample of the population and will evaluate logical and text values.

To estimate the variance for the entire population, including logical and text values, use the VARPA function.

## Syntax

=VARA (value1, [value2], ...)

## Syntax Breakdown

Value 1
Required. The first value that corresponds to a sample of a population.

Value 2
Value 2 and subsequent value arguments are optional. The function can accept up to 255 arguments. An array or reference to an array can also be used.

## Usage Notes

VARA calculate the variance from data that is representative of a sample of a population. Unlike the VAR function, VARA will evaluate logical and text values that are included in an array or reference.

Variance is used to provide a general idea of how far a set of numbers are spread out from the average value. More formally, it is the expectation of the squared deviation of a random variable from its mean.

Logical values and text representations of numbers that are hard-coded into an argument are evaluated. If the argument or reference contains text, it will be evaluated as 0 (zero). TRUE evaluates as 1 and FALSE evaluates as 0 (zero). Empty cells are ignored.

To ignore logical and text values, use the VAR or VAR.S functions.

Excel Variance Functions
Function Data Set Text & Logical Values
VAR Sample Ignored
VARP Population Ignored
VAR.S Sample Ignored
VAR.P Population Ignored
VARA Sample Evaluated
VARPA Population Evaluated