Jarque-Bera Test of Normality in Excel

[@jeannettecollins2903]

hi, thanks for share. i have one question. in the F3 cell, I think it should be (skewness^2)+(kurtosis^2-3)/4 rather than (skewness^2)+(kurtosis^2)/4

[@xqli4091]

Thanks for your showing, btw why JB =2000 divided by 6? why it is 6? thank you!

[@brianfoltz7344]

XQ LI
I think that is dividing the dist into intervals of standard deviation like creating equal partitions in the dist.
-3 to +3 = count of 6.

[@rsquaregroup9228]

JB originally involved 6 and 24. 6 is related with the variance of Skewness and 24 is related with the variance of Kurtosis.

[@masoudarfi2671]

thank you, i have a question. in cell F2, why didnt you subtract "3" from kurtosis?

[@kenneth1993]

Dont you have to minus 3 from the Kurtosis sample value? since K =3 for normality?
or does the Kurt function in excel shows the excess Kurtosis only?
Thanks in advance for clarifying

[@marcomozombiteshishco7518]

Excel shows the excess of kurtosis.

[@user-xt9js1jt6m]

Really good sir!!
I have a doubt ,
Sometimes I have found cases where SW and KS give totally opposite results. How to handle such cases?

[@angiefranz281]

thank you for this great Video. Helped me a lot as I'm really not that good in statistics. I calculated the JB Test for some monthly Returns and also the p-value. My p-values are for the single assets between 0.25 and 0.87. So am I right if I say that with These p-values all assets are normal distributed?

[@jigmeyoezer9711]

hi, why did u divide the sample size 2000 by 6???

[@冯文彬-g4w]

formulation of jb text

[@necroylside]

Thank You sooo much, excelent explanation by far!.
Greetings from México.

[@eugenietann]

Clear and concise! Thank you for this!

[@earthresident1]

This is so helpful thank you!

[@DrGrande]

You're welcome!

[@slayerblood7894]

Thanks so much!