Cronbach's Alpha - Excel

[@Koiboipiet]

I've been looking for this formula in excel for like 24hrs. Thank you so much. It's been very well explained and my questionary is finally calculated.

[@NewLife-lg1yj]

This was really useful to someone I know who needed this.. You're a gifted teacher with a clear, confident voice and that's a great blessing. Thank you.

[@jrdomingoc]

im statistician and i saw some of your videos, they are very good, specially in the easy way to show how understandible are our skills. Congrats!

[@deepikathakur9499]

Hii sir

[@NehaSharma-tj2gt]

I cant thank you enough for this video ! The Cronbach's alpha for a questionnaire I designed turned out to be 0.69, which is thrilling for me, as this was the first questionnaire I ever designed !!! Thanks a bunch for this life saver of a video

[@emilygeels9809]

Thank you so much! My professor gave us a bunch of numbers and told us to calculate something without instructions or walk through. Your video is a life saver!

[@istheyear-ry1el]

great video thank you. For those who are literally have no experience in using excel I suggest for you to mention what you clicked behind the screen example when you typing the =var.p and many more calculation/ it is so that we follow exactly what you did

[@passion5356]

oh my goodness. i've been to other videos and this is the most helpful for sure and is also very easy to understand. thank u very much!!!

[@sebastianjanczyk1603]

dziękuję bardzo za wytłumaczenie na konkretnym przykładzie krok po kroku , Thank you very much for the explanation on a specific example step by step.

[@lakhvirnandra8022]

Oh man you saved me a lot of time. Very nice and precise theoretical and practical information.

[@Pixmmxie]

Thank you so much! I just finished a pilot test and was going to do this in SAS but this was so much better! Thank you!

[@honeybabu7149]

Thank you, as a researcher it help me alot. Very good explanation and step wise description. thank you.

[@frostywrathc7640]

This is exactly what I need for my dissertation, thank you!

[@MrInTenz]

Thank you very much for the clear explanation of the background and the step by step walkthrough. Highly appreciated.

[@thisisyang820]

Good day, Dr. Todd. Thank so much for such a brief yet clear explanation on reliability. I'm currently doing my research paper. You are such a big help. Thank you!

[@1Roderik]

Very good! Easy to follow your steps, clear instructions. In Dutch i would say: "Cron alfa voor Dummies!"

[@MrProjekt2012]

Thank you so so much! It literally took only 5 minutes!!! 😭🙏🏻

[@teslatwitterstreaming]

Thank you very much for sharing! Easy to understand and follow what you are teaching! Wish I had someone like you in my university

[@pks4570]

Very helpful. Importantly how to question the questionnaire for redundancy. Great input.

[@ghassanmaan3383]

I feel very grateful for your explanation. Thank you very much!!!!

[@ebcpmckmc]

Thank you so much for this guide, Sir. Crystal clear.

[@gingerf.2047]

Helping with the dissertation! Thank you!

[@boitumelolekoma1781]

This video is perfect. Very simple to follow and to understand. Thank you sir

[@martin41]

what a wonderful explanation. Keep up the good work!

[@paveljanega6301]

Thank you very much for this video! Best regards from Czech republic :).

[@armandomoreno2284]

VERY USEFUL, THANK YOU. Greetings from Monterrey, MX

[@lisainatree]

This is fantastic. Extremely clear. Thanks for sharing!

[@rodeemaisejera7583]

Thank you sir. You were such a blessings. God bless you. This help me big time!

[@CoachZain1]

Thanks a lot for such a great explanation through the spreadsheet. It has helped a lot.

[@NAMSarwareAkhtarMamur]

that's too helpful. I am a non stat background and it was difficult for me to follow teacher in my banking class. But, I could easily follow you. Thanks a lot.

[@jonsantos6056]

Thanks for this Cronbach's Alpha explanation. 07:45

[@sunirnankoo1852]

This really helped me. You've really simplified this! Thank you!

[@Mike-zu5hm]

For example, if I had a multiple choice(MC) test in trigonometry, and I want to compute the cronbach's alpha. What data should be entered in a cell? In a likert scale we entered 1-5, how about in a MC test. Hope you can help me. Thanks a lot.

[@anshicaaron80]

Thankyou sir. God bless you. Wishing my professors were as good as you.

[@ararey3975]

You are my savior! This made things so clear. Now I don't feel so stressed about it. Haha

[@severusthegreatest]

God same! :)

[@dr.truptithorat2251]

Thank you very for explaining calculating in easy manner.

[@mamtajakter6573]

Great! much appreciate your effort in explaining this topic. I learned. Thanks!

[@annscott-williams4754]

It was exceptionally helpful. Thank you so much

[@rajkumarbaburaonanaware5000]

Really a very helpful tool to compute Croncachs alpha . My question is will the reversely scored ( Negative) items interfere?

[@helysehuet737]

Thank you, you saved my end of year exam

[@cjarriola]

This is actually pretty easy, thanks!

[@christauzoamakaalozie-uw-gm4ob]

Thank you so much, perfect lesson, thank you!

[@harshitajethani9547]

You are the best. No other words.

[@cuteuntold]

YOU ARE A LEGEND -someone from hrst

[@bensonnyabuto6076]

Easy and simple to follow, thank you.

[@vindydog7664]

Thank you, very clear and concise explanation ❤

[@analypilar4285]

THANKYOU SO MUCH for the information.. I badly needed this, and this is really2 halpful for my research paper sir✨

[@freddyjosemoleroramirez402]

Thank you so much for this wondrous explanation! I love this video!

[@uniquenessexistence]

If am right, I think this is measuring the consistency between questions, is it possible to transpose the subject and the questions then apply the same formula to measure the consistency between subjects?

[@napemphahlele294]

Very useful, a great tool for dissertation. Thanks

[@henreittamiranda6283]

Thanks for this wonderful video. Thanks for helping me.

[@GM-fx2jo]

Thanks for this....made it look easy as I had no idea....thanks very much..

[@marramal-nassiri4343]

Thanks a million for this useful video!

[@cervenymartin4887]

Thank you. Its a really great video about Cronbach´s alfa. Congrat.

[@peaceinjesus2009]

Sir you have explained it so well. Thank you so much.

[@arlanipaterno8358]

Thank you! It is such a big help for my thesis! heart heart

[@briskmelonchon9840]

God bless you, now I know how to do it at ease

[@justinger4958]

Lord bless you for this😭

[@naomiolohoy1726]

This is very helpful. Thank you very much!

[@charlottewilkie1651]

This was super helpful, thank you!

[@talkworkscounsellingcentre3620]

Nice explanation. Thanks

[@shaniq19]

You’re a lifesaver. Thank you!

[@RafaelCruzReyes]

Great video and explanation. Thank you very much. Just one comment: Using var.s instead of var.p function in excel I got exactly the same results as in SPSS.

[@hninwai8227]

This video is very helpful for my thesis. Thank a lot

[@harmanpreetsingh3310]

Can Chronback alpha be used for Multiple choice questions with one correct answer)? I have seen examples of usage of Likert scale only with Chronback alpha to test the reliability of a test, but I want to test the reliability of Type: Multiple choice questions with one correct answer. Please help if possible.

[@jslamata]

Nice tutorial very informative and easy to understand. Thank you... :)

[@kingsolomon0]

Thanks a lot . you are an excellent teacher .

[@pankhuridubey14]

Thank you! Well explained.

[@JamesGitonga-jq8gg]

amazing information

[@irishluzaura9247]

This is very helpful. Thank you so much

[@abdulazizalanazi2511]

you saved my a**! thanks a lot brother!

[@laviniasimina8427]

Extremely hopeful! Thank you!!

[@genesisvillasana3454]

Very usefull. This video already helped me a lot of times. Thanks

[@jeneviefillartos3103]

Thank you so much, this helps a lot for my thesis 💚💚💚... 03/02/2021

[@ZainalAbidin-os9uw]

Thanks a lot for the lecture. Very useful

[@CocoBark]

Simple and clear! Thank you!

[@wiemelmokhtar7210]

You really saved my life thank you so much

[@aymanraouf8010]

I have a certain topic that I am trying to do a likert scale of how complex the topic is. So I set up some questions to test the level of complexity for each question. if i get an alpha score of 0.9 that means I can conclude there is internal consistency that the respondents found the certain topic being complex. Is this correct?

[@sarajb95]

I have a question if I'm using an already validated questionnaire (that was already tested for having a good Chronbach alpha value) do I need to repeat the test again and calculate a Chronbach's alpha value based on my results? I really hope someone could answer me :)! And thank you so much for the helpful video.

[@anishgopal8287]

Simple and well explained. Thank you

[@stephanieterwindt741]

This is so helpful! Thank you!

[@mimianimation5289]

Hi, is this method can also be used to find alpha cronbach value for multiple choice questions?

[@smritipatra1774]

I can't do it. When I want to do variance like =var.p( ) then result is not come and when I go to carcade then saw that the formula contains unrecognised text.pleae tell me what I can do

[@charanisenaratne5664]

Thank you so much! This helped me a lot!

[@gedionmazuruse7977]

What about entering say 300 respondents in SPSS for Cronbach's alpha test.I mean say 320 respondents say yes, how do you code that in SPSS. Please assist, you can send the reply on [e-mail]

[@ehj9999]

Is there a standard number of participants in using cronbach alpha?

[@bryansinamban8153]

is it okay to put the answers of the participants in numerical order ? will i still get the same results?

[@jadelimbago3880]

Hi, I'd like to know why the formula used to calculate variance is var.p() instead of var.s()? Thank you!

[@RafaelCruzReyes]

I just did that comment. If you use var.s you´ll get the exactly same result as using SPSS. I tried with var.p and I got differences.

[@MdIshtiaqAhmedTalukder]

you save my day. thank you very much.

[@liliansalan9438]

Thank you sir. It is simple and clear explanation. It helps me really HUGE!!!1

[@ivarthordal1574]

Hi. great video. There is something I cant get right. Can anyone help please. How can the variance of the total score be 546 when the sums are between 14 and 70? Thanks :-)

[@pegahnl8312]

Thank you so much for this video

[@mmmm7656]

U r greattttt...u have made my thesis easy

[@albertogonzales9535]

How will we be able to know which questions is to be removed to increase alpha

[@markzuccberg8926]

My spss broke so thanks for this tutorial.

[@matteolongo6945]

thank you very much! Perfect!

[@jzeezakhele2738]

Great staff. Thanks.

[@UmaMaheswari-cz5el]

Thank you for your wonderful explanation

[@MBC999able]

Clear explanation! Thanks!

[@palak_jain]

My Cronbach's Alpha is around 0.79 Is it valid? This is for my thesis, so I hope it will work.

[@arifahmardiningrum9983]

Hallo. Why do you use VAR.P? Is it because you used all data of the whole population? If I measure the Cronbach Alpha of a sample taken from a population, should I use VAR or VAR.S?

[@jeffreysilvano9076]

Can you help me, I used dichotomous scale but i it has no value in real number how should I do this?