How to perform paired t test in Excel

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

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

  • @marialuisasanchez1745
    @marialuisasanchez1745 2 года назад +1

    Thank you so much sir. More power to your channel

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

      socrat_ghadban@yahoo.com
      please send me an email, i will forward it to you

  • @brenda_pma
    @brenda_pma 11 месяцев назад +1

    Great video! I'm a foreign language teacher working on a research project. To demonstrate that the strategies I teach in class improve students' language skills, would you recommend using a one-tailed paired t-test to show that post-intervention scores are higher than pre-intervention? How is it done?Can you (please 🙌🏻 )briefly explain? Thanks in advance!

    • @SocratGhadban
      @SocratGhadban  11 месяцев назад +1

      Hello, thank you. In your case you have to use a one tailed test, because your hypothesis is having a direction (higher >) if the p one tail is less than 0.05 then there is a significant difference.

    • @brenda_pma
      @brenda_pma 11 месяцев назад +1

      Again, thank you so much ☺️! Your video and your explanation have helped me a lot!

    • @SocratGhadban
      @SocratGhadban  11 месяцев назад +1

      This is the purpose :) please share in the future the results of your research@@brenda_pma

  • @arslansiddique32
    @arslansiddique32 4 месяца назад +1

    Good video. Well explained

  • @joli3978
    @joli3978 2 года назад +1

    I have used this video in my class for a few semesters now, and this week a student pointed out to me that the hypotheses are not what we talked about in class, and was confused. Just an FYI, null should be less than or equal to, a typo you might want to correct.

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

      Hello Jo Li.. Thank you for your comment. In fact, I'm not sure if I got your point. If you're talking about the null hypothesis, you can write either ways mean equal to mean or difference equal to zero.. The alternative hypothesis could be one of two options : different (≠) where it's two tailed, if I'm just interested to know if there a difference, or one tailed like the case we're having in the video (here greater)..

  • @living6671
    @living6671 2 года назад +1

    should we also include the control group's results for before and after in the test?

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

      yes like this you can confirm the existing relationship

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

    What should i select in output range?

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

      The cell where you want to generate your results

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

      @@syncgalaxy7326 Exactly

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

    if you have multiple measurements for the same patient (Before) and multiple measurments for same patient (After) , does this work with paired t test?

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

      This is exactly what the paired t test is designed for!

  • @jaysons.1022
    @jaysons.1022 8 месяцев назад +1

    Hello, i am doing a experimental research and i also use pre test and post i notice that there might some outliers in our data how can i identify it

    • @SocratGhadban
      @SocratGhadban  8 месяцев назад

      Hello, Observations that lie more than 2 or 3 standard deviations from the mean are often considered outliers. another method you can use the Interquartile Range (IQR) Method: Calculate IQR = (Q3 - Q1) and define outliers as observations outside the range [Q1 - 1.5*IQR, Q3 + 1.5*IQR].

    • @jaysons.1022
      @jaysons.1022 8 месяцев назад

      Thank you for clarifying my doubts.

    • @SocratGhadban
      @SocratGhadban  8 месяцев назад

      My pleasure@@jaysons.1022

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

    Great video doctor 💪

  • @TserJords
    @TserJords 2 года назад +1

    How did you make the graph Sir?

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

      I didn't make it, I have as a picture!

  • @almariefuentes9506
    @almariefuentes9506 5 месяцев назад +1

    Hello. Can I ask a copy of the graph?

    • @SocratGhadban
      @SocratGhadban  5 месяцев назад

      Hello, please share your email.

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

    hi how do you make the graph ?

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

      Hello. This graph wasn't made on Excel, if you want to have it just leave your email here

  • @kenesufernandez1281
    @kenesufernandez1281 4 месяца назад +1

    ❤💖

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

    hi can i know how you made the graph for the paired t test?

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

      Hello. This graph wasn't made on Excel, if you want to have it just leave your email here

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

      @@SocratGhadban notshouyours@gmail.com , thank you :))

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

      Graph sent! my pleasure!

    • @marialuisasanchez157
      @marialuisasanchez157 2 года назад +1

      @@SocratGhadban hello sir.. can I have it too? Looking forward to your response

    • @SocratGhadban
      @SocratGhadban  2 года назад +1

      @@marialuisasanchez157 Hello, i need your email!

  • @marialuisasanchez157
    @marialuisasanchez157 2 года назад +1

    I dont know why everytime I put my email address here it was being remove

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

    Do a two-tail sir plss

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

      Check this video, it will help you understanding the difference between once tailed and two tailed test
      ruclips.net/video/BrFB91A7Xcg/видео.html

  • @marialuisasanchez1745
    @marialuisasanchez1745 2 года назад +1

    Sir I cant put my email address here I dont know why seems there is a problem. I tried it many times

  • @mantasha6402
    @mantasha6402 9 месяцев назад +1

    8.663 is not less 0.05 . P value is 8.663 and it is greater than 0.05