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.

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

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

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

[@lakhvirnandra8022]

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

[@honeybabu7149]

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

[@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.

[@MrProjekt2012]

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

[@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.

[@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!!!

[@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!

[@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!

[@boitumelolekoma1781]

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

[@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.

[@helysehuet737]

Thank you, you saved my end of year exam

[@martin41]

what a wonderful explanation. Keep up the good work!

[@ebcpmckmc]

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

[@ghassanmaan3383]

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

[@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.

[@paveljanega6301]

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

[@1Roderik]

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

[@lisainatree]

This is fantastic. Extremely clear. Thanks for sharing!

[@CoachZain1]

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

[@sunirnankoo1852]

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

[@armandomoreno2284]

VERY USEFUL, THANK YOU. Greetings from Monterrey, MX

[@annscott-williams4754]

It was exceptionally helpful. Thank you so much

[@anshicaaron80]

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

[@jonsantos6056]

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

[@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.

[@gingerf.2047]

Helping with the dissertation! Thank you!

[@rajkumarbaburaonanaware5000]

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

[@dr.truptithorat2251]

Thank you very for explaining calculating in easy manner.

[@rodeemaisejera7583]

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

[@ararey3975]

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

[@severusthegreatest]

God same! :)

[@cuteuntold]

YOU ARE A LEGEND -someone from hrst

[@arlanipaterno8358]

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

[@henreittamiranda6283]

Thanks for this wonderful video. Thanks for helping me.

[@cjarriola]

This is actually pretty easy, thanks!

[@christauzoamakaalozie-uw-gm4ob]

Thank you so much, perfect lesson, thank you!

[@genesisvillasana3454]

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

[@chathurangagamage18]

Thank you, very clear and concise explanation ❤

[@hninwai8227]

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

[@mamtajakter6573]

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

[@freddyjosemoleroramirez402]

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

[@peaceinjesus2009]

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

[@charlottewilkie1651]

This was super helpful, thank you!

[@marramal-nassiri4343]

Thanks a million for this useful video!

[@cervenymartin4887]

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

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

[@analypilar4285]

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

[@GM-fx2jo]

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

[@naomiolohoy1726]

This is very helpful. Thank you very much!

[@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.

[@albertogonzales9535]

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

[@ehj9999]

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

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

[@irishluzaura9247]

This is very helpful. Thank you so much

[@abdulazizalanazi2511]

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

[@jeffreysilvano9076]

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

[@mmmm7656]

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

[@wiemelmokhtar7210]

You really saved my life thank you so much

[@napemphahlele294]

Very useful, a great tool for dissertation. Thanks

[@bryansinamban8153]

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

[@ivanavukcevic5289]

May I know why I am getting variances 0.3xxx instead of 3.xxxx?

[@kingsolomon0]

Thanks a lot . you are an excellent teacher .

[@jslamata]

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

[@harshitajethani9547]

You are the best. No other words.

[@briskmelonchon9840]

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

[@Duncanwg7]

What do you do if one or more participant leave a question blank or don't want to answer?

[@awsadeomoba4639]

Is refugee a commodity to be imported?

[@areeshatanya7452]

This is a great video sir, can you please tell me how to calculate mean and sd on similar data (i.e., using a scale).

[@bensonnyabuto6076]

Easy and simple to follow, thank you.

[@markzuccberg8926]

My spss broke so thanks for this tutorial.

[@vatsalthebest]

Please provide the time stampes for your videos

[@lakhvirnandra8022]

Hello sir can you make a video on how to calculate the Pearson correlation of the same data that is likert scale i need it. I have a dissertation to complete

[@mimianimation5289]

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

[@liliansalan9438]

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

[@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.

[@palak_jain]

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

[@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.

[@justinger4958]

Lord bless you for this😭

[@catherinew3878]

Fantastic thanks. how do you factor in missing Likert data?

[@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]

[@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.

[@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 :-)

[@jornkarlsson8298]

Question: how can the variance of the total scores be 546 when the highest score is 70?

[@elvinasaral6459]

It is variance not standard deviation , if you google the formula of variance you would see that we are computing variance with usage of squares therefore you can get a higher number than the numbers in your sample

[@talkworkscounsellingcentre3620]

Nice explanation. Thanks

[@ZainalAbidin-os9uw]

Thanks a lot for the lecture. Very useful

[@jeneviefillartos3103]

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

[@uthmanzubairoluwatos]

Assuming there's a redundancy in my questionnaire, how will I know which of the question need to be removed or adjust.

[@shaniq19]

You’re a lifesaver. Thank you!

[@jeffreysilvano9076]

I have a question sir, how can i indicate the yes or no in the data? Is it also similar to what you did?

[@AbdullahBilik]

why is the variance of total score such a high number like 546?

[@JamesGitonga-jq8gg]

amazing information

[@richasharma8241]

so much helpful!! thank you so much !!

[@stephanieterwindt741]

This is so helpful! Thank you!