Cronbach's Alpha in Excel: Cronbach's Alpha Calculation and Interpretation in Excel (2 methods)

[@richardgucek425]

Thank you VERY much !!!!

[@SocratGhadban]

My pleasure!

[@MohamedIbrahimEid]

Thanks for your valuable contribution.

[@SocratGhadban]

Thank you for your support!

[@mohammadtorjouman9970]

Great video doctor ❤️

[@SocratGhadban]

Thank you Mohamad, I'm glad that you found it beneficial!

[@marianneabbruzzi2024]

Great video! Thank you. What about when you have N/A as an option in the Likert scale?

[@SocratGhadban]

Thank you Marianne, please check this link which shows how to consider when having missing data
www.real-statistics.com/reliability/internal-consistency-reliability/cronbachs-alpha/cronbachs-alpha-with-missing-data/

[@rogiezamoraofficial]

Thank you so much.

[@SocratGhadban]

My pleasure!!

[@RAce-uo7lp]

can i use this in 4point likert scale?

[@SocratGhadban]

This an example just to show the calculation, if you are working on a scientific article, you have to further elaborate the dimensions.. it's a 5 point Likert scale

[@mr.nasser8022]

Thank you for this video, very helpful

[@SocratGhadban]

Thank you!

[@teachermaddiinthemaking1676]

should i include the gender when computing the cronbach alpha?

[@SocratGhadban]

no need, since it's to check the reliability of a specific construct!

[@SocratGhadban]

Check this video it might answer what you're looking for
th-cam.com/video/BrFB91A7Xcg/w-d-xo.html

[@charllotebayransamonte7453]

Need help 🥺 I got negative answer 😢

[@SocratGhadban]

A negative Cronbach's alpha indicates inconsistent coding .. you have to make sure the items are uni-dimensional and having the same direction.. please share your excel [e-mail]
so i can check it