Statistics 101: Nonparametric Methods, Mann-Whitney-Wilcoxon Rank Sum in Excel

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

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

  • @syedbaryalay5849
    @syedbaryalay5849 3 года назад +6

    I must say finding this course was a blessing from the sky

  • @namratapandey4014
    @namratapandey4014 4 года назад +1

    I'm subject coordinator and I really loved it. Thank you for making this video.

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

    Amazing, I work at a hospital and i have to run some numbers from time to time to assess our quality improvement projects. this video is a life saver!!

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

    This video and other videos in the series are godsend. I am a mid-career Aerospace Engineer, and have not needed heavy statistics but I have been wanting to study statistics for a long time. I am going to go through every video in this course. It's eye opening.

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

    Literally saved my masters 😂 THANK YOU!

  • @vitorvidal733
    @vitorvidal733 4 года назад +1

    Thanks for the video. It helped me a lot. Great explanation!

  • @Shortsandvid
    @Shortsandvid 4 года назад +2

    Great video, the only thing I noticed that you didnt explain the difference use of Wilcoxon and Man-whitney : the first is used for paired testing (Two dependent samples) the second is used for unpaired testing (Two independent samples)

  • @kristinastajdohar1080
    @kristinastajdohar1080 4 года назад +3

    PhD Student once again, THANK YOU!

  • @DragonDragon-qr6mq
    @DragonDragon-qr6mq 2 года назад

    So helpful. Thx for the knowledge

  • @alexandrakelley3667
    @alexandrakelley3667 4 года назад +2

    Great video. A bit confused about the calculation for mean of the sampling distribution. The paper I read to set it up said it's n1*n2*0.5. Why does yours have the additional n1 outside the parentheses?

  • @Olivia-pq6xw
    @Olivia-pq6xw 4 года назад +4

    What if you want to do a two-tailed test on the data? If the hypothesis was "is there difference between fall and spring?" and not "is fall better/worse than spring?"
    How should you calculate Z?

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

      Maybe just double that p-value since it's equally likely on either side of the normal distribution?

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

    Truly helpful

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

    I don't understand why 514 is being used and not 761.
    Can someone please help.Thank you.

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

    Amazing

  • @joshbridges4719
    @joshbridges4719 4 года назад

    Hey Brandon,
    PhD Student here looking to add some statistics to his research.
    First, love the videos. Stats is not in my wheelhouse so your videos have been extremely helpful clearly explaining everything and helping me work out what I need.
    I was wondering if you could either make a video or possibly provide a link that clearly explains how to work out and interpret the two varieties of the Mann Whitney test (e.g. shift location vs P(X

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

    Great video, well explained. I just wonder why you calculate the z-value and not a t-statistic? The way I see it is that the samples are paired - as you measure improvement of the course comparing one semester to an other - so I would say the number of observations then is 25 and one would - strictly speaking - have to use the student t-statistic instead of the z-value? Or am I missing something?

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

      because it's not about the difference in scores of the same exact students

  • @prof.keebler
    @prof.keebler 2 года назад

    Also what about the continuity correction? You are approximating a discrete distribution using the continious normal distribution, so you should in theory have to correct for this.

  • @h.i.sjoevall4213
    @h.i.sjoevall4213 2 года назад

    Just one question: Isn't the two samples dependent, since the professor is (for the most part) the same from one semester to the next? I thought that Rank-sum-tests were only for comparing two independent samples?

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

    Brandon,
    Let's say you had 2 samples of n=20 and the total sums were the same (514, 761).
    However, now with the new numbers you will get a z = +2.81; thus not rejecting the Null, even though the Spring semester score is much higher.
    How is that this test depends only on the sample size, is that logical?
    Thanks
    Liran

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

      Here's a weirder example:
      If you take 2 samples of n=20, and you assign the score of 5 to each line in Spring semester and 10 to Fall semester, you will get that the Null can not be rejected, meaning that there's no change.
      Am I wrong here or what?

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

    Hi sir, is the denominator of standard Dev always 12?

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

    If we are considering that the distributions of the data for Mann-Whitney-Wilcoxon is not normally distributed so why are we considering a normal distribution when calculating the p-value???

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

      This is due to the sample size. If the sample size is large enough you can approximate, see 7:23

  • @Suvampaul619
    @Suvampaul619 4 года назад

    How u get that alpha value?

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

      Someone just decided it because it's a very common practice to have an alpha of 0.05 or 0.01 for most tests.

  • @prof.keebler
    @prof.keebler 2 года назад

    Why do you calculate the mean value (expected mean value )in this way? The original paper uses (n_1 * n_2) / 2 which is also equal to the sum of ranks / 2 namely (U_1 + U_2) / 2

  • @doddpower
    @doddpower 4 года назад +1

    Pretty good video, but the number of times you say "remember" throughout your videos makes it hard to listen to at times. The more things students have to "remember" from previous items, the harder things are to learn. Try to use less "remember" less and provide more clips/notes/animations on the slide to assist with the process. Thanks!