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-lg1yj2 жыл бұрын
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.
@jrdomingoc6 жыл бұрын
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-tj2gt5 жыл бұрын
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
@emilygeels98093 жыл бұрын
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-ry1el2 жыл бұрын
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
@passion53565 жыл бұрын
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!!!
@sebastianjanczyk16035 жыл бұрын
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.
@lakhvirnandra80223 жыл бұрын
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!
@honeybabu71494 жыл бұрын
Thank you, as a researcher it help me alot. Very good explanation and step wise description. thank you.
@frostywrathc76406 жыл бұрын
This is exactly what I need for my dissertation, thank you!
@MrInTenz5 жыл бұрын
Thank you very much for the clear explanation of the background and the step by step walkthrough. Highly appreciated.
@thisisyang8203 жыл бұрын
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!
@1Roderik6 жыл бұрын
Very good! Easy to follow your steps, clear instructions. In Dutch i would say: "Cron alfa voor Dummies!"
@MrProjekt20126 жыл бұрын
Thank you so so much! It literally took only 5 minutes!!! 😭🙏🏻
@teslatwitterstreaming3 жыл бұрын
Thank you very much for sharing! Easy to understand and follow what you are teaching! Wish I had someone like you in my university
@pks45705 жыл бұрын
Very helpful. Importantly how to question the questionnaire for redundancy. Great input.
@ghassanmaan33833 жыл бұрын
I feel very grateful for your explanation. Thank you very much!!!!
@ebcpmckmc5 жыл бұрын
Thank you so much for this guide, Sir. Crystal clear.
@gingerf.20473 жыл бұрын
Helping with the dissertation! Thank you!
@boitumelolekoma17814 жыл бұрын
This video is perfect. Very simple to follow and to understand. Thank you sir
@martin415 жыл бұрын
what a wonderful explanation. Keep up the good work!
@paveljanega63013 жыл бұрын
Thank you very much for this video! Best regards from Czech republic :).
@armandomoreno2284 Жыл бұрын
VERY USEFUL, THANK YOU. Greetings from Monterrey, MX
@lisainatree4 жыл бұрын
This is fantastic. Extremely clear. Thanks for sharing!
@rodeemaisejera75836 жыл бұрын
Thank you sir. You were such a blessings. God bless you. This help me big time!
@CoachZain12 жыл бұрын
Thanks a lot for such a great explanation through the spreadsheet. It has helped a lot.
@NAMSarwareAkhtarMamur5 жыл бұрын
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.
@jonsantos60563 жыл бұрын
Thanks for this Cronbach's Alpha explanation. 07:45
@sunirnankoo18524 жыл бұрын
This really helped me. You've really simplified this! Thank you!
@Mike-zu5hm5 жыл бұрын
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.
@anshicaaron805 жыл бұрын
Thankyou sir. God bless you. Wishing my professors were as good as you.
@ararey39756 жыл бұрын
You are my savior! This made things so clear. Now I don't feel so stressed about it. Haha
@severusthegreatest5 жыл бұрын
God same! :)
@dr.truptithorat22512 жыл бұрын
Thank you very for explaining calculating in easy manner.
@mamtajakter65734 жыл бұрын
Great! much appreciate your effort in explaining this topic. I learned. Thanks!
@annscott-williams475411 ай бұрын
It was exceptionally helpful. Thank you so much
@rajkumarbaburaonanaware50005 жыл бұрын
Really a very helpful tool to compute Croncachs alpha . My question is will the reversely scored ( Negative) items interfere?
@helysehuet7373 жыл бұрын
Thank you, you saved my end of year exam
@cjarriola27 күн бұрын
This is actually pretty easy, thanks!
@christauzoamakaalozie-uw-gm4ob5 ай бұрын
Thank you so much, perfect lesson, thank you!
@harshitajethani95474 жыл бұрын
You are the best. No other words.
@cuteuntold2 жыл бұрын
YOU ARE A LEGEND -someone from hrst
@bensonnyabuto60765 жыл бұрын
Easy and simple to follow, thank you.
@vindydog76642 жыл бұрын
Thank you, very clear and concise explanation ❤
@analypilar42853 жыл бұрын
THANKYOU SO MUCH for the information.. I badly needed this, and this is really2 halpful for my research paper sir✨
@freddyjosemoleroramirez4024 жыл бұрын
Thank you so much for this wondrous explanation! I love this video!
@uniquenessexistence2 жыл бұрын
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?
@napemphahlele2943 жыл бұрын
Very useful, a great tool for dissertation. Thanks
@henreittamiranda6283 Жыл бұрын
Thanks for this wonderful video. Thanks for helping me.
@GM-fx2jo6 жыл бұрын
Thanks for this....made it look easy as I had no idea....thanks very much..
@marramal-nassiri43439 ай бұрын
Thanks a million for this useful video!
@cervenymartin48876 жыл бұрын
Thank you. Its a really great video about Cronbach´s alfa. Congrat.
@peaceinjesus20095 жыл бұрын
Sir you have explained it so well. Thank you so much.
@arlanipaterno83583 жыл бұрын
Thank you! It is such a big help for my thesis! heart heart
@briskmelonchon98404 жыл бұрын
God bless you, now I know how to do it at ease
@justinger49582 жыл бұрын
Lord bless you for this😭
@naomiolohoy17263 жыл бұрын
This is very helpful. Thank you very much!
@charlottewilkie16512 жыл бұрын
This was super helpful, thank you!
@talkworkscounsellingcentre36202 күн бұрын
Nice explanation. Thanks
@shaniq193 жыл бұрын
You’re a lifesaver. Thank you!
@RafaelCruzReyes2 жыл бұрын
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.
@hninwai82275 жыл бұрын
This video is very helpful for my thesis. Thank a lot
@harmanpreetsingh33105 жыл бұрын
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.
@jslamata2 жыл бұрын
Nice tutorial very informative and easy to understand. Thank you... :)
@kingsolomon04 жыл бұрын
Thanks a lot . you are an excellent teacher .
@pankhuridubey143 жыл бұрын
Thank you! Well explained.
@JamesGitonga-jq8gg4 ай бұрын
amazing information
@irishluzaura92472 жыл бұрын
This is very helpful. Thank you so much
@abdulazizalanazi25113 жыл бұрын
you saved my a**! thanks a lot brother!
@laviniasimina84274 жыл бұрын
Extremely hopeful! Thank you!!
@genesisvillasana34545 жыл бұрын
Very usefull. This video already helped me a lot of times. Thanks
@jeneviefillartos31032 жыл бұрын
Thank you so much, this helps a lot for my thesis 💚💚💚... 03/02/2021
@ZainalAbidin-os9uw4 жыл бұрын
Thanks a lot for the lecture. Very useful
@CocoBark6 жыл бұрын
Simple and clear! Thank you!
@wiemelmokhtar72106 жыл бұрын
You really saved my life thank you so much
@aymanraouf80106 жыл бұрын
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?
@sarajb953 жыл бұрын
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.
@anishgopal82876 жыл бұрын
Simple and well explained. Thank you
@stephanieterwindt7413 жыл бұрын
This is so helpful! Thank you!
@mimianimation52893 жыл бұрын
Hi, is this method can also be used to find alpha cronbach value for multiple choice questions?
@smritipatra17745 ай бұрын
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
@charanisenaratne56645 жыл бұрын
Thank you so much! This helped me a lot!
@gedionmazuruse79774 жыл бұрын
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 gmazuruse@gmail.com
@ehj99992 жыл бұрын
Is there a standard number of participants in using cronbach alpha?
@bryansinamban81533 жыл бұрын
is it okay to put the answers of the participants in numerical order ? will i still get the same results?
@jadelimbago38802 жыл бұрын
Hi, I'd like to know why the formula used to calculate variance is var.p() instead of var.s()? Thank you!
@RafaelCruzReyes2 жыл бұрын
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.
@MdIshtiaqAhmedTalukder4 жыл бұрын
you save my day. thank you very much.
@liliansalan94384 жыл бұрын
Thank you sir. It is simple and clear explanation. It helps me really HUGE!!!1
@ivarthordal15745 жыл бұрын
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 :-)
@pegahnl83122 жыл бұрын
Thank you so much for this video
@mmmm76564 жыл бұрын
U r greattttt...u have made my thesis easy
@albertogonzales95353 жыл бұрын
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.
@matteolongo69454 жыл бұрын
thank you very much! Perfect!
@jzeezakhele27383 жыл бұрын
Great staff. Thanks.
@UmaMaheswari-cz5el5 жыл бұрын
Thank you for your wonderful explanation
@MBC999able5 жыл бұрын
Clear explanation! Thanks!
@palak_jain3 жыл бұрын
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?
@jeffreysilvano90763 жыл бұрын
Can you help me, I used dichotomous scale but i it has no value in real number how should I do this?