Microsoft Office Development and Consultancy
 Home|

Excel

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

 

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

 
 Returns the number representing the skewness of a distribution.

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

 REMARKS
 
  • The degree of asymmetry of a distribution around its mean.
     
  • Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values.
     
  • Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.
     
  • You can also use a single array or a reference to an array instead of arguments separated by commas.
     
  • The arguments must be either numbers or names, arrays, or references that contain numbers.
     
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
     
  • If there are fewer than three data points, or the sample standard deviation is zero, then #DIV/0! is returned.
     
  • You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=SKEW(3,4,5,2,3,4,5,6,4,7) = 0.360
     

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

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