Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > VARA

 

VARA(value1 [,value2] [,…])

 
 Returns the compound variance based on a sample.

 value1The first value.
 value2The second optional value.

 REMARKS
 
  • This function assumes that the arguments represent a sample from the population (as opposed to the entire population).
     
  • This is identical to the VAR() function except that text, logical values and errors are included.
     
  • The variance is the average of the square of the deviations.
     
  • If your data represents the entire population, you must compute the variance using VARPA.
     
  • Any values that contain TRUE evaluate to the number 1.
     
  • Any values that contain FALSE evaluate to the number 0.
     
  • You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=VARA(10,20,30,40,50,60) = 350
     

     Functions - V | Index - V | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top