Microsoft Office Tutorials and References
In Depth Information
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.
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
VAR VARP calculates variance based on the entire population.
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