VAR.S function
VAR.S(First,
Other...) VAR.S(First;
Other...)
First
Number or { Number }
The first parameter.
Other
Number or { Number } (accepts many)
Additional parameters.
Returns
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.
Example
VAR.S(3, 4, 5, 6, 2, 3,
1)VAR.S(3; 4; 5; 6; 2; 3;
1)
Returns roughly 3.0.