VARP

VARP(number1 [,number2] [..])

Returns the variance based on an entire population.

number1The first number.
number2(Optional) The second number.

REMARKS
* VAR.P was added in Excel 2010 to replace this function.
* This function assumes that the arguments represent the entire population (as opposed to a sample).
* Text and logical values such as True and False are ignored.
* If you do not want to count any arguments that are text or logical values you can use the VARPA function.
* You can have a maximum of 30 arguments.
* You can use the VAR.S function to return the variance based on a sample.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=VARP(10,20,30,40,50,60) = 291.667


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top