Calculating the Standardized Cronbach's Alpha in Excel

[nomadic_philosophy]

Very easy to understand ! Really helps, Thank you.

[jamani]

Awesome ... very useful ... you explained in v simple way ... thanks

[lenalist]

What does it mean if I have negative numbers and already double checked the coding- could it be if the number of responders are low?

[dariuszruminski]

Thank you for posting your video! It's very valuable. Regards

[nirzarabandekar]

Hello Bobbie, I have three types of questions in my survey, Positive, negative and even. For positive questions I have assigned the likeret scale as 1=Strongly disagree and 5= strongly agree; for negative 1=Strongly agree and 5= Strongly disagree. So what should i code for the even question? Is it 1=Strongly agree, Strongly disagree; 3=Agree, Disagree; and 5= undecided? Can i use this for reverse coding for even questions in the set?

[harmanrai]

Hello, I did the Reverse Coded correctly but after I correlate them it is still coming negative. Any help?

[worknotrest]

Thank you so much. I hope pleasant for you.

[PRCYCLINGFAN]

Hello Bobbie I am trying to validate my questionnaire I ollow what you did but I got weird results on some cells like this.. #DIV/0!
let me know if exist a possibility to send my results. Also how I can do reverse coding because I have a lot on negative numbers...hope you can help me!
Thanks
WIlfred

[pragyarajpoot]

why you have used average variance as 1?

[madpsych]

I thought Cronbach's alpha was a measure of internal consistency reliability, not test-retest reliability.

[zdzislawkes]

Have you tried AVERAGEIF or AVERAGEIFS?
Eg.