LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default KURT and SKEW functions

I have 5 independent datasets that I am analyzing with descriptive statistics
and Gaussian (normal) distributions to search for outliers. During the
process, I decided to see if there is a way to €śtest€ť a sample for
€śnormality€ť since Im getting some graphs that do not represent normal
distributions. I want to know why. So, I found the functions KURT and SKEW,
but I need some advice about their significance. I do not understand the
values I am getting from these functions and the help files in Excel 2007 are
not very specific. (I wish they could expand more the description listed
under €śExcel Home Function reference Statistical€ť). This is what they say:

// KURT(number1,number2,...) Returns the kurtosis of a data set. Kurtosis
characterizes the relative peakedness or flatness of a distribution compared
with the normal distribution. Positive kurtosis indicates a relatively peaked
distribution. Negative kurtosis indicates a relatively flat distribution.
Number1, number2, ... are 1 to 255 arguments for which you want to
calculate kurtosis. You can also use a single array or a reference to an
array instead of arguments separated by commas. //

// SKEW(number1,number2,...) Returns the skewness of a distribution.
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.
Number1, number2 ... are 1 to 255 arguments for which you want to calculate
skewness. You can also use a single array or a reference to an array instead
of arguments separated by commas. //

For instance:

My datasets range from 75,00 entries to 13,845 entries. I am getting a
Kurtosis = 0.71808 and Skewness = -0.07325 for one dataset, and Kurtosis =
0.59906 and Skewness = 0.91872 for another one, but I dont know what they
mean.
Can anybody help me to discuss/explain/expand these values?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
graph a normal distribution with skew and kurtosis MarkS Charts and Charting in Excel 9 April 3rd 23 06:59 PM
SKEW and KURT functions Dave F Excel Discussion (Misc queries) 5 December 6th 06 06:49 PM
efficiency: database functions vs. math functions vs. array formula nickname Excel Discussion (Misc queries) 2 July 14th 06 04:26 AM
Looking for a site with functions that substitute the ATP functions Franz Verga Excel Worksheet Functions 3 June 24th 06 04:30 AM
Nesting functions in the functions dialog box cs170a Excel Worksheet Functions 0 June 10th 05 10:36 PM


All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"