Microsoft Office Development and Consultancy
 Home|

Excel

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

 

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

 
 Returns the standard deviation based on a sample, including text and logical values.

 value1The first value.
 value2(Optional) The second value.

 REMARKS
 
  • The standard deviation is a measure of how widely values are dispersed from the average (or mean) value.
     
  • Arguments that are text or logical values are included.
     
  • This is identical to the STDEV function except that text and logical values are included.
     
  • For large sample sizes, this function will return approximately the same value as the STDEVPA function.
     
  • You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=STDEVA(10,20,30,40) = 12.910
     

     Functions - S | Index - S | Office Online 2013 | 2010 | 2007 | 2003 

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