t-test in Microsoft Excel

  Рет қаралды 2,220,446

Jim Grange

Jim Grange

13 жыл бұрын

How to perform a simple t-test in Microsoft Excel

Пікірлер: 346
@deandremathurin1280
@deandremathurin1280 8 жыл бұрын
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 KZfaq. Dude really saved my life. Explained everything. Thank you so much
@JimGrange.
@JimGrange. 8 жыл бұрын
+Deandre Mathurin My pleasure!
@cutedgehouse
@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.
@Draciel360
@Draciel360 7 жыл бұрын
Six years later and this is helping me dearly with my high school advanced scientific research class, thank you VERY much.
@chrisb3817
@chrisb3817 6 жыл бұрын
So concise and straight to the point. I found my favorite stats tutor.
@welwiczja124
@welwiczja124 9 жыл бұрын
The most understandable video about t-test I have found. Thank you very much for help!
@redsem9712
@redsem9712 6 жыл бұрын
hello can i ask you question ?
@PHILLYMEDIC69
@PHILLYMEDIC69 4 жыл бұрын
@@redsem9712 sure
@archiefarrer6983
@archiefarrer6983 8 жыл бұрын
God damn I love when stuff like this is explained clearly and concisely, thank you sir!
@JimGrange.
@JimGrange. 8 жыл бұрын
+Archie Farrer Thanks Archie!
@whiteleopard81
@whiteleopard81 6 жыл бұрын
I appreciate this Jim! You just helped a Gifted and Talented Department in a school district in Northern Nevada!
@celiogomesdelima
@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!
@waddledom
@waddledom 9 жыл бұрын
Much appreciated. Elegant and simple, as well as easy to understand. Well done and thank you!
@dougriley97
@dougriley97 10 ай бұрын
This is the best explanation I've found to describe a t test. Thank you!
@BurnhamSWAT
@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.
@JimGrange. 10 жыл бұрын
I'm very pleased you found it of use!
@JimGrange.
@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
@jasmingull 6 жыл бұрын
Jim Grange i donot get the right answer. After closing the brackets which key is to be pressed??
@xOliviaXDx
@xOliviaXDx 6 жыл бұрын
enter
@edelainemaegabriel6100
@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
@edelainemaegabriel6100 6 жыл бұрын
This really save our research as well as our future :)
@yoginiprabhu8048
@yoginiprabhu8048 5 жыл бұрын
yes. It helped (y)
@otissumnerbrown
@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!
@kimberleya.dacquisto2460
@kimberleya.dacquisto2460 8 жыл бұрын
Thank you! This quick and easy tutorial helped me put theory into practice for my research project!
@rl95719
@rl95719 6 жыл бұрын
This is the clearest I've heard it explained. Thank you
@eltilib1985
@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!! :)
@otissumnerbrown
@otissumnerbrown 11 жыл бұрын
This is VERY GOOD. I had "forgotten" some of this - and your review was very valuable to me! Thanks!
@tylerwertz5463
@tylerwertz5463 6 жыл бұрын
Thank you for the explanation! My genetics professor expected us to already know how to do this and did not explain it.
@LeeDavisonYo
@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!
@lynnkim6214
@lynnkim6214 6 жыл бұрын
Thank you for the simple explanation. This has helped me greatly
@samanthaskyswanson
@samanthaskyswanson 3 жыл бұрын
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. :)
@FamXP
@FamXP 9 жыл бұрын
The numbers Mason, what do they mean?! - Call of Duty Black Ops
@beckyainscough1902
@beckyainscough1902 11 жыл бұрын
Had to watch the video several times but I understand this so much better now! thanks!
@ps15204
@ps15204 7 жыл бұрын
Thanks so much for this video, saved my life for a last minute presentation!
@bytevicewithdavid6976
@bytevicewithdavid6976 6 жыл бұрын
Thanks for the video. Short and to the point.
@puentevanessa123
@puentevanessa123 4 жыл бұрын
Very helpful information, we need more people like you in the world!
@berhanuengidawgetahun3649
@berhanuengidawgetahun3649 2 жыл бұрын
To the point and concise explanations make your videos the most favourite
@xzyeee
@xzyeee 9 жыл бұрын
simple, clear, perfect....THANKS!
@bigrussianboywithgun
@bigrussianboywithgun 9 жыл бұрын
Thanks a lot for the explanation, made otherwise a confusing topic easier to understand.
@debasisnayak992
@debasisnayak992 4 жыл бұрын
Thank you for sharing your knowledge in a simpler form. Very much helpful.
@mekhrangizkhashimova2509
@mekhrangizkhashimova2509 7 жыл бұрын
3AM in the morning couldn't find a better video than this.. Thank you for the video!
@JimGrange.
@JimGrange. 7 жыл бұрын
It's the best on the interwebs! Fact!
@beckyhaszczyn
@beckyhaszczyn 9 жыл бұрын
You saved my life! thank you so much - your video was so useful!!
@maggief6653
@maggief6653 7 жыл бұрын
Excellent explanation, thank you very much!!!
@iangroh8441
@iangroh8441 6 жыл бұрын
Thank you, This was very useful and well explained.
@narlynnicolerollon5999
@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.😭❣️
@maximus3974
@maximus3974 4 жыл бұрын
Excellent. very easy to understand. now I can do my own t-test sheets and statistical mats on variables
@_makoyski
@_makoyski 8 жыл бұрын
clear and brief! this is very helpful! thanks a lot!!
@888Henke
@888Henke 7 жыл бұрын
Fantastic video! My SPSS license from school ran out so I had to use excel, this video was very helpful :)
@lindatheshorty
@lindatheshorty 4 жыл бұрын
thank you for the instructional, informative, and concise video. it really helped me a lot.
@NazHasanHuda
@NazHasanHuda 8 жыл бұрын
Thanks a lot, better than many other professors.
@ellenpalmgren3834
@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.
@JimGrange. 3 жыл бұрын
Glad it helped!
@patriciapujals3777
@patriciapujals3777 9 жыл бұрын
Hello can you add link to video assessing if there is equal variance that you reference in the video?
@ardrienboutillet1975
@ardrienboutillet1975 2 жыл бұрын
You can't imagine how usefull it is ! I din't undertand ma university homework and you did it in 5 min.
@jahanbakhshgolzy2517
@jahanbakhshgolzy2517 Жыл бұрын
Thank YOU for the VERY clear video!
@gidraffkioi3615
@gidraffkioi3615 4 жыл бұрын
You are the legend I been looking out for. wasted 2 hrs on web research. Thanks
@amayaimanthi7567
@amayaimanthi7567 5 жыл бұрын
Thank you so much this was really useful and easily understood!
@SumitSanyal-cf7li
@SumitSanyal-cf7li 2 ай бұрын
Thank you so much Sir! I have an interview in 40 mins. I always gets confused while explaining t-test. best explanation. Thank you!!
@JimGrange.
@JimGrange. 2 ай бұрын
Good luck in the interview - let us know how it goes!
@johnscott638
@johnscott638 7 жыл бұрын
Great help, cheers for the video!
@adrianclifford3241
@adrianclifford3241 7 жыл бұрын
Very Helpful presentation! thank you!
@Andreilla007
@Andreilla007 9 жыл бұрын
you saved meeeeeeeeee best tutorial!! Thank you thank you thank you!
@lovemikey21
@lovemikey21 11 жыл бұрын
Great help. Concise and clear.
@azizahosein6715
@azizahosein6715 10 жыл бұрын
Thank you! This video helped me for my final! Also, I love your voice and your accent. =]
@PaigeLevenson
@PaigeLevenson 10 жыл бұрын
Thank you so much! This was incredibly helpful!!
@JimGrange.
@JimGrange. 10 жыл бұрын
Glad it helped!
@linhnguyenthuy7055
@linhnguyenthuy7055 Жыл бұрын
Thank you very much! Your instruction is straight forward thus understandable, that helps me to solve my problem.
@JimGrange.
@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
@nperesle
@nperesle 7 жыл бұрын
Thank you so much, that was really really helpful
@Colombo5218
@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.
@JimGrange. Жыл бұрын
You are too kind! Thanks for watching :)
@claraoswald7400
@claraoswald7400 4 жыл бұрын
You saved my life! Thanks so much
@Libertycrab
@Libertycrab 7 жыл бұрын
Very simple and clear explanation! Thank you so much
@JimGrange.
@JimGrange. 7 жыл бұрын
My pleasure - glad you found it of use!
@shardasingh896
@shardasingh896 6 жыл бұрын
Mind blowing video...thank you so much
@kristinhall2702
@kristinhall2702 9 жыл бұрын
You have saved lives today
@riswinanissar4527
@riswinanissar4527 3 жыл бұрын
This was so helpful. Thanks a lot
@raudoniguzikai
@raudoniguzikai 11 жыл бұрын
really really great video!!!!!!!!! It helped me A LOT!!!!! THANK YOU!!!!!
@siddharth1301
@siddharth1301 2 жыл бұрын
Fantastic, ur video was on point and simple. 👍🏻
@annasullivan5244
@annasullivan5244 3 жыл бұрын
Thankyou this has been stressing me seemed so complicated 😂🙏
@zaraa7
@zaraa7 6 жыл бұрын
thanks a million. so clear and precise
@somerandommusicians
@somerandommusicians 7 жыл бұрын
This is the best i cant thank you enough!!! Greetings from a student form the Netherlands :)
@JimGrange.
@JimGrange. 7 жыл бұрын
Glad it helped! Cheers from the UK :)
@nurulhudhamohdyussoff5681
@nurulhudhamohdyussoff5681 7 жыл бұрын
thank you so much for your help!!
@elliefarr
@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!
@josephbrzostowski5530
@josephbrzostowski5530 11 жыл бұрын
very clear, looking forward to sharing with my students
@mi2fariq
@mi2fariq 12 жыл бұрын
thank you so much! very helpful!
@Mihogan
@Mihogan 9 жыл бұрын
Really fantastic video - I will be sharing this with all of my coworkers, it helped immensely!
@JimGrange.
@JimGrange. 9 жыл бұрын
Wow, that's great! Thanks!
@nonfictiondictionary
@nonfictiondictionary 9 жыл бұрын
Helped a lot, thanks so much!
@JimGrange.
@JimGrange. 9 жыл бұрын
Pleasure!
@BigPlagiat
@BigPlagiat 11 жыл бұрын
thx you saved my exams :)
@tiffanylanajohnson9093
@tiffanylanajohnson9093 6 жыл бұрын
soooo helpful. thank you so much
@clairekelly8635
@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
@parinitakumari9929 Ай бұрын
Thank you ❤
@totticelik
@totticelik 11 жыл бұрын
excellent video!thank you.
@bigsam7320
@bigsam7320 Жыл бұрын
still relevant and very helpful, thank you
@hengzhang8296
@hengzhang8296 8 жыл бұрын
super video. very good practical help. Thanks.
@mr.general2292
@mr.general2292 4 жыл бұрын
you taught me more than my teacher.
@FreedomWriter3
@FreedomWriter3 8 жыл бұрын
Thank you for this.
@joemike75
@joemike75 8 жыл бұрын
great video! Very helpful for my work.
@JimGrange.
@JimGrange. 8 жыл бұрын
+joemike75 Glad it helped!
@prasinipriza
@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.
@infamousxmexican
@infamousxmexican 11 жыл бұрын
perfect you saved me thanks!
@sunsernlaohasathit4050
@sunsernlaohasathit4050 6 жыл бұрын
Thanx a lot it's so clear.
@ronpersonalplaylist
@ronpersonalplaylist 11 жыл бұрын
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?
@joefra5574
@joefra5574 Жыл бұрын
great vid. thank you
@sorlos
@sorlos 10 ай бұрын
SUPER USEFUL!!!
@kemia3890
@kemia3890 3 жыл бұрын
Really helpful thank you.
@andreascasablancas3574
@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?
@pennyrobards
@pennyrobards Жыл бұрын
So good, thank you.
@chridley111
@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.
@JimGrange. 9 жыл бұрын
That is fantastic to hear, thank you so much for your kind feedback!
@jeremysimbulan6700
@jeremysimbulan6700 5 жыл бұрын
Thank you mister!
@charlieninkedisi
@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?
@MrOffkiltervisions
@MrOffkiltervisions 11 жыл бұрын
Oh my goodness thank you so very much!
@scp-se-jp2867
@scp-se-jp2867 Жыл бұрын
Thx. Very helpful.
@johnphilipfermin3654
@johnphilipfermin3654 4 жыл бұрын
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😂
@TheMojojojotang
@TheMojojojotang 11 жыл бұрын
thanks so much. u are a lifesaver! will treat u to dinner if ever u come to taiwan!
@PCCSkill
@PCCSkill 3 жыл бұрын
Superb 👍
How to perform t-test in Excel
9:21
Innovative Learner
Рет қаралды 138 М.
How to Do a T-Test for Beginners
19:51
ATOMIC Teacher
Рет қаралды 710 М.
Задержи дыхание дольше всех!
00:42
Аришнев
Рет қаралды 3,8 МЛН
НЫСАНА КОНЦЕРТ 2024
2:26:34
Нысана театры
Рет қаралды 1,5 МЛН
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 1,9 МЛН
t-Test - Full Course - Everything you need to know
16:14
DATAtab
Рет қаралды 253 М.
How to Calculate a Correlation (and P-Value) in Microsoft Excel
5:16
Quantitative Specialists
Рет қаралды 1,1 МЛН
Student's t-test
10:11
Bozeman Science
Рет қаралды 1,8 МЛН
Performing an independent samples t test in Excel
4:26
Ken Blake
Рет қаралды 186 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Choosing a Statistical Test for Your IB Biology IA
9:58
Daniel M
Рет қаралды 789 М.
Statistics made easy ! ! !   Learn about the t-test, the chi square test, the p value and more
12:50
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,3 МЛН