# VARPA

Calculates variance based on the entire population. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation.

**Syntax**

**VARPA**(**value1**,value2, ...)

**Value1**,value2, ... are 1 to 30 value arguments corresponding to a population.

**Remarks**

- VARPA assumes that its arguments are the entire population. If your data represents a sample of the population, you must compute the variance using VARA.
- Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero). If the calculation must not include text or logical values, use the VARP worksheet function instead.
- The equation for VARPA is:

**Example**

Using the data from the VARA example and assuming that only 10 tools are produced during the production run, VARPA measures the variance of breaking strengths for all the tools.

`VARPA(A2:E3)`

equals 678.8