How to Manually Compute Mann Whitney U Test Using Excel?

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • A step by step guide in computing the Mann Whitney U Test using Excel. This is basically a manual computing aided using excel.
    Don't forget to subscribe hit the ring button at / learningwithdoclevz
    Like Our Facebook Page at / learning-with-doc-levz...
    Join the Group of Teachers and School Leaders who Love Learning at:
    / teachersloungeph
    Support the cause:
    GCASH: 09061580974
    Paypal: paypal.me/leviti820

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

  • @ma.elizabethcabriana2765
    @ma.elizabethcabriana2765 3 года назад +3

    Doc *Levz maraming salamat po.Higit po akong natututo sa mga ibinabahagi ninyong kaalaman. Halos araw-araw po kayong naglaan ng oras upang maghandog ng mga panibagong aralin sa amin. Ako'y nagagalak po sa mga pedagohiya ng inyong pagtuturo dahil lagi ninyong pinagtuonang pansin ang aming pagkatuto sa pinakasimpleng paraan upang maabot namin ang layon ng inyong pagbabahagi ng dunong, galing at talento. Lagi po namin inaabangan ang inyong mga komprehensibong video na inihahain dito para sa ikabubuti namin.

  • @maynorennanud1198
    @maynorennanud1198 3 года назад +1

    The video is very comprehensive in showing Mann-Whitney manual computation using excel. Explained in a very simple and easy to follow steps. With this, interpretation will be easy. Thanks doc.

  • @jo-andelacerna4329
    @jo-andelacerna4329 3 года назад +1

    Thank you Doc Levz for always sharing your expertise to help others. This educational video about Mann-Whitney U-test is very comprehensive and it teaches me on how to compute Mann-Whitney U-test using Microsoft Excel. God bless you doc.

  • @domricpanunciar1128
    @domricpanunciar1128 3 года назад +1

    You literally made statistics specifically computing the Mann Whitney U Test using Excel fun and simple in this video sir. Thank you and God Bless

  • @gasparbatolbatol2593
    @gasparbatolbatol2593 3 года назад +1

    This video really helps me in understanding the Mann Whitney U Test using excel. Thank you doc.

  • @noemejunelugo8783
    @noemejunelugo8783 3 года назад +1

    Thank you so much Doc Levz for this video tutorial. The instructions are very clear and easy to follow. I really do appreciate the lessons you shared are so keen to make the viewers learn it better. I hope you keep making more video tutorials like this. God bless po!

  • @karenrulete7729
    @karenrulete7729 3 года назад +1

    Thank you so much Doc Levz for sharing this video tutorial. Discussion is very clear and informative in explaining the concept and showing the step by step on how to compute manually the Mann Whitney U Test. This will be a great help to us. You are indeed a great professor and one of my favorite professors. Thank you Doc Levz!

  • @sevillanaaureo4014
    @sevillanaaureo4014 3 года назад +1

    Thank you Doc. Levi for sharing to us the step by step discussions on how to compute manually the Mann Whitney U Test aided by Microsoft excel. It's a clear and comprehensive discussions...so inspiring to answer our Problem Set no. 4 in our Quantitative class. Hoping for more shared tutorial videos for our succeeding topics. God richly bless you Doc. Levi.

  • @ritcheleealugar1281
    @ritcheleealugar1281 3 года назад +1

    Thank You so much, doc Lev. This is a very clear, simple and comprehensive guide on computing Mann Whitney U Test in excel. This is much simpler than the one I tried. This enlightens some of my confusions with the "formula entry" process in excel. Thank You so much and God Bless, doc Lev.

  • @melalivio7510
    @melalivio7510 3 года назад +1

    Thank you so much, Doc Levz for this very educational video. This is really a big help especially for students who are poor in statistics like me.

  • @maryjanerodrigo7205
    @maryjanerodrigo7205 3 года назад +1

    Thank you so much Doc Levz for preparing this very comprehensive video. This is MAGIS (doing more and being more). Indeed, it is of great help for us to understand and make use of Mann Whitney U Test. You teach us to learn more and explore more. Statistical problems may seem complicated but you are guiding us in doing the step by step in solving and interpreting it. These are new meaningful learning for me. I am looking forward to more comprehensive videos from your channel. God bless you, Doc.

  • @stephaniedisimulacion4566
    @stephaniedisimulacion4566 3 года назад +1

    Thank you Doc Levz. This video is worth another space in my quanti-related videos collection. And like your other videos, it guided me step by step on the computation of Mann Whitney U via excel. You never fail to make things easy especially on numbers. Continue making and uploading vids because this will surely help a lot of students like me. God bless!

  • @junilyntingson4124
    @junilyntingson4124 3 года назад +1

    Thank you so much, Doc Levz. This is a great help for us in understanding and computing the Mann Whitney U test. Indeed, this short video guides us step by step in the computation of the Mann Whitney U test using Excel. Looking forward to more comprehensive and simplified video discussions from you sir.. Thank you and God bless!

  • @liliavergara9728
    @liliavergara9728 3 года назад +1

    Thank you so much for this video Doc Levi. It's very clear and comprehensive. This video really guides us step by step in computing the Mann Whitney U Test using excel. For sure, this would help me as I am going to answer our Problem Set 4 in our class. God bless and always stay safe Doc!

  • @azaleajabagat9565
    @azaleajabagat9565 3 года назад +1

    Thank you so much Doc Lev for enlightening us on how to manually compute Mann Whitney U test in MS Excel.... This had been very helpful to understand the tool that can be used when the data is non-parametric. That data becomes non-parametric when it violates the assumptions of validity. I also understood that the Ustatistic to be used for computing the Zstat is the lowest Ustat. Thank you again Doc.

  • @rubelynkionisala1237
    @rubelynkionisala1237 3 года назад +1

    Thank you very much Doc Levi for this video. This will help us a lot. You are indeed a great professor. You explained well the concept of Mann Whitney U test. Very informative and knowledgeable Doc. You are teaching us not just by learning but at the same time, learning by doing and exploring which I really like and love. There are times that I would say "AHA" and it means that your class and lessons are very interesting. Looking forward to more "AHA" moments with you Doc. God bless you and more power.

  • @TeacherAizDumuk
    @TeacherAizDumuk 3 года назад +1

    Yet another educational vid. 👍

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

    You need to mention that the middle term 2 changes midway through the video. From u2 + 2 to u2 +1. The end of the video is very unclear and cuts off after finding U_critical.

  • @yuyusdanyuzy4187
    @yuyusdanyuzy4187 3 года назад +1

    I don' get the last part. Did you mean anything past 20 in U2 means there is a significant difference between the two groups? Is it correct?

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

    Good day sir, what happened to the last part? The video was unclear. I am hoping for your response sir, thank you very much.

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

    what if you have higher n1 and n2 because of the large sample size.

  • @user-kp3qc8xb1o
    @user-kp3qc8xb1o Год назад +1

    Video was pretty unclear