Statistics Practical: Kurtosis and Skewness (TU BBA 3rd Semester)1 min read

  • 4
    Shares

Calculate Kurtosis and Skewness from the given data in Excel.

Rangef
0-101
10-207
20-3014
30-407
40-501

Formula Recalling:

Kurtosis = (Quartile Deviation)/(P90 -P10)=(Q3 -Q1)/2(P90-P10)

Skewness =(Mean -Mode)/Standard deviation (σ)

Step 1

Calculating quatile 1 (Q1), quartile 3 (Q3), P10, P90, Mean, Mode, and Standard Deviation

Quartile 1 and Quartile 3

Quartile 1
Q1 item7.5=(D17/4)
Q1 class10-20 
Q119.286=B13+(B20-F12)/D13*(C13-B13)
   
Quartile 3
Q3 item22.5 
Q3 class30-40 
Q330.714=B15+(B25-F14)/D15*(C15-B15)

Source: Excel 2013

Percentile 10 and Percentile 90

Percentile 10
P10 item3 
P10 class10-20 
P1012.86=B13+(E20-F12)/D13*(C13-B13)
   
Percentile 90
P90 item27 
P90 class30-40 
P9037.14=B15+(E25-F14)/D15*(C15-B15)

Source: Excel 2013

Mean, Standard Deviation, and Mode

Model calculation

Model Class20-30[Highest frequency class]
Mode25=L+((f(1)-f(0))/(2*f(1)-f(0)-f(2)))*(C14-B14)

Source: Excel 2013

Mean25
SD8.5635

To know the calculation procedure of mean and standard deviation, click here.

Step 2

Calculating Kurtosis

Kurtosis0.2353=(Q3-Q1)/(2*(P90-P10))

Source: Excel 2013

Calculating Skewness

Sk=(Mean-Mode)/Standard Deviation

Source: Excel 2013

Conclusion

we follow two steps in calculating skewness and kurtosis.

For more clarification, watch our video tutorial


  • 4
    Shares
READ  Download notes of MIS (BBA Third Semester)

Leave a Reply

avatar
  Subscribe  
Notify of

StudyDeeper

I enjoy sharing ideas, knowledge, and information. I believe that "sharing of knowledge removes the barriers of expansion of one's knowledge."
Close Menu