VAR
Calculates the variance based on a sample.
Sample usage
VAR(1,2,3,4,5,6,7,8,9,10)
VAR(A2:A100)
Syntax
VAR(value1, [value2, ...])

value1
– The first value or range of the sample. 
value2, ...
– Additional values or ranges to include in the sample.
Notes

Although
VAR
is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function. 
If the total number of values supplied as
value
arguments is not at least two,VAR
will return the#NUM!
error. 
VAR
will return an error if all of thevalue
arguments are text. To calculate variance while interpreting text values as0
, useVARA
. 
VAR
calculates variance for a sample. To calculate variance across an entire population, useVARP
. 
VAR
takes the sum of the squares of each value's deviation from the mean and divides by the number of such values minus one. This differs from the calculation of variance across an entire population in that the latter divides by the size of the data set without subtracting one.
See also
VARPA
: Calculates the variance based on an entire population, setting text to the value `0`.
VARP
: Calculates the variance based on an entire population.
VARA
: Calculates the variance based on a sample, setting text to the value `0`.
STDEVPA
: Calculates the standard deviation based on an entire population, setting text to the value `0`.
STDEVP
: Calculates the standard deviation based on an entire population.
STDEVA
: Calculates the standard deviation based on a sample, setting text to the value `0`.
STDEV
: Calculates the standard deviation based on a sample.
SKEW
: Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
KURT
: Calculates the kurtosis of a dataset, which describes the shape and in particular the "peakedness" of that dataset.
DVARP
: Returns the variance of an entire population selected from a database tablelike array or range using an SQLlike query.
DVAR
: Returns the variance of a population sample selected from a database tablelike array or range using an SQLlike query.
DSTDEVP
: Returns the standard deviation of an entire population selected from a database tablelike array or range using an SQLlike query.
DSTDEV
: Returns the standard deviation of a population sample selected from a database tablelike array or range using an SQLlike query.
DEVSQ
: Calculates the sum of squares of deviations based on a sample.
AVEDEV
: Calculates the average of the magnitudes of deviations of data from a dataset's mean.