How to perform paired t-test in Excel

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

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

  • @sanderbosman4761
    @sanderbosman4761 19 วันที่ผ่านมา

    6 years later, i am thanking you big time. Thanks a lot buddy!

  • @rtramosful
    @rtramosful 4 ปีที่แล้ว +17

    Wonderful, easy to understand. Exactly what I needed for my research paper. Thank you for leaving out all the complexities.

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

    Thank you for this tutorial, so easy to understand, never knew excel is this powerful since ever.. No need for complicated SPSS

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

    Thought this was going to be a much more arduous process, thank you!!

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

    How did you determine that p-value of 0.047 is significant? is there a threshold value that says if its above or below "said number" than that means the diet was effective?

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

      by default everyone assumes that 0.05 is the treshhold value, or in another word more than 95% of the time as long as the value is above 0.05, it will be inside of the data. thus not significantly different, and since the value is 0.047 only it is significantly (different)

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

    Grear video! But does it make sense to use unpaired as opposed to paired? You're looking at difference within the same individuals, so I assume it would be paired (?)

  • @idalisdelagarza9058
    @idalisdelagarza9058 4 ปีที่แล้ว +2

    This is super easy and to the point thank you !

  • @sheisleeaddams
    @sheisleeaddams 4 หลายเดือนก่อน

    This helped me alot, thank you ❤

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

    Hello
    I am having airborne dust concentrations data for >1 micron size, >3 micron, 5 micron and >10 micron size.
    (> means greater than)
    These data was taken before and during dust producing work in field study.
    N=5
    How can i compare these before and during operations data ?
    It seems that there is relative percent variation in dust concentrations in atmosphere between before and during operation data. (Taking >1) micron as 100 %)
    Before operation:
    The relative percent variation of concentration with different particle size is as below. For example
    Concentration of >1 micron size particle is 100%.
    >3 micron: 80%
    >5 micron : 60%
    >10 micron: 40%.
    During operation:
    Concentration of >1 micron size particle is 100%.
    >3 micron: 90%
    >5 micron : 80%
    >10 micron: 70%.
    It seems that >10 micron particle share is increased due to that machine operation...?
    Which test is suitable for analysing these type similar data for discussion ?
    How to use statistics?
    Any comparison among these concentrations of different particle sizes ?
    thank u.

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

    is it applicable if like 30 individuals? cause im getting 5.34 number

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

    Hi, can you tell me if the numbers in the two columns are different, how to make the t-test?

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

    Hello why 0.47 < 0.05 significant does this mean the decrease of weight is significant?

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

    Thank you so much, you have been a great help

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

    Thanks a lot, please keep .....and go....

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

    nice one video thx for the information

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

    Very useful, thank you!

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

    Thank you for making it very simple!

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

    Thanks a lot mate!

  • @1982haids
    @1982haids 5 หลายเดือนก่อน

    excellent!

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

    How do you know whether it is significant or not?

  • @nimnisewwandi3742
    @nimnisewwandi3742 3 หลายเดือนก่อน

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

    Thanks 😊

  • @لولوالحلوة-خ3ر
    @لولوالحلوة-خ3ر 4 ปีที่แล้ว

    Plz Can u help me i have 3 sample one value each one , i need to do student test

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

    Very good

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

    thank you very much

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

    Good

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

    ? Title is how to do a paired T test; video shows unpaired T test? (Type 1 is for paired T test)

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

    bruh individual E gained weight during the diet xD

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

    Wabon papa

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

    Understood

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

    marry me
    pls

  • @dr.jenniferemelda5340
    @dr.jenniferemelda5340 ปีที่แล้ว

    Thank you so much