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

VAR.P

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

Sample Usage

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


Syntax

VAR.P(value1, [value2, ...])

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

Examples

VAR.P(1,2,3,4,5,6,7,8,9,10) returns a value of 8.25.
VAR.P(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, VAR.P will return an error.
  • VAR.P will ignore any cells that include text and logical values. To calculate variance while interpreting text values as 0, use VARPA.
  • VAR.P calculates variance for an entire population. To calculate variance across a sample, use VARS.