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

Поделиться
HTML-код
  • Опубликовано: 8 ноя 2020
  • Learn how to calculate, use, and interpret Cronbach's Alpha as a test of reliability in simple steps.

Комментарии • 73

  • @aimeesjournal
    @aimeesjournal 2 года назад +10

    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
    @abdullahalghamdi8005 3 года назад +5

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

  • @TimeBeforeDawn
    @TimeBeforeDawn 7 месяцев назад +1

    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.

  • @flourescelleaustria9807
    @flourescelleaustria9807 2 года назад

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

  • @adafunk
    @adafunk Год назад

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

  • @theradicalbehaviourist
    @theradicalbehaviourist 8 месяцев назад

    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 🎉

  • @grampzoedien4571
    @grampzoedien4571 Год назад

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

  • @kennethpael4359
    @kennethpael4359 2 года назад +1

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

  • @leosimangca2904
    @leosimangca2904 2 года назад

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

  • @Armada0500
    @Armada0500 Год назад

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

  • @martriad
    @martriad 3 года назад

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

  • @brigittesnelson2354
    @brigittesnelson2354 Год назад

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

  • @Dibbles13
    @Dibbles13 Год назад

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

  • @jamieparslow-williams7567
    @jamieparslow-williams7567 Год назад

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

  • @1717blabla
    @1717blabla 2 года назад

    Thank you very much Professor Eugene!

  • @dananjayathathsara7884
    @dananjayathathsara7884 2 года назад

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

  • @OluwatoyinRoselineAjewole
    @OluwatoyinRoselineAjewole Год назад

    This totally helped. Thank you!

  • @supbar2007
    @supbar2007 3 года назад

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

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

  • @LearningWithRobert
    @LearningWithRobert Год назад

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

  • @nitinchaudhary8804
    @nitinchaudhary8804 11 месяцев назад

    What an explanation! Thanks a lot!

  • @rahamathsumith9686
    @rahamathsumith9686 Месяц назад

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

  • @OolaghenNULLETHENBY
    @OolaghenNULLETHENBY Год назад

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

  • @MorraLoop
    @MorraLoop 9 месяцев назад

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

  • @manweed5999
    @manweed5999 Год назад

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

  • @julietambali
    @julietambali Год назад

    Great lesson.

  • @MarcinaRiley
    @MarcinaRiley Год назад +1

    Thanks!

  • @gilbertjaymolina9915
    @gilbertjaymolina9915 5 месяцев назад

    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.

  • @priyasadar71
    @priyasadar71 4 месяца назад

    Best explanation!

  • @merlynnachor8410
    @merlynnachor8410 10 месяцев назад

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

  • @user-st7pi2zv8p
    @user-st7pi2zv8p Год назад

    very useful thank you

  • @apriljoydelima2395
    @apriljoydelima2395 3 месяца назад

    Thank you so much sir!

  • @sukanyaroy9508
    @sukanyaroy9508 5 месяцев назад

    VERY WELL EXPLAINED

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

  • @mathijnvandijk5505
    @mathijnvandijk5505 Год назад

    thank you
    mr legend

  • @lanceelopezz223
    @lanceelopezz223 Год назад

    Thank you, sir!

  • @user-u64251o
    @user-u64251o 3 года назад +1

    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?

  • @alsaeedahgreenland9248
    @alsaeedahgreenland9248 3 года назад

    thank you so mauch

  • @aparnanair4123
    @aparnanair4123 2 года назад +1

    Explained very well. Thanks!

  • @user-uz5tu7sq6q
    @user-uz5tu7sq6q 4 месяца назад

    Thanku so much sir ❤🙏

  • @ahmadfahmimohdhussain3187
    @ahmadfahmimohdhussain3187 8 месяцев назад

    thanks so much!

  • @jaynajwa0007
    @jaynajwa0007 Год назад

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

  • @adityajain8727
    @adityajain8727 2 года назад +5

    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?

  • @lindaomoefe4156
    @lindaomoefe4156 2 года назад

    Thank you

  • @anilsbilimale9537
    @anilsbilimale9537 2 года назад

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

  • @kalilwarren6982
    @kalilwarren6982 2 месяца назад +1

    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?

  • @hazelbolonos5914
    @hazelbolonos5914 7 месяцев назад

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

  • @missgamilaa
    @missgamilaa Год назад

    Thank you!

  • @shivamtripathi8607
    @shivamtripathi8607 2 года назад +1

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

  • @dr.yogeshbangar6236
    @dr.yogeshbangar6236 Год назад

    thanks

  • @charllotebayransamonte7453
    @charllotebayransamonte7453 2 года назад +2

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

  • @Dsxdx
    @Dsxdx 20 дней назад

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

  • @oddlove88
    @oddlove88 2 месяца назад

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

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

  • @akhiljohnne
    @akhiljohnne Месяц назад

  •  3 месяца назад +1

    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.

  • @stevendalugdog4166
    @stevendalugdog4166 2 года назад +1

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

    • @EugeneOLoughlin
      @EugeneOLoughlin  2 года назад +5

      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
    @ChristianDaveSibbaluca 7 месяцев назад

    How did you get the total 6.67?

    • @EugeneOLoughlin
      @EugeneOLoughlin  7 месяцев назад +1

      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