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

 

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

 
 Returns the standard deviation based on the entire population.

 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).
     
  • You can also use a single array or a reference to an array instead of arguments separated by commas.
     
  • Text and logical values such as True and False are ignored.
     
  • STDEVP assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using STDEV.
     
  • For large sample sizes, STDEV and STDEVP return approximately equal values.
     
  • The standard deviation is calculated using the "biased" or "n" method.
     
  • Using the same data from the STDEV example and assuming that only 10 tools are produced during the production run, STDEVP measures the standard deviation of breaking strengths for all the tools.
     
  • 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 

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