Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Statistical > STDEVP

 

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

 
 Returns the standard deviation based on the entire population.

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

 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 ignored.
     
  • If you want to count any arguments that are text or logical values you can use the STDEVPA() function.
     
  • You can also use a single array or a reference to an array instead of arguments separated by commas.
     
  • The standard deviation is calculated using the "biased" or "n" method.
     
  • 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 (826406).

     EXAMPLES
     
     A
    1=STDEVP(10,20,30,40) = 11.180
     

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

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top