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

VARA

Estimates variance based on a sample, including text and logical values.

Sample Usage

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

Syntax

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

  • value1 - Value or range representing a sample of a population.
  • value2, .. - [OPTIONAL] Additional numerical values or ranges to calculate for the variance.

Examples

VARA(1,2,3,4,5,6,7,8,9,10) returns a value of 9.1666
VARA(A2:A6) returns the variance of the numbers in cells A2 through A6, where the values represent only a sample of all the data.

 

Notes

  • A minimum of two values must be supplied as value arguments. Else, VARA will return an error.
  • VARA sets each text value encountered to 0 for the purpose of calculation. To ignore cells that include text and logical values, use VARS.
  • VARA calculates variance across a sample. To calculate variance for an entire population, use VARPA.