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

My pleasure!

Thank you for your support!

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

My pleasure!!

Thank you!

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/

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

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

Check this video it might answer what you're looking for ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BrFB91A7Xcg.html

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 socrat_ghadban@yahoo.com so i can check it