Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Statistical > VARP

 

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

 
 Calculates variance based on the entire population.

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

 REMARKS
 
  • 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.
     
  • The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (826393).

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

     Functions - V | Index - V | Office Online 2010 | 2007 | 2003 

     © 2013 Better Solutions Limited. All Rights Reserved.Top | 03-Jan-2013