Spread 8.0 Documentation
VARP
Support Options
Formula Reference > Built-In Functions > VARP

Glossary Item Box

VARP


Name

Variance of population

Description

Calculates variance based on the entire population.

Syntax

VARP(value1, value2, . . . )

Remarks

Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.

The variance returns how spread out a set of data is.

The VARP function assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the variance using the VAR function.

The VARP function uses the following formula to calculate the variance:

See also AVERAGE, STDEV, STDEVP, and VAR.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

VARP(R1C2,100,R2C5,102)
VARP(B3,C4,B2,D10,E5)
VARP(A1:A9)
VARP(98,85,76,87,92,89,90)=39.2653061224

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.