How To... Calculate Cronbach's Alpha in Excel

Learn how to calculate, use, and interpret Cronbach's Alpha as a test of reliability in simple steps.

Пікірлер: 73

  • @aimeesjournal
    @aimeesjournal2 жыл бұрын

    this video is easily understood and precise, I can’t thank you enough Professor- may your life be filled with glee and blessings all the way!

  • @abdullahalghamdi8005
    @abdullahalghamdi80053 жыл бұрын

    Clear, concise and straight to the point. Thank you very much Prof. Eugene.

  • @adafunk
    @adafunk Жыл бұрын

    Finally, someone who explained why the Crombach's Alpha is necessary in a clear way!!! Thank you!

  • @grampzoedien4571
    @grampzoedien4571 Жыл бұрын

    Very very clear presentation, The flow of the explanation is smooth and very easy to understand. Thank you very much!!!

  • @flourescelleaustria9807
    @flourescelleaustria98072 жыл бұрын

    this might help enough my study for the test of reliability, its so easy to understand. thank you Professor Eugene!

  • @kennethpael4359
    @kennethpael43592 жыл бұрын

    Thank you, Professor. This was certainly helpful and easy to follow.

  • @TimeBeforeDawn
    @TimeBeforeDawn7 ай бұрын

    Thank you!!!! I've been stressing myself trying to find software to do this, when all I needed was someone to explain to me how to make use of my variance data.

  • @theradicalbehaviourist
    @theradicalbehaviourist8 ай бұрын

    This has helped me with my ABA work (I'm creating a TPB questionnaire on engaging in life skills for adults with mild IDD as part of a current skills assessment using the COM-Bmodel) and I found this so palatable and easy to understand 🎉

  • @leosimangca2904
    @leosimangca29042 жыл бұрын

    Thank you so much for the most easiest way to calculate the Alpha. God bless you!

  • @martriad
    @martriad3 жыл бұрын

    very clear and understood. thank you very much prof. Eugene.

  • @brigittesnelson2354
    @brigittesnelson2354 Жыл бұрын

    Your video is helping me finish my thesis! Thank you so much

  • @jamieparslow-williams7567
    @jamieparslow-williams7567 Жыл бұрын

    This is explained really well, thank you for making it so clear and using an example to show this.

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    You're very welcome!

  • @Armada0500
    @Armada0500 Жыл бұрын

    This video is an illustration of the word "concise". Well done.

  • @Dibbles13
    @Dibbles13 Жыл бұрын

    you are getting me through my psych stats math! Thank goodness for you

  • @1717blabla
    @1717blabla2 жыл бұрын

    Thank you very much Professor Eugene!

  • @OluwatoyinRoselineAjewole
    @OluwatoyinRoselineAjewole Жыл бұрын

    This totally helped. Thank you!

  • @hollyleeth4317
    @hollyleeth4317 Жыл бұрын

    Thank you so much for this video! I have been overwhelmed trying to understand how to calculate reliability for my grad school research results, and this helped my non-statistical brain so much!

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    You are so welcome!

  • @dananjayathathsara7884
    @dananjayathathsara78842 жыл бұрын

    thank you Eugene .. god bless you .. you saved my day

  • @LearningWithRobert
    @LearningWithRobert Жыл бұрын

    Thank you so much for such a clear and easy to follow video!

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    Glad it was helpful!

  • @nitinchaudhary8804
    @nitinchaudhary880411 ай бұрын

    What an explanation! Thanks a lot!

  • @MorraLoop
    @MorraLoop9 ай бұрын

    Fantastic Video, it helped me so much, thank you!

  • @OolaghenNULLETHENBY
    @OolaghenNULLETHENBY Жыл бұрын

    so clear, thanks a lot for the explanation - never been so easy!

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    Glad it helped!

  • @rahamathsumith9686
    @rahamathsumith9686Ай бұрын

    Thank you so much Prof🙏. Very informative for all beginners .....

  • @supbar2007
    @supbar20073 жыл бұрын

    Thanks Prof. Up until now i thought to get these value, spss was the only way...

  • @user-u64251o
    @user-u64251o3 жыл бұрын

    I do have a question, do you use your actual survey questionnaire to the sample that you are going to be using in determining the reliability?

  • @manweed5999
    @manweed5999 Жыл бұрын

    Thank you very much for this simple and concise tutorial, you really saved me for my uni project 😤😤😤

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    Glad it helped!

  • @merlynnachor8410
    @merlynnachor841010 ай бұрын

    hello Prof Eugene, it's very helpful. Do you still have other videos of the computation of reliability?

  • @julietambali
    @julietambali Жыл бұрын

    Great lesson.

  • @priyasadar71
    @priyasadar714 ай бұрын

    Best explanation!

  • @apriljoydelima2395
    @apriljoydelima23952 ай бұрын

    Thank you so much sir!

  • @gilbertjaymolina9915
    @gilbertjaymolina99155 ай бұрын

    Currently working on my Thesis which focuses on the SDGs (Sustainable Developmental Goals) and I did some of the interpretation, just got to have it checked with my professor to see if I did it correctly. Will edit for any updates.

  • @mathijnvandijk5505
    @mathijnvandijk5505 Жыл бұрын

    thank you mr legend

  • @sukanyaroy9508
    @sukanyaroy95085 ай бұрын

    VERY WELL EXPLAINED

  • @lanceelopezz223
    @lanceelopezz223 Жыл бұрын

    Thank you, sir!

  • @l.a.xbeast8502
    @l.a.xbeast8502 Жыл бұрын

    Cheers man! Saved me having to learn SPSS. I realise now SPSS is just a poor man's excel. Helped out a final year dissertation student :D

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    Glad it helped!

  • @user-st7pi2zv8p
    @user-st7pi2zv8p Жыл бұрын

    very useful thank you

  • @ahmadfahmimohdhussain3187
    @ahmadfahmimohdhussain31878 ай бұрын

    thanks so much!

  • @jaynajwa0007
    @jaynajwa0007 Жыл бұрын

    Thank you, thank you, thank you.... 1000x thank you!

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    Welcome!

  • @alsaeedahgreenland9248
    @alsaeedahgreenland92483 жыл бұрын

    thank you so mauch

  • @kalilwarren6982
    @kalilwarren69822 ай бұрын

    I noticed that in the formula that the variances and sum of variance are squared but you didn't square them when you wrote the equation. Was that on purpose or is it an error?

  • @user-uz5tu7sq6q
    @user-uz5tu7sq6q4 ай бұрын

    Thanku so much sir ❤🙏

  • @MarcinaRiley
    @MarcinaRiley Жыл бұрын

    Thanks!

  • @anilsbilimale9537
    @anilsbilimale95372 жыл бұрын

    How to calculate if two observers did piloting for same subjects on different days?

  • @adityajain8727
    @adityajain87272 жыл бұрын

    I've implemented the formula as explained in this video on my sample but cronbach's alpha value is coming to be negative. What do I do?

  • @poojakadian7652

    @poojakadian7652

    2 ай бұрын

    Mera bhi

  • @aparnanair4123
    @aparnanair41232 жыл бұрын

    Explained very well. Thanks!

  • @hazelbolonos5914
    @hazelbolonos59147 ай бұрын

    What is your formula to get the variance of the total column?

  • @lindaomoefe4156
    @lindaomoefe41562 жыл бұрын

    Thank you

  • @Dsxdx
    @Dsxdx18 күн бұрын

    You didn’t use the squared was that an oversight or it is not needed?

  • @missgamilaa
    @missgamilaa Жыл бұрын

    Thank you!

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    Welcome!

  • @shivamtripathi8607
    @shivamtripathi86072 жыл бұрын

    I am getting #NAME? while I apply variance function?

  • @charllotebayransamonte7453
    @charllotebayransamonte74532 жыл бұрын

    Need help 🥺 what's the possible reason why I got a negative answer

  • @oddlove88
    @oddlove882 ай бұрын

    how will i know which item should be removed because of inconsistency?

  • @dr.yogeshbangar6236
    @dr.yogeshbangar6236 Жыл бұрын

    thanks

  • 3 ай бұрын

    I'm just asking (I'm not sure): Shouldn't you be using the function var.P instead of var. S since you are dealing with the variance of the total population?

  • @EugeneOLoughlin

    @EugeneOLoughlin

    3 ай бұрын

    Hi Dr Alonso, In my example here I am using a sample of 20 in a pilot study, so sample variance (var.s) is most suitable. Hope this helps, Dr E.

  • 3 ай бұрын

    Thanks, I understand now, you are working with a sample. Thanks again. Good video.

  • @akhiljohnne
    @akhiljohnneАй бұрын

  • @janchestergarcia3556
    @janchestergarcia3556 Жыл бұрын

    Hi! Is it necessary that the question number is in the x-axis and the respondents is in the y-axis?

  • @EugeneOLoughlin

    @EugeneOLoughlin

    Жыл бұрын

    Hi Jan, No - it is not necessary. But be careful how you calculate the variances - you will be using values in lines rather than columns. Hope this helps, Dr E.

  • @stevendalugdog4166
    @stevendalugdog41662 жыл бұрын

    Sir, why did you use Var. S instead of Var. P?

  • @EugeneOLoughlin

    @EugeneOLoughlin

    2 жыл бұрын

    Hi Steven, Normally we use samples (in the video the sample size in 20), and therefore do not know the population statistics such as population variance (var.p). Sample variance (var.s) is a good indicator of population variance, therefore it is usually OK to use it instead. Hope this helps, Dr E.

  • @ChristianDaveSibbaluca
    @ChristianDaveSibbaluca7 ай бұрын

    How did you get the total 6.67?

  • @EugeneOLoughlin

    @EugeneOLoughlin

    7 ай бұрын

    Hi Christian, This is shown at about 3:25 in the video. It is the variance of the total values. Dr E.

  • @jasonharris2676
    @jasonharris2676 Жыл бұрын

    Can not hear it well with all volume up

Келесі