Statistical Kurtosis in relation to SPSS and MS excel

0 votes

For my data set, I am utilizing SPSS as a statistical analysis tool. Regarding the kurtosis idea and the data produced by SPSS and Excel, I have a few questions. Please clarify the following understandings and ask further questions:

  1. Kurtosis is a measure of flatness or peakness (hump) around the mean in the distribution. In terms of distribution tails, it tells whether the dataset is heavy-tailed or light-tailed relative to a normal distribution.

  2. A normal distribution has a kurtosis of exactly 3 (excess kurtosis of exactly 0 which is Kurt-3) and is also called a mesokurtic distribution. A distribution with high kurtosis will have its peak bigger than the mesokurtic peak and is called as leptokurtic A distribution with low kurtosis will have its peak smaller than a mesokurtic peak and is called as platykurtic.

Questions:

  1. What does it mean by excess kurtosis and what is the significance of using it? I am not getting a clear picture between kurtosis and excess kurtosis except that excess kurtosis is kurtosis-3 so we take 0 as a baseline.

  2. SPSS tool generates "excess kurtosis" values or simple "kurtosis" values? In other words what baseline do we generally consider in SPSS for kurtosis measurement and inference? Is it 0 or 3? In SPSS I am getting a kurtosis of 1.16. So if I consider 3 as the baseline then 1.16 is less than 3 and so my distribution could be platykurtic. But if I consider the baseline as 0 (excess kurtosis), then 1.16 is clearly greater than 0 and so my distribution could be leptokurtic.

  3. How it works out in excel again? Does the excel formula internally compute kurtosis as (Kurt - 3) or simple Kurt? I mean how to infer the result in MS excel too (baseline 3 or 0)?

Oct 20 in Others by Kithuzzz
• 20,660 points
39 views

1 answer to this question.

0 votes

Kurtosis does not measure "peakedness" or "height" of a distribution. It measures (potential) outliers (rare, extreme observations) only. For a clear explanation, please see here: https://en.wikipedia.org/wiki/Talk:Kurtosis#Why_kurtosis_should_not_be_interpreted_as_.22peakedness.22

answered Oct 20 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
281 views
0 votes
1 answer

Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
46 views
0 votes
1 answer
0 votes
0 answers
0 votes
1 answer

Statistical Power of Sensitivity

Sensitivity is commonly used to validate the ...READ MORE

answered Jul 13, 2018 in Data Analytics by CodingByHeart77
• 3,740 points
458 views
0 votes
2 answers

Significance of P-value in statistical data

Refer the following points explaining the significance ...READ MORE

answered Aug 10, 2018 in Data Analytics by Atul
• 180 points
469 views
0 votes
1 answer

What is the difference between R and SPSS?

One of the main difference is R ...READ MORE

answered Dec 11, 2018 in Data Analytics by Maverick
• 10,840 points
643 views
0 votes
1 answer

A/B Test statistics

use the Beta distributions for this approach ...READ MORE

answered Feb 18 in Others by narikkadan
• 37,660 points
71 views
0 votes
1 answer

How to Freeze Top Row and Apply Filter in Excel Automation with C#

Try this: // Fix first row workSheet.Activate(); workSheet.Application.ActiveWindow.SplitRow = 1; workSheet.Application.ActiveWindow.FreezePanes ...READ MORE

answered Oct 22 in Others by narikkadan
• 37,660 points
120 views
0 votes
1 answer

I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

answered Oct 27 in Others by narikkadan
• 37,660 points
42 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP