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 RUclips. Dude really saved my life. Explained everything. Thank you so much
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!
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.
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)!
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
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.
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!
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!
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!
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!
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
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.
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
@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
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😂
What if I had two columns of consumer age and another row of the purchase amount, and I wanted to see if there was a correlation between the two, which t-test would I use
You would use the =CORREL(range1, range2) function, where range1 is your ages and range2 is your purchase amount. This returns a pearson's r value (between -1 and 1)
@JimGrange. Thanks for that Jim, also how would I go about getting a sample of age ranges from my mass of data so I can do another T-test ? I can't seem to find the answer online
Hi, let's say I have data for pre and post tests.... all i need to do now is to just analyse the two groups' post tests right? As in the data that i need to insert into that two columns are the post tests for both groups right?
Sunitha Rachel Hi - no, you would likely need to take into account the pre-test scores, too. This can be done using a factorial ANOVA, with one factor being "time" (i.e., pre & post test), and another factor for your groups (group 1 & group 2). More correctly, you would likely need to conduct an Analysis of Covariance (ANCOVA), which allows you to control for the difference pre-test.
Hi. I want to perform a T test. One of the values in the sample is very large. Should I omit it when I calculate mean, standard deviation and variance?
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.
With regards to the final values....does excel provide the value based on the critical value table for a t-test or does the 0.1672 result then need to be referred to the critical value table at 0.05 (df=7) in order to reject the null hypothesis??? Thanks
+Grant Ormerod gspo13@hotmail.com Hi Grant - the result returned by Excel is *not* the t-value, it is the exact p-value. Normally you would check the t-value you obtain with the critical values in a textbook to see whether your p-value is < 0.05. However, as Excel is providing the exact value you need not do this. In this case, your value is p = 0.1672, so your p is not less than 0.05.
Hi Jim, Great video - thanks for posting. At 0:55 you mention that the related / paired t-test is the test to use if the variables come from the same participant. What method should be used if the data is from separate participants? Say each variable is from a different person and nobody contribute to both Condition A and B. Many Thanks.
Great video, one question: what if my dataset is imbalanced and I have more than 5 times the amount in one vs. The other? I guess since it uses averaged valued it wouldn't matter but, can you do it?
Jim. Until seeing your video I had assumed that using the =ttest command gave you a t-stat which you then had to compare to a p value table. Can you explain why this is not the case and what the value you refer to as the p value actually is please?
***** Hi. I do not know why that is not the case. You would have to ask the designers of Excel why :) The p-value is the probability of observing a test statistic (not shown by Excel) as extreme (or more so) as the one you have observed, if the null hypothesis is true. So, a low p-value means that there is a low probability of observing a test statistic as extreme as you have if there is no difference in reality. People believe by reverse inference that a low p-value implies there is a greater likelihood the difference in your data is a real, "significant" difference.
Working on my data analysis now and I already calculated the mean for 2 groups I want to compare but excel tells me I can't just select the calculated mean. So we can only select a list of values from which it will calculate the mean?
No, a high t-value tends to be significant. However, remember the output in this video is the p-value (not the t-value). If the p-value is below 0.05, it is significant (in most scientific fields).
I'm not sure you'll answer my question in time (or at all) but I'd like to do a t-test to compare the mean of a group to the value that correspond to what they would have obtain if they've answered randomly so it would be a t-test comparing a mean based on real data and a pre determined mean, can you do that with excel? (i'm not sure if this was clear enough to understand, I hope so...)
There isn't really a "better", as it all depends on your data (i.e., if the values for each condition come from the same people or different people), that is whether your study is repeated measures or independent measures
Thanks so much! A question, what if I want to test whether values in an array (they are in fact simulated values) are statistically significant from a particular actual value?
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
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 RUclips. Dude really saved my life. Explained everything. Thank you so much
+Deandre Mathurin My pleasure!
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!
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
Six years later and this is helping me dearly with my high school advanced scientific research class, thank you VERY much.
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!
So concise and straight to the point. I found my favorite stats tutor.
God damn I love when stuff like this is explained clearly and concisely, thank you sir!
+Archie Farrer Thanks Archie!
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.😭❣️
This is the best explanation I've found to describe a t test. Thank you!
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!
You can't imagine how usefull it is ! I din't undertand ma university homework and you did it in 5 min.
To the point and concise explanations make your videos the most favourite
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 :)
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!
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!
You are the legend I been looking out for. wasted 2 hrs on web research. Thanks
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!! :)
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!
Much appreciated. Elegant and simple, as well as easy to understand. Well done and thank you!
I appreciate this Jim! You just helped a Gifted and Talented Department in a school district in Northern Nevada!
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. :)
Very helpful information, we need more people like you in the world!
The numbers Mason, what do they mean?! - Call of Duty Black Ops
Thank you for sharing your knowledge in a simpler form. Very much helpful.
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!
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 ❤
This is the best i cant thank you enough!!!
Greetings from a student form the Netherlands :)
Glad it helped! Cheers from the UK :)
Excellent. very easy to understand. now I can do my own t-test sheets and statistical mats on variables
Fantastic, ur video was on point and simple. 👍🏻
Legend! I really hate excel and this video made me almost like it a tiny bit.. Thanks dude ! :)
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.
Had to watch the video several times but I understand this so much better now! thanks!
This is the clearest I've heard it explained. Thank you
Thanks a lot, better than many other professors.
Really fantastic video - I will be sharing this with all of my coworkers, it helped immensely!
Wow, that's great! Thanks!
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!
Hello can you add link to video assessing if there is equal variance that you reference in the video?
Fantastic video! My SPSS license from school ran out so I had to use excel, this video was very helpful :)
This is VERY GOOD. I had "forgotten" some of this - and your review was very valuable to me! 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
Thank you! This quick and easy tutorial helped me put theory into practice for my research project!
Thanks a lot for the explanation, made otherwise a confusing topic easier to understand.
Teşekkür ederim bu güzel video için. Türkiye'den selamlar.
✌☮️❤🎸
Thankyou this has been stressing me seemed so complicated 😂🙏
Superb 👍
Very simple and clear explanation! Thank you so much
My pleasure - glad you found it of use!
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
Which test can be used if we have PH ranges from 2-6 used for citric acid production and we need to findout if its statistically significant or not?
thank you for the instructional, informative, and concise video. it really helped me a lot.
@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
Thank YOU for the VERY clear video!
Thank you so muchh, you saved MY LIFE!
Best video seen🤩
Thanks so much for this video, saved my life for a last minute presentation!
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😂
Thank you, This was very useful and well explained.
Thanks for the video. Short and to the point.
Thank you for the simple explanation. This has helped me greatly
You have saved lives today
You saved my life! thank you so much - your video was so useful!!
Mind blowing video...thank you so much
Hi sir, like to ask about the problem I have. I have this 5 person having training records from day 1 and day 8 I would like to see what should I use?
You saved my life! Thanks so much
Thank you! This video helped me for my final! Also, I love your voice and your accent. =]
Thank you for this!
Also can you read me a bedtime story lmao voice is beautiful!
super video. very good practical help. Thanks.
This was so helpful. Thanks a lot
What if I had two columns of consumer age and another row of the purchase amount, and I wanted to see if there was a correlation between the two, which t-test would I use
You would use the =CORREL(range1, range2) function, where range1 is your ages and range2 is your purchase amount. This returns a pearson's r value (between -1 and 1)
@JimGrange. Thanks for that Jim, also how would I go about getting a sample of age ranges from my mass of data so I can do another T-test ? I can't seem to find the answer online
@@rossl5908 Sorry I'm not sure what you mean?
Hi, let's say I have data for pre and post tests.... all i need to do now is to just analyse the two groups' post tests right? As in the data that i need to insert into that two columns are the post tests for both groups right?
Sunitha Rachel Hi - no, you would likely need to take into account the pre-test scores, too. This can be done using a factorial ANOVA, with one factor being "time" (i.e., pre & post test), and another factor for your groups (group 1 & group 2). More correctly, you would likely need to conduct an Analysis of Covariance (ANCOVA), which allows you to control for the difference pre-test.
Thanks for the help :) Much appreciated :)
really really great video!!!!!!!!! It helped me A LOT!!!!! THANK YOU!!!!!
Hi. I want to perform a T test. One of the values in the sample is very large. Should I omit it when I calculate mean, standard deviation and variance?
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.
Thank you so much this was really useful and easily understood!
what are these values in columns A & B.
Great help. Concise and clear.
@ArchYeomans There MUST be a difference somewhere. But, regardless, rest assured Excel isn't making a mistake in its calculations.
With regards to the final values....does excel provide the value based on the critical value table for a t-test or does the 0.1672 result then need to be referred to the critical value table at 0.05 (df=7) in order to reject the null hypothesis??? Thanks
+Grant Ormerod gspo13@hotmail.com Hi Grant - the result returned by Excel is *not* the t-value, it is the exact p-value. Normally you would check the t-value you obtain with the critical values in a textbook to see whether your p-value is < 0.05. However, as Excel is providing the exact value you need not do this. In this case, your value is p = 0.1672, so your p is not less than 0.05.
Thanks, Great video, I used it for my degree students to help with some mock data. :-)
Hi Jim, Great video - thanks for posting.
At 0:55 you mention that the related / paired t-test is the test to use if the variables come from the same participant. What method should be used if the data is from separate participants? Say each variable is from a different person and nobody contribute to both Condition A and B. Many Thanks.
Sorry for late reply - it would be an independent t-test. You need to enter "2" as the "type" in the equation. See at about 3:03 in the video.
Great video, one question: what if my dataset is imbalanced and I have more than 5 times the amount in one vs. The other? I guess since it uses averaged valued it wouldn't matter but, can you do it?
still relevant and very helpful, thank you
Very Helpful presentation! thank you!
Jim. Until seeing your video I had assumed that using the =ttest command gave you a t-stat which you then had to compare to a p value table. Can you explain why this is not the case and what the value you refer to as the p value actually is please?
***** Hi. I do not know why that is not the case. You would have to ask the designers of Excel why :) The p-value is the probability of observing a test statistic (not shown by Excel) as extreme (or more so) as the one you have observed, if the null hypothesis is true. So, a low p-value means that there is a low probability of observing a test statistic as extreme as you have if there is no difference in reality. People believe by reverse inference that a low p-value implies there is a greater likelihood the difference in your data is a real, "significant" difference.
what do u press if its the same person doing the same test more then once ?
great video! Very helpful for my work.
+joemike75 Glad it helped!
clear and brief! this is very helpful! thanks a lot!!
Thank you so much! This was incredibly helpful!!
Glad it helped!
can you tell which condition is faster or slower based on the p-value?
No - just whether the difference is statistically significant. You'd need to inspect the means to determine which condition was faster.
Working on my data analysis now and I already calculated the mean for 2 groups I want to compare but excel tells me I can't just select the calculated mean. So we can only select a list of values from which it will calculate the mean?
Correct - You cannot do a t-test just between two mean values. You need the individual data points
very clear, looking forward to sharing with my students
does low t-value means that the difference between the two is significant? just abit confused because i've read it different somewhere else.
No, a high t-value tends to be significant. However, remember the output in this video is the p-value (not the t-value). If the p-value is below 0.05, it is significant (in most scientific fields).
Excellent explanation, thank you very much!!!
I'm not sure you'll answer my question in time (or at all) but I'd like to do a t-test to compare the mean of a group to the value that correspond to what they would have obtain if they've answered randomly
so it would be a t-test comparing a mean based on real data and a pre determined mean, can you do that with excel?
(i'm not sure if this was clear enough to understand, I hope so...)
So based on the data used, which type is better 1, 2 or 3?
There isn't really a "better", as it all depends on your data (i.e., if the values for each condition come from the same people or different people), that is whether your study is repeated measures or independent measures
Thanks so much!
A question, what if I want to test whether values in an array (they are in fact simulated values) are statistically significant from a particular actual value?
You said there is another video show how to calculate the variance. Could you post a link here? Thanks.
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.