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.

[calvinkantono]

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!

[jemgem]

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

[karaannsullivan]

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

[ritudsouza]

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

[Moneim]

Great help! Thanks Alot

note: in description add link How to compute it by equation

[adaainthere]

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

[purabiphukan]

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

[Bankaizetsy]

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

[crystalcredi]

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

[thewhocoks]

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!

[cherishqiu]

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

[nadz_yt]

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

[Huba]

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?

[papertranslatepapertransla]

thank you so much for this awesome video

[caitlinjoosten]

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? :)

[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?

[raladwan]

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

[gregorywoo]

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

[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 :(

[divyarana]

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??