Performing a One-way ANOVA in Excel with post-hoc t-tests
ฝัง
- เผยแพร่เมื่อ 11 เม.ย. 2013
- Tuorial describing how to perform a one-way ANOVA on groups of data and then carry out post-hoc t-tests between groups to determine significant differences.
This is part of a series of tutorials designed to help research scientists in the use of certain software applications commonly used in scientific laboratory work.
You can find the entire set of tutorial videos here: ehealth.kcl.ac.uk/sites/physio...
The screencast videos have been made by the author (Dr James Clark, King's College London) in response to common questions raised by students on BSc and MSc courses and are recorded using Camtasia Studio. The content is targeted at students of all levels of undergraduate and postgraduate education as well as professional research scientists.
If you wish to link to this video on another web site please make sure you credit the author and provide a link to the blog site (shown above)
©2013 James Clark, king's College London. All rights reserved. - แนวปฏิบัติและการใช้ชีวิต
thank you so much, your calm and clear way of explaining really helped me with my thesis, I never was a very bright user of statistics (more the practical kind of guy) so it helped me big times..Greetings
You were extremely helpful with clear explanations. A huge thumbs up to you :)
I've been struggling with this for ages, thank you so much.
Glad it helped
Very helpful and straightforward. Thank you for posting!
Thanks for the simple explanations. I've been trying to figure out how to compare two groups within an ANOVA for a while. I feel dumb not realizing you do a simple t test.
THANK YOU SO MUCH!! Makes so much sense now !
Very clear explanation, appreciate it!
Thank you so much! You are a life-saver.
very Helpful and easy to understand, thankyou Sir
excellent help. Thanks a lot!
Thank you! Your lecture is so much easy to understand. GReatly appreciated.
My pleasure
Thank you very much!!
Thank you so much!
Thank you so much ..It is really very helpful
Thank you!
Crystal clear. Thanks!
My pleasure!
wow! thank you so much!
Very helpful! Thank you for the clear explanation.
My pleasure!
very nice video.
but how you assume that groups have equal variances? and please show us how you make group B bar in this graph ?
thanks so much!!!
Great video, thanks!
my pleasure, goad you find it helpful!
Thank you for your professional explanation. Can i perform it among 7 different sites? Thanks
great video, great explanation -- I could have used this 3 days ago LOL
youtube is just now recommending it to me after I spent the last week seraching for stuff like this
Thank you :)
what when we use two comparisons, do we have to divide 0.05 by two for Bonferroni test. Thanks in advance!
Thank you so much for your help>> I have been trying to download SPSS since 3 days and never succeeded... :)
Thank you for this!
My pleasure!
Fantastic! Thanks
My pleasure. Please subscribe as I’m adding more videos all the time
thankyou from 2019 this saved me
Happy to help
Thank you very much. It's very helpful and clear.
My pleasure!
very helpful explanation. thank you sir
Happy to help
I just passed and exam thanks to you!
Great job!
where tf were you when i was doing my stats paper!!! ur amazing!!!
hi
what if we have too many groups to do the post test say 50-100 groups?? How to do it then? any other methods
Wouldn't you expect Group B to be significant, as the sample size of Group B is higher than both other groups. Then, you are assuming equal variances although they are not. Group B is twice as high as Group A! Surely, a T test with assuming unequal variance would be the best way to go? Please fill in the gaps please? Thanks
thank you so much!
My pleasure!
Thanks so much for this well detail video, definitely using now to do my final year project
My pleasure
nice explanation sir.
My pleasure. Glad I could be of help to you
Do you actually have to compare group b with group c if the graph tells you that group a and group b are significantly different, and that group c is smaller than group a? Thank you for the response!
The test is what tells you if the difference is SIGNIFICANT. Seeing it on the graph shows there's a difference, not that the difference is significant
Great video thank you.
Could anyone help me please... ? I am confused when to use Equal variance or Unequal Variance during selecting the t-test
Thanks~
You’re welcome!
how did you find value 0.0167?
Why do you not a F-test to know if the variance is different, and why not paired two samples for means? thank you
There are actually 4 tests performed if you include the anova. Shouldn't the correction change 0.05 into 0.05/4 instead of 0.05/3? If anyone can help me on this question, thanks
No. He was referring to the number of pair-wise comparisons as the denominator for the Bonferroni correction. In this case, it's 3 (A-B; A-C; B-C). Generally, it's Comb(n, 2) where Comb(n, k) is the combination function for n taken k, and n is the number of elements (groups).
This is helpful, but how do I run the post- hoc tests if I have 5 groups?
I’m not sure if excel can handle that many groups.
Cannot find "Data Analysis" button under the Data section. Should i download it?
Yes as the video says you have to enable it first
I love you
Why thank you!
What kind of post hoc test is this?
Why would you select "t-test assuming equal variances" when the result show that the variances are in fact, unequal?
would u please tell about how 0.0167 comes out?
Not sure what you mean there, that’s the P value as a result of the ANOVA
He divided the significant level (0.05) by the number of comparisons which are 3 in this example.
Can i use one tailed t test
You CAN do one in excel, of course, just adjust the parameter in the function when performing a t-test; but for data with more then two groups you cannot reasonably use a t-test.
If I was going to do a T-test for each one to check if they are significantly different ANYWAY, wouldn't I just skip the ANOVA step? Seems unnecessary..
You would increase your chance of error by running a bunch of t-tests.
but the ANOVA is an additional analysis, how doesn't it increase the overall alpha risk?
Jesús Robiragz Moirruf 💋 Ayúdame
BodoMs-Los -Los