Calculating Cronbach's Alpha in Microsoft Excel Compared to SPSS

This video demonstrates how to calculate Cronbach’s alpha in Excel compared to the calculation in SPSS. Cronbach’s alpha is a measure of internal consistency. It is used to measure scale reliability.

[@ritudsouza9102]

This is really helpful. I have recently started pursuing Business Analytics & for any doubts when I search around, I land on your videos !! Thanks..

[@calvinkantono4946]

Thank you so much Dr. Grande! I have ran out of the free trials for SPSS and I can only use excel. You really helped me a lot with the video!

[@karaannsullivan2363]

Cronbach's Alpha would be useful application for data analysis. Being able to understand the consistencies between items in a set is significant.

[@jemgem9593]

You're a star Todd. Doing my coursework this weekend.. thanks for great explanation to help consolidate my MSc learning so far X

[@adaainthere3382]

this is so helpful esp for online class! statistics is such a pain in the ass.

[@cherishqiu3924]

Thank you so much for sharing! This helps ppl like me a lot, who doesnt have statistics learning background!

[@Moneim1428]

Great help! Thanks Alot
note: in description add link How to compute it by equation

[@purabiphukan4753]

very useful. Thanks. Those who don't have SPSS can do it on Excel

[@nadz_yt]

Thank you soooooo much!! I was struggling with excel since I don't have SPSS and this was more than helpful :)

[@DrGrande]

You're welcome, thanks for watching -

[@crystalcredi5522]

Great video! Just learning about Cronbach's Alpha and will need to know how to apply it as the semester progresses.

[@DrGrande]

I'm glad you found the video helpful - thank you for watching -

[@Bankaizetsy]

Thank you so much, I was totally stumped on how to calculate this for class project observational research study

[@tgnm5194]

Excellent. Thanks.

[@papertranslatepapertransla2163]

thank you so much for this awesome video

[@gregorywoo654]

Thank you for this very helpful video Dr. Grande. Much appreciated!

[@DrGrande]

You're welcome, thanks for watching -

[@mongsm0896]

very useful and to the point, thanks

[@the1whoco0ks]

Hello Dr. Grande, by any chance, do you have an instruction for calculating Cronbach's Alpha using Excel 2011 (Mac Version), your video is easy to follow but the functions or the placements of its functions is different from Windows version and Mac version, thank you in advance!

[@bobbykunnath2057]

Thanks very much Dr. It is very helpful. Much appreciated

[@DrGrande]

You're welcome, thanks for watching -

[@kiransharma1084]

really helpful.. thank you

[@TomasGO85]

Thank you Todd!

[@seungheeyang7351]

Thank you so much Dr. Grande!

[@DrGrande]

You're welcome, thanks for watching -

[@raladwan1605]

Thank you so much really very informative, May I ask you Dr Todd to show us how to calculate confidence interval in excel for the survey? Thank you

[@TheDebik95]

This is a lifesaver. Thank you so much

[@Busyteaching]

This has saved me a lot of time! it is so easy to understand, thank you so much!! I have a question tho, I need to get the alpha of a psychometric test that the answers are yes, no and I don't know, how should i assign values to them? please help :(

[@Huba003]

Thank you for the video, it's very helpful but I have a question.
My questionnaire was constructed as people didn't have to answer all the questions, so I have gaps in the data.
I tried to do what you showed in the video, but it didn't work in the Excel. Do you have maybe any idea how can I solve this problem?

[@caitlinjoosten6192]

Thanks for the easy explanation! Is it always MSerror/MSrow? Or does it change to MSerror/MScolom if your testsubjects are portrayed in the coloms? :)

[@kyledumdum8970]

Thank you for the video. Very helpful

[@DrGrande]

You're welcome!

[@udohunyime1145]

What about if you get a mean sqaure rows value as zero. What will you do?

[@Shamjidkormath]

I have a doubt in cronbatch's alpha test in excel, could you clarify it?

[@manuelaorb]

This is very helpful - thank you! I have one question: The output yields two P-values: one for rows and one for columns. For rows, it is stating significance btw A1, B1, C1, etc. And for columns it is stating significance of A1, A2, A3, etc.... Is that correct?

[@divyarana3637]

Thanks so much. Then if we want a table where how each item in a questionnaire affect the alpha, we need to delete one row at a time and do the calculation again??

[@bonbonableX]

It was really helpful!!! Thank you!

[@DrGrande]

You're welcome, thanks for watching -

[@merisuokas887]

Thank you so much, massive help!

[@DrGrande]

You're welcome, thanks for watching -

[@kevenisiang6916]

Hi sir we have the same problem with Mr./Ms. The Animals of..... How about if the data was based on achievement score, how we input our the data?

[@user-nl3qp3mi1x]

Helpful !!! Thank you very much!!!

[@DrGrande]

You're welcome, thanks for watching -

[@LokGop]

Thank you for this video. In my case i have the problem, that i only have 2 items. How do i get crombachs alpha now?

[@davidr.a.2759]

Thanks! Very helpful

[@DrGrande]

You're welcome, thanks for watching -

[@GEORGE19919]

How to calculate internal consistency of items on excel?

[@Lyn-eg3id]

Hello Dr. Grande. If the numeric data in our data set represent ordered categories, do we still use this procedure for analyzing Cronbach's alpha?

[@sylviakalindi5534]

Very helpful, thanks.

[@DrGrande]

You're welcome!

[@josephchan6826]

Awesome! thanks bro~

[@bekindtooneanother1239]

I am a ug student and I am doing a research using brief cope scale...I want to analyse it...can u plz explain the point of finding cronbachs alpha if u don't mind..

[@anandmkurien]

Dear Sir, thanks for this super video! I have doubt. I have 10 questions using a Likert scale with 150 responses. The Likert scale is 1,2,3 or 4 for each response. Can I use the same method to find the alpha as mentioned in this video? THANKS AGAIN!

[@yarpen26]

Cronbach's alpha was pretty much made with the Likert scale in mind so yeah, by all means you can use this method.

[@eshetunigatu3523]

I would like to say thank u for aver all.

[@nayivassaf]

Really? that easy?? Yessss!!!

[@tengkuizzaarifatengkuanuar3974]

is there any manual calculation for cronbach's alpha??

[@paperprongs2301]

thank you so much!

[@jamesrichardalgie]

Great help!

[@DrGrande]

I am glad you found this video helpful, thanks for watching -

[@theanimalsof4764]

hi sir, what if my test isn't a likert scale it's just achievement tests so basically it's just right or wrong....how do I get my values for each column/row? badly need your help! :(

[@GamerGER]

i am not a professional but i would use the regression method and put 0 for wrong and 1 for right and i would get the correlation concerning a certain goal value. besides you should consult some literature since the best method to use depends on the case you are looking at.

[@rahulmenon6354]

what do we write in variable view ?

[@nusratgulzar938]

Thanks a million!

[@DrGrande]

You're welcome, thanks for watching -

[@saraheme5048]

amazing thanks a bunch!!

[@DrGrande]

You're welcome!

[@Omiad]

Good job

[@DrGrande]

Thank you, and thanks for watching

[@victoriabalajadia9050]

Thank you

[@DrGrande]

You’re welcome!

[@bobmom2951]

Thank u so much

[@DrGrande]

You're welcome, thanks for watching -

[@zihanjj]

Awesome..

[@hariths.liyanagamage4849]

Thanks

[@DrGrande]

You're welcome - thanks for watching.

[@musaalibalawag1892]

thanks a lot...

[@DrGrande]

You are welcome - thank you for watching -

[@sawyersbattleforplushislan7588]

Thank you so much Dr. Grande!