VAR.S function

VAR.S (First, Other...) VAR.S (First; Other...)

First

The first number or array of numbers.

Additional numbers or arrays of numbers.

Number Number

The sample variance of the parameters.

Returns the sample variance of the parameters. VAR.S (3, 4, 5, 6, 2, 3, 1) VAR.S (3; 4; 5; 6; 2; 3; 1) returns roughly 3.0.

VAR.S only accepts numbers, or number arrays. Use VARA instead of you also need to evaluate logical values and text strings representing numbers.

VAR.S (3, 4, 5, 6, 2, 3, 1)

VAR.S (3; 4; 5; 6; 2; 3; 1)

Returns roughly 3.0.