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

 

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

 
 Estimates standard deviation based on a sample.

 number1The first number.
 number2The second optional number.

 REMARKS
 
  • The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
     
  • Text and logical values such as True and False are ignored.
     
  • You can have a maximum of 30 arguments.
     
  • If you do not want to count any arguments that are text or logical values you can use the STDEVA() function.
     
  • The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (826349).

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

     Functions - S | Index - S | Office Online 

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