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

VARPA

Calculates the variance based on an entire population. Text and logical values are included in the calculation.

Sample Usage

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

Syntax

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

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

Examples

VARPA(1,2,3,4,5,6,7,8,9,10) returns a value of 8.25.
VARPA(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, VARPA will return an error.
  • VARPA sets each text value encountered to 0 for the purpose of calculation. To ignore cells that include text and logical values, use VARP.
  • VARPA calculates variance for an entire population. To calculate variance across a sample, use VARA.