Independent Sample T-test in Excel

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

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

  • @captglasspac
    @captglasspac 8 лет назад +44

    If you do not see "Data Analysis" under the data tab, go to Options --> Add Ins --> Manage Excel Add-In "Go" and activate the Data Analysis add in.

  • @ChristinaLop
    @ChristinaLop Месяц назад

    thank god for technology and having the means to find these tutorials especially when a human is not available.

  • @sengil5656
    @sengil5656 8 месяцев назад +1

    An actual "nice and short" tutorial, thank you!

  • @Rkisosondi
    @Rkisosondi Месяц назад

    Thank you!!!! You just saved me from withdrawing from my stats class for my phd program

    • @Dr.ElliottJardin
      @Dr.ElliottJardin  Месяц назад

      @@Rkisosondi Awesome! This is why i wanted to start a channel

  • @Holt196
    @Holt196 5 лет назад +2

    Man, this might sound ridiculous and make me sound like a dumb fuck, however; your video has been the key to finishing my bachelor thesis. THANK YOU! We need more 2 minute 51 second videos on this goddamn platform.

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

    This helped SO much you have no idea thank you so much man!!!

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

    Dude you saved my life, thank you so much man!

  • @torihinton6941
    @torihinton6941 7 лет назад +1

    O my gosh! Thank you so much! Now I don't have to get up at 4:30 to go to the computer lab!

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

    Simple and straighfoward. Great job!

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

    thank you so much for the video but why would not we take mean difference in data analysis table. Please answer

  • @ThatUnHealthyDude
    @ThatUnHealthyDude 5 лет назад +2

    You're a lifesaver! Thank you so much for this.

  • @tombarrows5332
    @tombarrows5332 7 лет назад +2

    Great video - but how do we interperate the p value and t tail value? Thanks

    • @Dr.ElliottJardin
      @Dr.ElliottJardin  7 лет назад +8

      Hi Tom,
      Thanks! In this test we set the Alpha to .05 What that means is that we are using .05 as the p-value cutoff point for whether we accept the null hypothesis that the samples are equal or reject the null hypothesis, and select the alternative hypothesis that the means are different.
      Because our p-value is less than .05, we reject the null hypothesis and choose the alternative hypothesis that the group means are significantly different. The critical t-tail value is the t score needed to reach the threshold of .05. As you can see, the t score is larger than the cutoff, meaning that the groups are significantly different.

  • @lynnmaelia1926
    @lynnmaelia1926 4 года назад +6

    You should have unchecked the labels box so that you use all of your data. Your analysis used the first data point as a label and did not include it in the calculation. Otherwise, nice clear explanation. Thank you.

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

    Thank you

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

    Thank you so much holy cow

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

    Nice one :)

  • @sarabaarda6977
    @sarabaarda6977 6 лет назад

    How come it shows you only have 13 observations and not 14 for each variable?

    • @fani437
      @fani437 6 лет назад +4

      Probably because they didn't uncheck the "labels" box, thus the program assumed the first value highlighted was a label and didn't take it into account.

  • @yansid462
    @yansid462 5 лет назад

    You fuckign beast