Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

VARP

Calculates variance based on an entire population. It ignores logical values and text in the sample.

Sample Usage

VARP(1,2,3,4,5,6,7,8,9,10)
VARP(A2:A6)


Syntax

VARP(value1, [value2, ...])

  • value1 - Numerical value or range representing an entire population.
  • value2, .. - [OPTIONAL] Additional numerical values or ranges to calculate for the variance.

Examples

VARP(1,2,3,4,5,6,7,8,9,10) returns a value of 8.25.
VARP(A2:A6) returns the variance of the numbers in cells A2 through A6.

 

Notes

  • A minimum of two values must be supplied as value arguments. Else, VARP will return an error.
  • VARP will ignore any cells that include text and logical values. To calculate variance while interpreting text values as 0, use VARPA.
  • VARP calculates variance for an entire population. To calculate variance across a sample, use VARS.