TRUECALC
Functions

VAR.S

Sample variance

Try it

When to use it

When should I use VAR.S?

Use VAR.S (the modern equivalent of VAR) to compute sample variance with Bessel's correction when your values are a random sample drawn from a larger population — it is the preferred function in new spreadsheets over the legacy VAR.

Used in

science · operations

Syntax

VAR.S(value1,...)

Examples

=VAR.S(1,2,3,4,5,6,7,8,9,10) // => 9.166666666666666
=VAR.S(2,4,4,4,5,5,7,9) // => 4.571428571428571

VAR.P

Population variance

VARA

Sample variance including text and logical values

On this page

Try itWhen to use itWhen should I use VAR.S?Used inSyntaxExamples