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 KZitem. Dude really saved my life. Explained everything. Thank you so much
@JimGrange.
9 жыл бұрын
+Deandre Mathurin My pleasure!
@cutedgehouse
5 жыл бұрын
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.
@welwiczja124
10 жыл бұрын
The most understandable video about t-test I have found. Thank you very much for help!
@redsem9712
6 жыл бұрын
hello can i ask you question ?
@PHILLYMEDIC69
5 жыл бұрын
@@redsem9712 sure
@Draciel360
7 жыл бұрын
Six years later and this is helping me dearly with my high school advanced scientific research class, thank you VERY much.
@JimGrange.
7 жыл бұрын
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
@jasmingull
6 жыл бұрын
Jim Grange i donot get the right answer. After closing the brackets which key is to be pressed??
@xOliviaXDx
6 жыл бұрын
enter
@edelainemaegabriel6100
6 жыл бұрын
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...
@edelainemaegabriel6100
6 жыл бұрын
This really save our research as well as our future :)
@yoginiprabhu8048
5 жыл бұрын
yes. It helped (y)
@celiogomesdelima
11 жыл бұрын
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!
@archiefarrer6983
8 жыл бұрын
God damn I love when stuff like this is explained clearly and concisely, thank you sir!
@JimGrange.
8 жыл бұрын
+Archie Farrer Thanks Archie!
@chrisb3817
6 жыл бұрын
So concise and straight to the point. I found my favorite stats tutor.
@BurnhamSWAT
10 жыл бұрын
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)!
@JimGrange.
10 жыл бұрын
I'm very pleased you found it of use!
@dougriley97
Жыл бұрын
This is the best explanation I've found to describe a t test. Thank you!
@mekhrangizkhashimova2509
7 жыл бұрын
3AM in the morning couldn't find a better video than this.. Thank you for the video!
@JimGrange.
7 жыл бұрын
It's the best on the interwebs! Fact!
@FamXP
9 жыл бұрын
The numbers Mason, what do they mean?! - Call of Duty Black Ops
@berhanuengidawgetahun3649
2 жыл бұрын
To the point and concise explanations make your videos the most favourite
@Colombo5218
Жыл бұрын
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.
@JimGrange.
Жыл бұрын
You are too kind! Thanks for watching :)
@waddledom
9 жыл бұрын
Much appreciated. Elegant and simple, as well as easy to understand. Well done and thank you!
@LeeDavisonYo
8 жыл бұрын
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!
@narlynnicolerollon5999
3 жыл бұрын
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.😭❣️
@ardrienboutillet1975
2 жыл бұрын
You can't imagine how usefull it is ! I din't undertand ma university homework and you did it in 5 min.
@ellenpalmgren3834
3 жыл бұрын
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
@JimGrange.
3 жыл бұрын
Glad it helped!
@whiteleopard81
6 жыл бұрын
I appreciate this Jim! You just helped a Gifted and Talented Department in a school district in Northern Nevada!
@gidraffkioi3615
4 жыл бұрын
You are the legend I been looking out for. wasted 2 hrs on web research. Thanks
@clairekelly8635
11 жыл бұрын
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!
@parinitakumari9929
4 ай бұрын
Thank you ❤
@chridley111
9 жыл бұрын
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
@JimGrange.
9 жыл бұрын
That is fantastic to hear, thank you so much for your kind feedback!
@debasisnayak992
4 жыл бұрын
Thank you for sharing your knowledge in a simpler form. Very much helpful.
@otissumnerbrown
11 жыл бұрын
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!
@rl95719
6 жыл бұрын
This is the clearest I've heard it explained. Thank you
@eltilib1985
9 жыл бұрын
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!! :)
@maximus3974
4 жыл бұрын
Excellent. very easy to understand. now I can do my own t-test sheets and statistical mats on variables
@puentevanessa123
4 жыл бұрын
Very helpful information, we need more people like you in the world!
@beckyainscough1902
11 жыл бұрын
Had to watch the video several times but I understand this so much better now! thanks!
@tylerwertz5463
7 жыл бұрын
Thank you for the explanation! My genetics professor expected us to already know how to do this and did not explain it.
@NazHasanHuda
8 жыл бұрын
Thanks a lot, better than many other professors.
@siddharth1301
2 жыл бұрын
Fantastic, ur video was on point and simple. 👍🏻
@linhnguyenthuy7055
Жыл бұрын
Thank you very much! Your instruction is straight forward thus understandable, that helps me to solve my problem.
@bigrussianboywithgun
9 жыл бұрын
Thanks a lot for the explanation, made otherwise a confusing topic easier to understand.
@elliefarr
3 жыл бұрын
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!
@samanthaskyswanson
4 жыл бұрын
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. :)
@otissumnerbrown
11 жыл бұрын
This is VERY GOOD. I had "forgotten" some of this - and your review was very valuable to me! Thanks!
@DanielB288
3 жыл бұрын
Hi, great video! I’m wondering if you could help me. I’m trying to conduct a t-test to see if a lay betting strategy is worthy or not, I have the 1. Prices of each individual bet 2. Prices of winners. 3. Prices of losers 4. Average price won. 5.average price lost, however, I am struggling to know where to put each piece of data and if it’s the correct data to use. Thanks in advance 👍
@patriciapujals3777
9 жыл бұрын
Hello can you add link to video assessing if there is equal variance that you reference in the video?
@Mihogan
10 жыл бұрын
Really fantastic video - I will be sharing this with all of my coworkers, it helped immensely!
@JimGrange.
10 жыл бұрын
Wow, that's great! Thanks!
@kimberleya.dacquisto2460
8 жыл бұрын
Thank you! This quick and easy tutorial helped me put theory into practice for my research project!
@Libertycrab
7 жыл бұрын
Very simple and clear explanation! Thank you so much
@JimGrange.
7 жыл бұрын
My pleasure - glad you found it of use!
@somerandommusicians
7 жыл бұрын
This is the best i cant thank you enough!!! Greetings from a student form the Netherlands :)
@JimGrange.
7 жыл бұрын
Glad it helped! Cheers from the UK :)
@jahanbakhshgolzy2517
Жыл бұрын
Thank YOU for the VERY clear video!
@bytevicewithdavid6976
6 жыл бұрын
Thanks for the video. Short and to the point.
@AdisEleni
12 жыл бұрын
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
@perforsberg1433
8 жыл бұрын
I am doing my bachelor thesis and I am testing 2 trading strategies. One is an active and the other a buy and hold. The active strategy by and sell the stock when you have trading signals from technical analysis and the other just holds the stock. We have the returns and we think we should calculate the monthly returns and then compare the two strategies in a t-test. Is that right? You have both a sample t-test with known or unknown variances but then you also have a paired t-test.
@JimGrange.
8 жыл бұрын
+Per Forsberg It depends what unit of measurement your returns are in, but it sounds OK. Yes, a t-test sounds like it will be appropriate. Your values are coming from different groups, so it would be an independent t-test, not a paired t-test.
@ps15204
8 жыл бұрын
Thanks so much for this video, saved my life for a last minute presentation!
@kristinhall2702
9 жыл бұрын
You have saved lives today
@berhanuengidawgetahun3649
2 жыл бұрын
Hi Jim! I have a group of 58 students 22 of which are female and 33 male. I want to test if there is a statistically significant difference between the the internet use perceptions, practices of male and female students. by doing so, i want to check whether or not gender is a factor affecting students internet use. Of the three types of t-test, which type should i use and why. some points about the sample: they are 2nd year students at a university,all from the same faculty of humanities, it is null hypothesis.
@Klee666XD
11 жыл бұрын
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
@JimGrange.
10 жыл бұрын
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.
@Klee666XD
10 жыл бұрын
thanks everything is sorted now :3
@888Henke
7 жыл бұрын
Fantastic video! My SPSS license from school ran out so I had to use excel, this video was very helpful :)
@annasullivan5244
3 жыл бұрын
Thankyou this has been stressing me seemed so complicated 😂🙏
@bones8305
5 жыл бұрын
Excellent! My question, once I have a p-value (result of the t-test) what is the next calculation to determine whether improvement has occurred between two groups of data?
@stephaniefoster2899
5 жыл бұрын
Your p-value is essentially a percentage value. (1 - p-value)*100 = percent chance the difference between groups is statistically significant. A p-value ≤ 0.05 is the gold standard in industry as it indicates your group is 6-sigma from the mean (3-sigma to the left & 3-sigma to the right), which means you can be 95+% confident that your groups are statistically different. Your target p-value can be adjusted depending on how confident you want to be in reporting your groups to be different. Check out Khan Academy for more in depth videos on this topic.
@lindatheshorty
5 жыл бұрын
thank you for the instructional, informative, and concise video. it really helped me a lot.
@prasinipriza
9 жыл бұрын
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.
@andreascasablancas3574
4 жыл бұрын
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?
@mr.general2292
4 жыл бұрын
you taught me more than my teacher.
@trnmanood8099
Жыл бұрын
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?
@shardasingh896
6 жыл бұрын
Mind blowing video...thank you so much
@iangroh8441
7 жыл бұрын
Thank you, This was very useful and well explained.
@lovemikey21
11 жыл бұрын
Great help. Concise and clear.
@lynnkim6214
6 жыл бұрын
Thank you for the simple explanation. This has helped me greatly
@hengzhang8296
8 жыл бұрын
super video. very good practical help. Thanks.
@Aish09
5 жыл бұрын
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?
@riswinanissar4527
3 жыл бұрын
This was so helpful. Thanks a lot
@sharonshochat
10 жыл бұрын
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
@JimGrange.
10 жыл бұрын
Hi Sharon - this is a p-value. Excel won't give you the t-value directly.
@PCCSkill
3 жыл бұрын
Superb 👍
@johnphilipfermin3654
5 жыл бұрын
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😂
@fatihsirin4733
3 жыл бұрын
Teşekkür ederim bu güzel video için. Türkiye'den selamlar. ✌☮️❤🎸
@yingtaozhou4734
11 жыл бұрын
You said there is another video show how to calculate the variance. Could you post a link here? Thanks.
@Anatsuii
8 жыл бұрын
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...)
@JaLLaM86
3 жыл бұрын
Great video, thank you. 0.00468 does not mean that it is highly significant though. It just means that it is significant. The degree of significance is not possible to imply with the number.
@JimGrange.
3 жыл бұрын
Correct, I mis-spoke. But, a p-value of 0.004 suggests that data are LESS likely under the null hypothesis than with a p-value of 0.04. But broadly I agree with your statement.
@JimGrange.
10 жыл бұрын
@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
@housekey01
9 жыл бұрын
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?
@JimGrange.
9 жыл бұрын
***** 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.
@bigsam7320
Жыл бұрын
still relevant and very helpful, thank you
@charlieninkedisi
10 жыл бұрын
Thank you very, very much. It's probably a very easy thing for you, but it was actually very confusing for me until I watched your video. I have a question, though, if you'll excuse me: If I already have the means, SD-Variance and such descriptive results, can I still compare the means just by using them without the actual measurements for each, say, individual?
@dotsgrey
2 жыл бұрын
If the variances of each condition are too far apart, does that explain why my P value is like 4.2, even though the one mean is double the other....????
@rccanaesthesia3713
2 жыл бұрын
Best video seen🤩
@danton1106
8 жыл бұрын
Hi Jim, thank you for your video, it's very helpful. I have a question, how can we define tail that whether it is 2 tails or 1 tail? Thank you a lot.
@JimGrange.
8 жыл бұрын
+Ton Nu Thao Dan Do you mean how do you decide whether to run a 1- or a 2-tailed test? Or do you mean how do you declare this in Excel?
@danton1106
8 жыл бұрын
+Jim Grange i mean how to decide whether to run a 1- or 2-tailed test ^^ thank you for your reply
@danton1106
8 жыл бұрын
+Jim Grange thank you so much, that helps me a lot!
@josephbrzostowski5530
11 жыл бұрын
very clear, looking forward to sharing with my students
@rossl5908
4 ай бұрын
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
@JimGrange.
4 ай бұрын
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)
@rossl5908
4 ай бұрын
@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
@JimGrange.
4 ай бұрын
@@rossl5908 Sorry I'm not sure what you mean?
@BronzedMermaid
10 жыл бұрын
Thank you so much for this brilliant video! I have a question, though.. What if you have more than 2 conditions? Would you have to compare all the conditions individually? (I have different subjects, and 6 conditions in my experiment).
@JimGrange.
10 жыл бұрын
Hi - this would require an Analysis of Variance. You can't do multiple t-tests because you inflate the chance of a type-1 error; that is, finding a statistical difference when one doesn't exist in reality.
@wafahabib314
2 жыл бұрын
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?
@MatchaCocoaDog
6 ай бұрын
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?
@JimGrange.
6 ай бұрын
Correct - You cannot do a t-test just between two mean values. You need the individual data points
@bytetosolve
7 жыл бұрын
The formula "=T(value)" is use to check whether a value is...... Options:- a) Text b) Number c)True. Please answer me.
@TheAdLab
10 жыл бұрын
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.
@JimGrange.
10 жыл бұрын
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.
@adrianclifford3241
8 жыл бұрын
Very Helpful presentation! thank you!
@beckyhaszczyn
10 жыл бұрын
You saved my life! thank you so much - your video was so useful!!
@marushkanair1293
9 жыл бұрын
Hi Jim, Great Video. I have a doubt in conducting a T-test. So I am doing a thesis where I would check for significant differences in pre- and post M&As. So I have the median of 2 year pre- and post- M&A. Would the median difference be the statistical significance? If so, how would I go about with this computation? Look forward to your response. Thanks Marushka
@JimGrange.
9 жыл бұрын
Marushka Nair Hi - yes, it seems you need to do a t-test here. From what you've said, it seems you have two sets of means: one for pre-, and one for post-. So, you'd do a t-test. (I don't know what an M&A is, so if this is another factor, then a t-test might not be appropriate.)
@raudoniguzikai
11 жыл бұрын
really really great video!!!!!!!!! It helped me A LOT!!!!! THANK YOU!!!!!
@ashnour
27 күн бұрын
So based on the data used, which type is better 1, 2 or 3?
@JimGrange.
26 күн бұрын
There is no "best", here. It depends whether your data (for each condition) come from the same participants or from different participants.
@TSRR-xy6yu
9 жыл бұрын
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?
@JimGrange.
9 жыл бұрын
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.
@TSRR-xy6yu
9 жыл бұрын
Thanks for the help :) Much appreciated :)
@joemike75
8 жыл бұрын
great video! Very helpful for my work.
@JimGrange.
8 жыл бұрын
+joemike75 Glad it helped!
@catherinemartin-dunlop9405
9 жыл бұрын
Thanks for the straightforward video. However, believe it or not, I still had trouble. I am trying to do a t-test for 7 scales in which I have determined the average item means comparing students' "actual" perceptions of the learing environment and students' "preferred" learning environment (N=264). So my array1 was simply one number, and array2 was 1 number. Why didn't the calculation work?
@JimGrange.
9 жыл бұрын
Your description isn't very clear - you say you have 7 scales, so do you mean you have 7 "conditions", with ratings for each one?
Пікірлер: 360