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

In this tutorial, I will show you how to perform a one-sample T-test by using Microsoft Excel. There is no function to perform a one-sample T-test in Excel. However, you can still perform this by using a stepwise approach.
THE ONLINE GUIDE
toptipbio.com/one-sample-t-te...
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Laptop amzn.to/38bB7JG
Microphone amzn.to/2OFn1sd
Screen recorder & editor techsmith.z6rjha.net/BQQkL
RUclips SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Top Tip Bio is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com. We will earn a commission from Amazon if a purchase is made through the affiliate links.

[@StevenBradburn]

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

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

[@zaharazul3689]

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

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

[@Swaevis]

Thanks for the video! Really did help!

[@THEANESTHESIST]

very nice and helpful video. thank you so much.

[@asmaaabdulhamid2292]

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

[@StevenBradburn]

Thanks for your kind feedback Asmaa

[@yue8288]

amazing, thank you!

[@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 😊

[@ananyaroy560]

Wonderfully explained

[@anitab3386]

Great video!!!

[@cubac3236]

great you saved my life

[@mattodair9397]

Thanks a lot!

[@Stephanie-ci3tr]

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

[@StevenBradburn]

Thanks for the feedback Stephanie!

[@kaccas5066]

i love you so much bro thank u

[@ChiTwnCutie]

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

[@StevenBradburn]

Glad it was helpful!

[@inhgfkbuvvd8951]

Thank u so much

[@farhanaulhoque2789]

Thank you sooooooooooo muchhhhhhhhh

[@Divine-uk4ky]

Wonderful

[@jcl6929]

thank you so much for this tutorial

[@StevenBradburn]

You're very welcome!

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

[@lucywambui9695]

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

[@sawanshrivastava4147]

best explanation

[@StevenBradburn]

Glad you think so!

[@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.

[@MontahaAlriQa]

thanx

[@StevenBradburn]

You're welcome!

[@Devilz1224]

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

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

[@md.atikmas-ud]

How can I calculate hypothesized mean?

[@priyasarda7415]

How did hypothesis mean was calculated

[@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.?

[@haithamalahmad1258]

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

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

[@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?

[@wog3880]

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