Var

The Var function estimates variance based on a sample.

Var (numbers, break_col)

where:

numbers references the column that contains the numbers on which the variance is calculated.

break_col is an optional parameter that references a break column.

Note:

Var assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance using Varp.

The following examples show the results of inserting the Var function in two separate tables.

Example 1

In this example, the Var function is used on the numeric column. The results are shown in the Computed column.

Var(Amount)

Table 171. Var Example 1

State	City	Amount	Computed
AZ	Tucson	112	16,413.25
CA	Burbank	240	16,413.25
CA	Glendale	97	16,413.25
FL	Palmetto	70	16,413.25
MD	Laurel	97	16,413.25
MI	Detroit	208	16,413.25
MN	Eagan	159	16,413.25
NY	New York	490	16,413.25
NY	Rochester	180	16,413.25

Example 2

In this example, the Var function is used on the numeric column and break_column. The results are shown in the Computed column.

Var (Amount, State)

Table 172. Var Example 2

State	City	Amount	Computed
AZ	Tucson	112	0
CA	Burbank	240	10,224.50
CA	Glendale	97	10,224.50
FL	Palmetto	70	0
MD	Laurel	97	0
MI	Detroit	208	0
MN	Eagan	159	0
NY	New York	490	48,050.00
NY	Rochester	180	48,050.00