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, 2022 in Others by Kithuzzz
• 38,000 points
578 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.
answered Oct 20, 2022 by narikkadan
• 63,600 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, 2022 in Others by gaurav
• 23,260 points
4,199 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, 2022 in Others by narikkadan
• 63,600 points
733 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,600 points
14,739 views
0 votes
0 answers

Data Driven Framework -- how to read and write in excel sheet using Selenium WebDriver with java

I'm using this code to read something, ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
660 views
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,750 points
1,020 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
1,492 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
1,300 views
0 votes
1 answer

A/B Test statistics

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

answered Feb 18, 2022 in Others by narikkadan
• 63,600 points
677 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, 2022 in Others by narikkadan
• 63,600 points
2,661 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, 2022 in Others by narikkadan
• 63,600 points
536 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