VARA function

VARA estimates the variance based on a sample. In addition to numbers, text and logical values such as TRUE and FALSE are included.

Syntax

VARA (value 1, value 2, ... value 30)

value 1, value 2, ...value 30 are values or ranges representing a sample of an entire population. The value arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).

Note: If the data represents the entire population, use VARPA to compute the variance. If logical values or text must not be included, use VAR instead.

Example

=VARA(A1:A50)