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

 

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

 
 Returns the number representing the skewness of a distribution.

 number1The first number.
 number2The second optional number.

 REMARKS
 
  • Skewness characterizes 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 

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