VAR.P function

VAR.P(firstParameter, otherParameters...) VAR.P(firstParameter; otherParameters...)

firstParameter — Number or { Number }

The first parameter.

otherParameters — Number or { Number } (accepts many)

Additional parameters.

Returns — Number

The population variance of the parameters.

Returns the population variance of the parameters. VAR.P(3, 4, 5, 6, 2, 3, 1)VAR.P(3; 4; 5; 6; 2; 3; 1) returns roughly 2.5.

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

Example

VAR.P(3, 4, 5, 6, 2, 3, 1)VAR.P(3; 4; 5; 6; 2; 3; 1)

Returns roughly 2.5.