How To Perform A One-Sample T-Test In Excel

Поділитися
Вставка
  • Опубліковано 11 вер 2024

КОМЕНТАРІ • 45

  • @StevenBradburn
    @StevenBradburn  4 роки тому +1

    THE ONLINE GUIDE
    toptipbio.com/one-sample-t-test-excel

  • @jx861
    @jx861 10 місяців тому +1

    This was brilliant stuff. I am not a maths genius at all, but watching your videos and making notes of these examples has helped me to become more confident in working with data, and it's even quite enjoyable 😊

  • @asmaaabdulhamid2292
    @asmaaabdulhamid2292 3 роки тому +6

    WOW, this video was incredibly clear, simple, and professional. thanks a lot

  • @zaharazul3689
    @zaharazul3689 3 роки тому +2

    Your saving lives man! One-sample T-Test stat at a time!

  • @kaitlinpryor5889
    @kaitlinpryor5889 2 роки тому +3

    this video has been a life saver helping me with my stats homework! Much appreciated :)

  • @declanc5726
    @declanc5726 3 роки тому +4

    Thanks for this video, I was looking around for hours for a solution to my problem. The video was very clear and easy to understand, I really appreciate it

  • @madtankman1
    @madtankman1 Рік тому

    Thank you very much! you saved me from so much headache on how to deduct T-stat and P-value from one sample list!!!! 🙏

  • @v.c.jayaramaiah4815
    @v.c.jayaramaiah4815 2 роки тому

    This video is very clear to understand the analysis of data for Non statistical students , However No data samples are not clear it will f immense useful delivering details of data points

  • @MindsetConsistent
    @MindsetConsistent Рік тому +1

    Thanks for the video! Really did help!

  • @Stephanie-ci3tr
    @Stephanie-ci3tr 3 роки тому +3

    Thank you so much!! This video was so perfect and well explained!!

  • @farhanaulhoque2789
    @farhanaulhoque2789 2 місяці тому

    Thank you sooooooooooo muchhhhhhhhh

  • @ananyaroy560
    @ananyaroy560 Рік тому

    Wonderfully explained

  • @michaelslavin766
    @michaelslavin766 3 роки тому +8

    Great tutorial. Two things though: I noticed you used the standard deviation of the population, instead of the sample . Also your last comment states that the p value is less than the alpha being 0.05 instead of stating that it is 0.025 in the two tailed situation. Otherwise very clear

    • @Rainbowrobb
      @Rainbowrobb 2 роки тому +2

      I immediately noticed this and wondered how many students became frustrated as they calculated population instead of samples

  • @jcl6929
    @jcl6929 2 роки тому

    thank you so much for this tutorial

  • @ChiTwnCutie
    @ChiTwnCutie 3 роки тому

    Fantastic!! Great explanation and easy to understand...thank you for the video!!

  • @mattodair9397
    @mattodair9397 Рік тому

    Thanks a lot!

  • @THEANESTHESIST
    @THEANESTHESIST 4 роки тому

    very nice and helpful video. thank you so much.

  • @lucywambui9695
    @lucywambui9695 3 роки тому +1

    Tdist is compatible with version 2007 or earlier.
    What of more recent version of ms

  • @cubac3236
    @cubac3236 3 роки тому

    great you saved my life

  • @yue8288
    @yue8288 3 роки тому

    amazing, thank you!

  • @anitab3386
    @anitab3386 Рік тому

    Great video!!!

  • @inhgfkbuvvd8951
    @inhgfkbuvvd8951 Рік тому

    Thank u so much

  • @kaccas5066
    @kaccas5066 3 роки тому

    i love you so much bro thank u

  • @madisengeorge4140
    @madisengeorge4140 3 роки тому +3

    Where does the 66.5 for the national average come from?? im just supposed to know that?

    • @VishalPatel-ej4xw
      @VishalPatel-ej4xw 2 роки тому

      same doubt. how can i find my value for hypothesis mean.?

  • @iKillborn2kilNOE
    @iKillborn2kilNOE Рік тому

    I wonder if there is a way to use the t-test in order to translate all of the speicified data from specific stocks price movements. In order to find the probability of the population of price movement based on a 5% margin of error.

  • @haithamalahmad1258
    @haithamalahmad1258 8 місяців тому

    the t-statistic comes up negative and i cannot get a p value! what to do? take the absolute value of t-statistic?

  • @md.atikmas-ud
    @md.atikmas-ud 5 місяців тому

    How can I calculate hypothesized mean?

  • @Devilz1224
    @Devilz1224 Рік тому

    How do you get around if the t-test were to be negative? What would the excel computations be?

  • @sawanshrivastava4147
    @sawanshrivastava4147 2 роки тому

    best explanation

  • @Divine-uk4ky
    @Divine-uk4ky Рік тому

    Wonderful

  • @priyasarda7415
    @priyasarda7415 Рік тому

    How did hypothesis mean was calculated

  • @MontahaAlriQa
    @MontahaAlriQa 3 роки тому

    thanx

  • @SwaySean7
    @SwaySean7 6 місяців тому

    it says something else now...not the tails it says true or false

  • @wog3880
    @wog3880 5 місяців тому

    Where is the first part of solving this problem, I guess the this is not for beginners. Thank bye.

  • @Vatierville
    @Vatierville 3 роки тому

    Help! My answer is coming up in standard form, how do I change it? :(

    • @StevenBradburn
      @StevenBradburn  3 роки тому

      Hi Lewis,
      What do you mean by standard form? So you cannot see a p value?

  • @katakouzina
    @katakouzina 2 роки тому

    why cant they make a command for this?! thank you btw