Statistics 101: Nonparametric Methods, Wilcoxon Signed Rank Test in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ก.พ. 2025

ความคิดเห็น • 20

  • @cbekaroglu
    @cbekaroglu 5 ปีที่แล้ว +8

    You are a great teacher, and this comes from a College Professor.

    • @dachikzuki
      @dachikzuki 4 ปีที่แล้ว +1

      Same exact compliment

  • @alihakim2736
    @alihakim2736 4 ปีที่แล้ว +3

    Brandon, you have taught me so much about my passion statistics. I hope you are always blessed with happiness and keep teaching

  • @crystalmartinez2750
    @crystalmartinez2750 3 ปีที่แล้ว +2

    Thank YOU, i was having such a hard time with my homework. God bless you keep up the great work!!

    • @BrandonFoltz
      @BrandonFoltz  3 ปีที่แล้ว +3

      You're welcome! I will keep working if you promise to do the same. Deal?

  • @stephaniepuentes6714
    @stephaniepuentes6714 4 ปีที่แล้ว

    I watched many videos to do this but this was the only one I really understood. Thank you!

  • @sesppsfd3815
    @sesppsfd3815 10 หลายเดือนก่อน

    do we have to take care of the tie ranks in calculating the standard deviation?

  • @JyotiSharma-yx5ux
    @JyotiSharma-yx5ux ปีที่แล้ว

    Great explanation. I have a query. If I want to find out if Mr Tyson is maintaining the same performance in two semesters. If I keep null hypothesis that there is no significant difference between the marks of two semesters and alternate hypothesis is there is a significant difference between the marks of two semesters. If p value is less than 0.05, can I reject null hypothesis? Then, I accept alternate hypothesis.

  • @mohadesehahmadi3031
    @mohadesehahmadi3031 3 ปีที่แล้ว

    Your videos are great!!! thank you

  • @itzladel8423
    @itzladel8423 7 หลายเดือนก่อน

    Hi! I have a question, what if the sum of postive is 3 and the negative is 0? What is the W?

  • @itzladel8423
    @itzladel8423 7 หลายเดือนก่อน

    Do I have to proceed solving mean and sd if my data isn't normally distributed?

  • @churro6224
    @churro6224 ปีที่แล้ว

    You are the best! Thank you, Brandon!

    • @BrandonFoltz
      @BrandonFoltz  ปีที่แล้ว

      Appreciate that my friend! You are awesome too! Keep on learning.

  • @dogcat145
    @dogcat145 4 ปีที่แล้ว

    Hi Brandon you appear to have use rounded values when deriving your Z value ie your T+ should be 211.5 and not 211 resulting in a slightly different Z value

  • @pastikurnia9505
    @pastikurnia9505 2 ปีที่แล้ว

    i dont understand how you get p value, what is the formula , thank you brandon

  • @erictu698
    @erictu698 3 ปีที่แล้ว

    Hi Thank you very much for this tutorial video. I have 1 question, what if T+ equals to 0 and sum of Negative is larger than 0? many thanks!

  • @patrickjoyce2472
    @patrickjoyce2472 4 ปีที่แล้ว

    Hello and thank you for this video! I used it to help with my thesis biostats actually but I have a question regarding my excel calculations. My mean is not coming out to be the mean it should be?

  • @MrStatguy76
    @MrStatguy76 5 ปีที่แล้ว +1

    What is the significance of dividing by 4 in the sampling distribution mean of t+?

    • @woodchuk1
      @woodchuk1 5 ปีที่แล้ว +1

      MrStatguy76 The sum of all the ranks (1+2+3+4+...+n) is n*(n+1)/2. If this sum is to be divided equally between a positive and negative category, each of the two totals should be close to half of that value, which is n*(n+1)/4.

  • @sauce2408
    @sauce2408 4 ปีที่แล้ว

    What does it mean if I only have positive signed ranks and the sum of negative ranks is 0.