I was going to turn in my science project without a t-test because I couldn't figure out how o do it. Friends were trying to help me and I still couldn't understand. I thought about UA-cam. Dude really saved my life. Explained everything. Thank you so much
I hope you all find this video useful! If you have any questions, please do drop me an email. And if the video has REALLY helped and you want to buy me a beer, please see www.paypal.com/donate/?hosted_button_id=L692FVF8PNUKU
Really clear instruction. Thanks for taking the time to do this tutorial for us. There are many, many statisticians who seem to enjoy making the subject inaccessible. Whoever put the help together for MS Excel is a sadist.
Hello Mr. Grange, My name is Celio, I'm from Brazil. And I spent hours searching for an easy and practical solution in Brazilian sites. And I just saw your video and solve my problem with statistical data analysis. Thank you and the video is great!
We have to do several experiments and labs at school that require to find the p value in excel, and I have used this video several times to help me find it each time. It's so clear and it so easy to understand! I searched for hours trying to find an easy way to understand how to find it and couldn't find one until I found this video. Thank you so much for it! It literally has saved me (and my grade)!
This is extremely simple and helpful. Where I trip up is when all the books say "we reject the null hypothesis" or similar instead of saying "This means these are different significantly" or similar. I reach the end and I'm thinking "What was the hypothesis again?" This is what youtube stats is good for. Thanks!
Okay I know it's been 9 years but thank you so much for this video! I was freeking out couse my teacher couldent explain it in a way that made sense to me but this was so easy! it kinda helped my final exams a lot
This has been a great help to me. It is now very easy to get a "p" value from the "t" test. I have developed a "one-tail" test proposal for myopia prevention from your analysis. Thanks!
It was such a great pleasure to watch your video. Wonderful clarity. You would not want to give up your day job but you would be a star with the BBC World Service with your superb communication skills. Many many thanks. Best wishes.
The E-106 means that you have to move your decimal place to the right 106 places. So your P value would be VERY small eg 0.0000000000000000000... ect. Your data is significantly different :) Hope this isnt too late!
Thank you so much! This was super easy to follow and made it easy to understand even though it's been a while since I took stats. Thank you again! Life saver. :)
I so appreciated this video. I have no stats background and do not need the "full math" explanation for what I need to do, and this was perfectly clear and concise!
You probably know this by now but for others who may not: when you have '#####' in a cell in excel it is often because the cell is not big enough to show all the digits. A solution would either be to expand the cell or to make it stop at fewer decimals
Jim, I am currently doing my dissertation on how carbohydrate intake effects blood glucose. Can I first of all compliment you on the efficient and easy to understand video on t-test's. This is often an area of confusion for my peers (me included). I have just shown this to the majority of the class, all of which will be using to do their t testing along side SPSS. Thank you
Very informative in 5 minutes.. i studied this in my doctorate degree for a year in my statistics subject,-yet headache came on my way 😂 So in 5 minutes, i learned this the easiest way😂
@DarthHako Yes, you can. The exact formula to use changes with whether you intend to test a between-subjects design or a within-subjects design. For a whithin-subjects design, your t-value = D_xy / (sdD_xy / (sqrt(n)). This looks complex, but D_xy refers to the difference between condition x and condition y, sdD_xy refers to the standard deviation of these differences, and sqrt(n) is just the square root of the number of observations you This website explains it better than I can: have.www.unt.edu/rss/class/Jon/ISSS_SC/Module008/isss_m8_introttests/node3.html
I tried your method with different tails/types as well as calculated mine in paper, the excel methods ended up with a different value each time T^T the video is good thanks
Remember Excel is just giving you back the exact p-value. When you do the calculations on paper you are likely calculating the exact t-value (which is quite different). That might explain the differences you are getting.
Hello Jim! An urgent question: is the result of this test via excel is the t-value or the p-value? And how do I see these two separately, if possible? Many thanks!!! Sharon
Thank you for uploading all these videos. Great work and very helpful. I have watched your video on t-test. At some point you are saying that we need to decide whether we have the same variances between the 2 groups and I believe that you are saying that this is explained in another video. Could you please refer me to that video? Can we find out by using excel? Would this have anything to do with Levene's test? Thanks again, Athina.
I was going to turn in my science project without a t-test because I couldn't figure out how o do it. Friends were trying to help me and I still couldn't understand. I thought about UA-cam. Dude really saved my life. Explained everything. Thank you so much
+Deandre Mathurin My pleasure!
I hope you all find this video useful! If you have any questions, please do drop me an email. And if the video has REALLY helped and you want to buy me a beer, please see www.paypal.com/donate/?hosted_button_id=L692FVF8PNUKU
Jim Grange i donot get the right answer. After closing the brackets which key is to be pressed??
enter
all my life ive been looking for an app that has TTEst without knowing it is just right there in EXCEl, thank you very much for sharing this one...
This really save our research as well as our future :)
yes. It helped (y)
Really clear instruction. Thanks for taking the time to do this tutorial for us. There are many, many statisticians who seem to enjoy making the subject inaccessible. Whoever put the help together for MS Excel is a sadist.
The most understandable video about t-test I have found. Thank you very much for help!
hello can i ask you question ?
@@redsem9712 sure
God damn I love when stuff like this is explained clearly and concisely, thank you sir!
+Archie Farrer Thanks Archie!
Six years later and this is helping me dearly with my high school advanced scientific research class, thank you VERY much.
So concise and straight to the point. I found my favorite stats tutor.
Hello Mr. Grange,
My name is Celio, I'm from Brazil.
And I spent hours searching for an easy and practical solution in Brazilian sites. And I just saw your video and solve my problem with statistical data analysis.
Thank you and the video is great!
We have to do several experiments and labs at school that require to find the p value in excel, and I have used this video several times to help me find it each time. It's so clear and it so easy to understand! I searched for hours trying to find an easy way to understand how to find it and couldn't find one until I found this video. Thank you so much for it! It literally has saved me (and my grade)!
I'm very pleased you found it of use!
The numbers Mason, what do they mean?! - Call of Duty Black Ops
This is the best explanation I've found to describe a t test. Thank you!
This is extremely simple and helpful. Where I trip up is when all the books say "we reject the null hypothesis" or similar instead of saying "This means these are different significantly" or similar. I reach the end and I'm thinking "What was the hypothesis again?" This is what youtube stats is good for. Thanks!
Okay I know it's been 9 years but thank you so much for this video! I was freeking out couse my teacher couldent explain it in a way that made sense to me but this was so easy! it kinda helped my final exams a lot
Glad it helped!
Much appreciated. Elegant and simple, as well as easy to understand. Well done and thank you!
To the point and concise explanations make your videos the most favourite
Thank you so much Sir! I have an interview in 40 mins. I always gets confused while explaining t-test. best explanation. Thank you!!
Good luck in the interview - let us know how it goes!
3AM in the morning couldn't find a better video than this.. Thank you for the video!
It's the best on the interwebs! Fact!
I appreciate this Jim! You just helped a Gifted and Talented Department in a school district in Northern Nevada!
You can't imagine how usefull it is ! I din't undertand ma university homework and you did it in 5 min.
You are the legend I been looking out for. wasted 2 hrs on web research. Thanks
This helps me a lot. Thank you so much😭 I've been struggling to do the t-test but after I saw your vids... I understand it now.😭❣️
Thank you for sharing your knowledge in a simpler form. Very much helpful.
This has been a great help to me. It is now very easy to get a "p" value from the "t" test. I have developed a "one-tail" test proposal for myopia prevention from your analysis. Thanks!
It was such a great pleasure to watch your video. Wonderful clarity. You would not want to give up your day job but you would be a star with the BBC World Service with your superb communication skills. Many many thanks. Best wishes.
You are too kind! Thanks for watching :)
You are the man!! not only i know how to calculate t-test but you made me understand why it is!! you have saved me a lot of reading. Great job!! :)
Excellent. very easy to understand. now I can do my own t-test sheets and statistical mats on variables
The E-106 means that you have to move your decimal place to the right 106 places. So your P value would be VERY small eg 0.0000000000000000000... ect. Your data is significantly different :) Hope this isnt too late!
Thank you ❤
Thank you so much! This was super easy to follow and made it easy to understand even though it's been a while since I took stats. Thank you again! Life saver. :)
This is the clearest I've heard it explained. Thank you
Thanks a lot, better than many other professors.
Very helpful information, we need more people like you in the world!
Thank you for the explanation! My genetics professor expected us to already know how to do this and did not explain it.
Thank you very much! Your instruction is straight forward thus understandable, that helps me to solve my problem.
Thanks a lot for the explanation, made otherwise a confusing topic easier to understand.
Thank you! This quick and easy tutorial helped me put theory into practice for my research project!
Had to watch the video several times but I understand this so much better now! thanks!
Hello can you add link to video assessing if there is equal variance that you reference in the video?
I so appreciated this video. I have no stats background and do not need the "full math" explanation for what I need to do, and this was perfectly clear and concise!
This is VERY GOOD. I had "forgotten" some of this - and your review was very valuable to me! Thanks!
Superb 👍
Thanks for the video. Short and to the point.
thank you for the instructional, informative, and concise video. it really helped me a lot.
Thank YOU for the VERY clear video!
This is the best i cant thank you enough!!!
Greetings from a student form the Netherlands :)
Glad it helped! Cheers from the UK :)
Thanks so much for this video, saved my life for a last minute presentation!
Fantastic video! My SPSS license from school ran out so I had to use excel, this video was very helpful :)
You probably know this by now but for others who may not: when you have '#####' in a cell in excel it is often because the cell is not big enough to show all the digits. A solution would either be to expand the cell or to make it stop at fewer decimals
Very simple and clear explanation! Thank you so much
My pleasure - glad you found it of use!
Thank you, This was very useful and well explained.
Fantastic, ur video was on point and simple. 👍🏻
Thankyou this has been stressing me seemed so complicated 😂🙏
Thank you for the simple explanation. This has helped me greatly
Jim,
I am currently doing my dissertation on how carbohydrate intake effects blood glucose. Can I first of all compliment you on the efficient and easy to understand video on t-test's. This is often an area of confusion for my peers (me included). I have just shown this to the majority of the class, all of which will be using to do their t testing along side SPSS.
Thank you
That is fantastic to hear, thank you so much for your kind feedback!
Really fantastic video - I will be sharing this with all of my coworkers, it helped immensely!
Wow, that's great! Thanks!
still relevant and very helpful, thank you
Great help. Concise and clear.
You have saved lives today
Teşekkür ederim bu güzel video için. Türkiye'den selamlar.
✌☮️❤🎸
Best video seen🤩
Mind blowing video...thank you so much
you taught me more than my teacher.
Excellent explanation, thank you very much!!!
This was so helpful. Thanks a lot
Very informative in 5 minutes.. i studied this in my doctorate degree for a year in my statistics subject,-yet headache came on my way 😂
So in 5 minutes, i learned this the easiest way😂
@DarthHako Yes, you can. The exact formula to use changes with whether you intend to test a between-subjects design or a within-subjects design. For a whithin-subjects design, your t-value = D_xy / (sdD_xy / (sqrt(n)). This looks complex, but D_xy refers to the difference between condition x and condition y, sdD_xy refers to the standard deviation of these differences, and sqrt(n) is just the square root of the number of observations you This website explains it better than I can:
have.www.unt.edu/rss/class/Jon/ISSS_SC/Module008/isss_m8_introttests/node3.html
You saved my life! thank you so much - your video was so useful!!
very clear, looking forward to sharing with my students
Thank you so much this was really useful and easily understood!
super video. very good practical help. Thanks.
Really helpful thank you.
Very Helpful presentation! thank you!
You saved my life! Thanks so much
clear and brief! this is very helpful! thanks a lot!!
really really great video!!!!!!!!! It helped me A LOT!!!!! THANK YOU!!!!!
great vid. thank you
thanks a million. so clear and precise
Thx. Very helpful.
Great help, cheers for the video!
fantastic - great help!
Glad you found it of use. Anything else you would like help with in Excel? I am making more videos!
@@JimGrange. perhaps the tests for the assumptions (Levenes etc). There are other videos on them, of course, but you explain things very clearly.
simple, clear, perfect....THANKS!
I tried your method with different tails/types as well as calculated mine in paper, the excel methods ended up with a different value each time T^T the video is good thanks
Remember Excel is just giving you back the exact p-value. When you do the calculations on paper you are likely calculating the exact t-value (which is quite different). That might explain the differences you are getting.
thanks everything is sorted now :3
So good, thank you.
thx you saved my exams :)
Thank you so much! This was incredibly helpful!!
Glad it helped!
Thank you so much, that was really really helpful
great video! Very helpful for my work.
+joemike75 Glad it helped!
excellent video!thank you.
you saved meeeeeeeeee best tutorial!! Thank you thank you thank you!
Hello Jim!
An urgent question: is the result of this test via excel is the t-value or the p-value? And how do I see these two separately, if possible? Many thanks!!!
Sharon
Hi Sharon - this is a p-value. Excel won't give you the t-value directly.
thank you thank you thank you so much!!!!
Helped a lot, thanks so much!
Pleasure!
thank you so much for your help!!
thanks so much. u are a lifesaver! will treat u to dinner if ever u come to taiwan!
Thank you for uploading all these videos. Great work and very helpful. I have watched your video on t-test. At some point you are saying that we need to decide whether we have the same variances between the 2 groups and I believe that you are saying that this is explained in another video. Could you please refer me to that video? Can we find out by using excel? Would this have anything to do with Levene's test? Thanks again, Athina.
SUPER USEFUL!!!
a fucking man i lovw you, i spent ONE HOUR LOOKING FOR SOMETHING THIS SIMPLE GOD THANK YOU I PASSED PSYCH BC OF U
thank you so much! very helpful!
soooo helpful. thank you so much
Thanx a lot it's so clear.