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

[@StevenBradburn]

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

[@zaharazul3689]

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

[@jx861]

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]

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

[@StevenBradburn]

Thanks for your kind feedback Asmaa

[@declanc5726]

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

[@kaitlinpryor5889]

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

[@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!!!! 🙏

[@viselevate]

Thanks for the video! Really did help!

[@Stephanie-ci3tr]

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

[@StevenBradburn]

Thanks for the feedback Stephanie!

[@v.c.jayaramaiah4815]

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

[@ananyaroy560]

Wonderfully explained

[@lucywambui9695]

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

[@rekharani5928]

I get a negative value of t-stats. Is it allowed? Can I use absolute ABS(value) formula while calculating t-stats

[@md.atikmas-ud]

How can I calculate hypothesized mean?

[@haithamalahmad1258]

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

[@jcl6929]

thank you so much for this tutorial

[@StevenBradburn]

You're very welcome!

[@anitab3386]

Great video!!!

[@THEANESTHESIST]

very nice and helpful video. thank you so much.

[@ChiTwnCutie]

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

[@StevenBradburn]

Glad it was helpful!

[@Devilz1224]

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

[@yue8288]

amazing, thank you!

[@mattodair9397]

Thanks a lot!

[@cubac3236]

great you saved my life

[@michaelslavin766]

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]

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

[@Divine-uk4ky]

Wonderful

[@farhanaulhoque2789]

Thank you sooooooooooo muchhhhhhhhh

[@priyasarda7415]

How did hypothesis mean was calculated

[@inhgfkbuvvd8951]

Thank u so much

[@kaccas5066]

i love you so much bro thank u

[@Xawans333]

best explanation

[@StevenBradburn]

Glad you think so!

[@madisengeorge4140]

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

[@VishalPatel-ej4xw]

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

[@Vatierville]

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

[@StevenBradburn]

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

[@MontahaAlriQa]

thanx

[@StevenBradburn]

You're welcome!

[@vericvoidal]

I love you so much Steven. you've done wonders

[@SwaySean7]

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

[@katakouzina]

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

[@wog3880]

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