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

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

 
 Returns the kurtosis of a data set.

 number1The first number.
 number2The second optional number.

 REMARKS
 
  		• The arguments can be either arrays, cell references or named ranges 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 four data points, then #DIV/0! is returned.
     
  		• If the standard deviation of the sample equals zero, then #DIV/0! is returned.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=KURT(10,20,30,-20) = 1.5
    2=KURT(3,4,5,2,3,4,5,6,4,7) = -0.152
    3=KURT(10,20,30) = #DIV/0!
    4=KURT(10,10,10,10,10) = #DIV/0!
    		 
     Functions - K | Index - K | Office Online 

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