Calculate Cronbach's Alpha in Excel (Reliability in Excel)

[@n1sh1kata44]

This really helped me thanks!!

[@BrandonPhD]

I’m glad!! Thank you.

[@baematsumoto9673]

hi! am I supposed to do the table like you did even though I have 75 respondents? or is there an easier way for this?

[@BrandonPhD]

If you have 75 participants, you need to make sure all 75 are in the table. Essentially, you will add 65 new rows below participant number 10 and above the bottom lines. You will have to adjust the formula to include the new rows. Good luck!

[@michawidawski3226]

You are the best !

[@BrandonPhD]

Thank you!

[@BrandonPhD]

0:00 What is Cronbach’s Alpha? 2:56 When to use? 5:05 Calculating Cronbach’s Alpha in Excel

[@aadiadam]

Thank you for your support. I am getting 1.03 😅

[@nourmakki2575]

this didn't work when I tried it!! what am i doing wrong???

[@BrandonPhD]

Can you explain the issue further?

[@nourmakki2575]

@@BrandonPhD after inputting the cronbachs alpha into excel, my answer was zero when it shouldn't have been. (I had just put in the figures into excel, i didn't calculate them on excel like you did), i dont know if that makes a difference?

[@BrandonPhD]

@nourmakki2575 I’d recommend following the video, try copying the data, and adapting after you get it to work. Good luck!

[@nourmakki2575]

@@BrandonPhD do you mean, do my calculations as you did?

[@BrandonPhD]

@nourmakki2575 Yes