Varp

The Varp function estimates variance based on the entire population.

Varp (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:

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

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

Example

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

Varp (Amount)

Table 173. Varp Example

State

City

Amount

Computed

AZ

Tucson

112

14,589.56

CA

Burbank

240

14,589.56

CA

Glendale

97

14,589.56

FL

Palmetto

70

14,589.56

MD

Laurel

97

14,589.56

MI

Detroit

208

14,589.56

MN

Eagan

159

14,589.56

NY

New York

490

14,589.56

NY

Rochester

180

14,589.56