How to perform paired t-test in Excel

Поделиться
HTML-код
  • Опубликовано: 29 июн 2018
  • This video will walk you step by step how to perform a paired t-test in Excel and also briefly explain the reason.
    Please subscribe to be updated for future topics. Thanks for watching
  • НаукаНаука

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

  • @rtramosful
    @rtramosful 4 года назад +17

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

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

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

  • @idalisdelagarza9058
    @idalisdelagarza9058 3 года назад +2

    This is super easy and to the point thank you !

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

    Thank you so much, you have been a great help

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

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

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

    Very useful, thank you!

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

    Thanks a lot mate!

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

    nice one video thx for the information

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

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

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

    Thank you for making it very simple!

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

    thank you very much

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

    Thank you so much

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

    Thanks 😊

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

    Very good

  • @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 (?)

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

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

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

    Good

  • @winvictorywin5612
    @winvictorywin5612 3 года назад +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.

  • @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 года назад +2

      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)

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

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

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

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

  • @user-yv9sk5bk2i
    @user-yv9sk5bk2i 3 года назад

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

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

    Understood

  • @qulaeygaming5202
    @qulaeygaming5202 3 года назад +2

    bruh individual E gained weight during the diet xD

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

    Wabon papa

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

    How do you know whether it is significant or not?

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

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

    marry me
    pls