Microsoft Office Tutorials and References

In Depth Information

**VARA**

Figure 11.53

The
VAR
and
VARA

functions are used

when you have only a

sample of the entire

population. If the data

set is the entire

population, use the
VARP

and
VARPA
functions.

VAR
VARA
estimates variance based on a sample, including samples that contain text or logical values.

=VARA(value1,value2,...)

The
VARA
function differs from the
VAR
function in that it will also evaluate logical values such

as TRUE and FALSE. TRUE evaluates to one (1); FALSE evaluates to zero (0). Arguments

that contain text also evaluate to zero. Refer to Figure 11.53 for a comparison of
VAR
and
VARA
.

Is the cell reference(s), range name, text representations of numbers,

array, or logical values that makes up the data set. Up to 30 arguments can

be specified.

VALUE N

VAR
VARP
calculates variance based on the entire population.

=VARP(number1,number2,...)

The
VARP
function is used when you have all the data and not just a random sample. Figure

11.54 lists the amount spent by each state on maps at their visitor centers.

You can specify up to 30 arguments for the
VARP
function. The arguments

can be cell references, arrays, or range names. Blank cells or cells

containing text are ignored. Cells that contain a zero (0) are included in the
VARP

calculation.

NUMBER N