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

 

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

 
 Estimates standard deviation based on a sample.

 value1The first value.
 value2The second optional value.

 REMARKS
 
  • This is identical to the STDEV() function except that text and logical values are included.
     
  • You can have a maximum of 30 arguments.

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

     Functions - S | Index - S | Office Online 

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