Name

VARA

Synopsis

Use VARA to find the variance in a list of values based upon a sample. If a value specified contains the logical value TRUE it is evaluated as 1. If a value contains text or the logical value FALSE it is evaluated as 0.

To Calculate

=VARA(Value1, Value2, ...)

There must be at least one Value argument specified for this function.

Example

Figure 15-50 illustrates how to use VARA to find the variance of a list of values. Since the list includes two logical values, those values are evaluated as part of the variance.

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.