Тёмный

How To... Perform a Two-Way ANOVA in Excel 2013 

Eugene O'Loughlin
Подписаться 87 тыс.
Просмотров 366 тыс.
50% 1

Опубликовано:

 

30 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 106   
@matthewdaw6485
@matthewdaw6485 4 года назад
You, my dear man, are a lifesaver. I easily spent an hour trying to figure this out on my own and I imagine I would have spent far more time if I didn't find your video.
@timmytrombley529
@timmytrombley529 6 лет назад
Gentlemen and a scholar, was literally wasting an hour and you fixed my problem in 2 minutes
@JunLiangOng
@JunLiangOng 18 дней назад
Bless you Sir! You explained it in such a simple and succinct manner. I understood this example perfectly. Thank you ❤
@maya-lilywan8234
@maya-lilywan8234 Год назад
I am currently completing a scientific project for my dissertation which will be submitted by the end of August this year! I honestly did not understand one-way or two-way ANOVA from the explanations that were given to us and after watching this I did it with ease! A massive thank you - I cannot explain how much help this has been :)
@EugeneOLoughlin
@EugeneOLoughlin Год назад
Glad to be of help!
@sammicook3010
@sammicook3010 Год назад
Same here! This video has saved me, thank you!
@vierwhey
@vierwhey 11 месяцев назад
Ay man i love you! I have watched your Chi square tutortial before during my bachelor in environemental sciences. And now im writting a bachelor in biology! Irish accent is also very charming
@MatthewBuenvenida
@MatthewBuenvenida 18 дней назад
Thank you! Really nice breakdown of what the data analysis is telling you
@brendankilkenny
@brendankilkenny 6 лет назад
I've been finding these videos very helpful. The combination of logic explained and then how to process it in Excel it particularly good. Thank you!
@hmaei
@hmaei 4 года назад
THANK YOU!!! I now fully understand how to do two way anova and to interpret. I can finally start my scientific paper!
@GlynisDance
@GlynisDance 2 года назад
Thank you - I just added the data analysis to excel - that's going to save me time!
@Moonstonn
@Moonstonn 3 года назад
I found this video very, very, very useful. Thank you. I'm tempted to type more 'very's 🤩
@rafindraanindito139
@rafindraanindito139 6 месяцев назад
Thank you so much, mister Eugene. I hope you have a happy life
@leoleo5263
@leoleo5263 4 года назад
You are a hero in 2020.
@JANSSENDALUMOS
@JANSSENDALUMOS Год назад
thank youuu, this really helped with my thesis❤❤
@PeterSdrolias
@PeterSdrolias 2 года назад
Excellent explanation! While not ideal, I was taught that Anova is still quite robust despite unequal group numbers.
@showardnutrition
@showardnutrition 2 года назад
Brilliant! Thank you so much. More of my stats anxiety melting away right when I needed it to.
@bhawanayadav9983
@bhawanayadav9983 4 месяца назад
Thank you soooooo much for this video!!!! ❤🎉
@BYUGRL1
@BYUGRL1 3 года назад
Finally found a video that explained Two-Way ANOVA thoroughly. Thank you!
@chaosbolt5392
@chaosbolt5392 6 лет назад
Better i should learn the things from you sir, its a very very use full for me... plz keep uploading like these videos.
@zachcatalano3132
@zachcatalano3132 3 года назад
Eugene, thank you. You have saved my group a ton of headache from explaining the statistical significance of the interaction.
@alinamayorga9498
@alinamayorga9498 5 лет назад
Excelent way of explaining! I've been trying to understand how two-way anova works and this did it for me. Thanks a lot!
@lungelodlamini1951
@lungelodlamini1951 Год назад
Thank you for your information sir!
@EugeneOLoughlin
@EugeneOLoughlin Год назад
My pleasure
@TheToniojc
@TheToniojc 2 года назад
Thank you so much. It's been a year and a half since I had done this and I had completely forgotten how to orient the table.
@ledilynunlad1833
@ledilynunlad1833 5 месяцев назад
Sir, please enlighten me about what you said in 5:40 minutes. You said the p-value (5.4E-08) is tiny which means, reject the null hypothesis. I am confused, how can it be tiny compared to the 0.05 alpha value? I will discuss this topic, and your video greatly helps me. Only that, I am confused about this part. Thank you.
@ledilynunlad1833
@ledilynunlad1833 5 месяцев назад
I'm enlightened already sir. This might help others who have the same confusion with 5.4E-08. At first, I assumed this was greater than the alpha value 0.05. I asked the help of ChatGPT and here is the explanation: The notation "5.43985E-08" is a representation of a number in scientific notation. It's a way to express very large or very small numbers in a compact form. In scientific notation, a number is expressed as a coefficient multiplied by a power of 10. The "E" stands for "exponent," and it tells you how many places to move the decimal point. So, "5.43985E-08" means 5.43985×10 −8 , which is equivalent to 0.0000000543985. Indeed, this is very tiny compared to the 0.05. Hope this helps.
@HasiniA619
@HasiniA619 Год назад
Thank you very much for your perfect explanation!
@tingtingchen1455
@tingtingchen1455 3 года назад
Thank you professor, I find this video is very easy to follow and understand!
@mikalawoodall7630
@mikalawoodall7630 4 года назад
Incredibly helpful video, well explained and reasoning behind statistical test was great!
@danielzonoka1934
@danielzonoka1934 7 лет назад
It's been awhile since I took stats, this helped a billion! Thanks.
@brshankar2010
@brshankar2010 4 года назад
Thank you, very clear presentation
@kikily89
@kikily89 2 года назад
Very helpful! Thank you.
@gitanshtalesra1984
@gitanshtalesra1984 6 лет назад
Very informative and clear, concise explanation.
@marjoriebillones9359
@marjoriebillones9359 4 года назад
Thank you so much for sharing sir. Very helpful indeed! This helped me a lot especially on the interpretation of results.
@Holmesymom
@Holmesymom 6 лет назад
Fantastic video. One of the best out there. Thank you.
@md.shahadathossen3474
@md.shahadathossen3474 4 года назад
Thank you very much. It's really helpful😍
@laurysparks6215
@laurysparks6215 7 лет назад
Thank you! Very clear explanation!
@RH-yc3ow
@RH-yc3ow Год назад
Thank you!
@TechByteOfficial
@TechByteOfficial 2 года назад
Thanks for the video! Quick Question: How do I interpret the result if F is greater than F-crit, but the p-value is very high (~0,4)? Thanks!
@EugeneOLoughlin
@EugeneOLoughlin 2 года назад
Hi TechByte, You should not get both together - please recheck your calculations. An F stat greater than F crit means that you reject the Null Hypothesis, and p-value greater than alpha means that you cannot reject the Null Hypothesis. Hope this helps, Dr E.
@TechByteOfficial
@TechByteOfficial 2 года назад
@@EugeneOLoughlin thanks for the reply Dr. E! Really appreciate it :) I’ve since found the mistake: I had a typo in my alpha value. It was set to 0,5 instead of 0,05 🤦‍♂️ Still interesting though, that the p-value and F statistic can contradict each other when you have a large alpha! By the way, are there any other follow up tests you can recommend if none of your null hypotheses can be rejected? My p-values are 0,478, 0,435 and 0,078 respectively, so there are no statistically significant effects or interactions at a level of alpha = 0,05. Thank you, and have a nice day!
@mingyf
@mingyf 7 лет назад
extremely helpful!!! thank you, saved my team's group project!
@puneethlove
@puneethlove 5 лет назад
Thanks Dr. Eugene it helped a lot
@saikatsen391
@saikatsen391 3 года назад
Sir,it's indeed helpful.Many Thanks from India. Could you please make another video of w/o replication as well?
@krystalryan5442
@krystalryan5442 4 года назад
Very very helpful! Thank you so much!
@seolemn
@seolemn 4 года назад
saved my ass on solving for statistics, thank you for this!
@ryandonnelly8901
@ryandonnelly8901 4 года назад
Amazing explanation, thank you so much!
@asaadkhadra4873
@asaadkhadra4873 4 года назад
very helpful, thanks sooo much
@johncharles3907
@johncharles3907 4 года назад
Very helpful. Thanks!
@QuickSh0tZz
@QuickSh0tZz 6 лет назад
yo thanks man, just saved my ass on a final
@nizamadhaabdraoff5934
@nizamadhaabdraoff5934 7 лет назад
i found this video useful. Thank You kind Sir.
@alexandradutuc5996
@alexandradutuc5996 6 лет назад
Hi Eugene. Thank you for all "How to..." videos, are REALLY helping me. One quick question: the TWO WAY ANOVA test can be performed by hand also rather than performed in Excel? Thank you
@EugeneOLoughlin
@EugeneOLoughlin 6 лет назад
Hi Alexandra, First - many thanks for your kind comment. The 2 x ANOVA, and all other ANOVA tests, can of course be done by hand. But it is a lot more complicated then the 1 x ANOVA. I don't cover it in my classes - I just use Excel (plus SPSS and R) to perform the two-way ANOVA. Dr E.
@valeriagonzalez9372
@valeriagonzalez9372 2 года назад
Thank you so so much
@kapunyaa-lua8027
@kapunyaa-lua8027 5 лет назад
I Dr. I ran the Two Way Anova with replication but, I got an output with a = #NUM! and p-value = #NUM!. I also imported the data into spss. The result came out without interaction. What can I do in this case Sir?
@poojaveedu9641
@poojaveedu9641 5 лет назад
Super helpful! Thank you so much!
@dist321
@dist321 6 лет назад
super helpful! Thanks a lot!
@wirechair
@wirechair 7 лет назад
Thanks sir, very clear explanation.
@mweri00
@mweri00 5 лет назад
good morning sir. how can we determine which of the brand was better? is it the best or super?
@2ndChance54
@2ndChance54 4 года назад
good teacher
@anurajms
@anurajms Год назад
thank you
@wesselvanengelenburg325
@wesselvanengelenburg325 6 лет назад
Thanks, excellent instruction
@pradiptakumardeb6985
@pradiptakumardeb6985 4 года назад
VERY HELPFUL
@speedygonzales9993
@speedygonzales9993 11 месяцев назад
👍👍👍 ! ! ! Super Duper AWESOME!
@Mnga86
@Mnga86 7 лет назад
Many thanks sir.. that is really helpful
@funwithas9399
@funwithas9399 2 года назад
Sir can we perform 2 way anova with more than one observation per cell in Excel
@chionomys
@chionomys 3 года назад
Many thanks
@Authentian7343
@Authentian7343 3 года назад
Thank you sir
@bawariamahi
@bawariamahi 3 года назад
Sir I have a dependent variable i.e accident count in form of numbers and multiple independent variables i.e different land use in form of areas , please suggest which statistical analysis can be used. I have these data for 7 different areas .
@minotigupta6714
@minotigupta6714 Год назад
Sir whenever i apply 2 way anova with replication it is showing that input range consist of non-numeric data....what shoukd i do?
@kayecrypto4594
@kayecrypto4594 5 лет назад
Do i need to compare the datas to the initial value?
@shani2401
@shani2401 5 лет назад
Thank you, helped me a lot. One question - in case the number of row is not the same - I need to use ANOVA without replication?
@junaidgamedev
@junaidgamedev 4 года назад
Man I have the same issue. Did you get the answer?
@shani2401
@shani2401 4 года назад
@@junaidgamedev it cannot be done in excel.. someone helped me with another software, i dont remember the name, sorry.
@mahipalram5340
@mahipalram5340 3 года назад
I have selected all variables and labels but error show of input range contains non numeric data...
@KrazyKennez
@KrazyKennez 3 года назад
What can I do in Excel if I have some null values and unequal sample sizes?
@calebc.o4770
@calebc.o4770 Год назад
What if you have uneven rows in a sample
@ArtVandelay99
@ArtVandelay99 5 лет назад
Hi Eugene, is it the case that what Excel understands by "with replication" is what is traditionally known as "between subjects"? In other words, is the analysis you explain here suitable if the different rows in each category represent different individuals (cases), and the category is a type of individual, e.g. instead of the Super and Best brands with its 4 rows each, we had Men and Women categories, each with 4 subjects? many thanks!
@davidwand8046
@davidwand8046 Год назад
My understanding is that 'between subjects' means each person gets only 1 treatment while 'within subjects' can be where the same person gets more than 1 treatment. I don't have my statistics book with me but the tricky part is whether the number of subjects for each treatment has to be the same. Here, it seems to be yes.
@j.jvonmalk7048
@j.jvonmalk7048 4 года назад
what if your rows are not the same? Iv been given a set of data points, that are equivalent in number
@muradmujahed7151
@muradmujahed7151 7 лет назад
very helpful and easy
@abrarbio1828
@abrarbio1828 7 лет назад
Thanks that was very helpful :)
@rahmaamr2596
@rahmaamr2596 5 лет назад
Thank you a LOT!!!
@kylaneale9567
@kylaneale9567 Год назад
What can do if your rows of your sample are uneven? That is that some in one factor there is 16 data point and another there is 23
@EugeneOLoughlin
@EugeneOLoughlin Год назад
Hi Kyla, This will not work in Excel - you could use another tool such as SPSS or R. Dr E.
@anaswahid8520
@anaswahid8520 5 лет назад
You have not specified that which 2 are different It is done by finding Critical difference and Mod(T1-T2) T1 and T2 are averages of brands Please make a separate video for this problem.
@mayarelbaz9924
@mayarelbaz9924 3 года назад
What do we do if we do not have the same number of data in each row? Thank you!
@EugeneOLoughlin
@EugeneOLoughlin 3 года назад
Hi Mayar, Unfortunately Excel 2013 does allow for uneven data - it will not work. Don't be tempted to insert zeros or other data, as this will mess with your results. You may need to work out by hand/manually, or use another tool such as SPSS. Dr E.
@amirfaiz4040
@amirfaiz4040 4 года назад
THANK YOU
@clarkmiller4361
@clarkmiller4361 4 года назад
thank you!!!!
@joshuas.geraldino1202
@joshuas.geraldino1202 4 года назад
Always shows that input range has non-numeric data. I'm really frustrated now
@EugeneOLoughlin
@EugeneOLoughlin 4 года назад
Hi Joshua, This error is usually due to one of two things. First - if you have any non-numeric data in your data table, like a character or date, this will not work with any ANOVA tool. So the obvious first check is to remove any non-numeric data. But the second, and most common, reason is that you do not have the same number of values in each cell. In my example in the video there are four values in each cell: eg, four Cold values for the Super brand, four Warm values for the Super brand, and so on. In Excel you MUSThave the same number of values in each row - in my video at 2:35 I enter the number 4 in the "Rows per sample" box. So if you have three values in one cell, and four in the rest - Excel will not work. This is a quirk of Excel - other tools such as SPSS can handle this. Hope this helps, Dr E.
@joshuas.geraldino1202
@joshuas.geraldino1202 4 года назад
@@EugeneOLoughlin I checked so many times and it really is not working. The only thing I can notice on the sheet Im working on is that every number is in 2 decimal places (e.g. 14.20). The headings are non numeric but it worked for you when youused the ANOVA function on the table you have in the video. I also rechecked and it has equal number of rows per sample. I don't really know now whats wrong with excel
@EugeneOLoughlin
@EugeneOLoughlin 4 года назад
Hi Joshua, Two decimal places should not matter. Double check that all your data are formatted as numeric, and that you have laid it out on the spread sheet in the way my data are at the beginning of the video. Make sure that you do not have any blank cells. Otherwise I cannot tell why this is not working for you. Dr E.
@joshuas.geraldino1202
@joshuas.geraldino1202 4 года назад
@@EugeneOLoughlin Thank you! It works now - seems excel just wanted me to redo the data at a new sheet. thanks again!
@EugeneOLoughlin
@EugeneOLoughlin 4 года назад
@@joshuas.geraldino1202 :-)
@drnandkishorbagul3087
@drnandkishorbagul3087 4 года назад
Sir, if the number of rows are not same and even the number of samples are also not same in each sector then how to run this ANOVA
@EugeneOLoughlin
@EugeneOLoughlin 4 года назад
Hi Nankishor, You cannot do this in Excel - use another tool like Minitab, EPSS, R, etc. Dr E.
@Shibby8911
@Shibby8911 5 лет назад
Thank you!!
@JunLiangOng
@JunLiangOng 18 дней назад
Bless you Sir! You explained it in such a simple and succinct manner. I understood this example perfectly. Thank you ❤
@flagshipbuilds
@flagshipbuilds 5 лет назад
Thank you!
@armoda1057
@armoda1057 7 лет назад
thank you
@dennismunene1897
@dennismunene1897 2 года назад
Many Thanks
@samanthahewitt202
@samanthahewitt202 7 лет назад
thank you
Далее
Excel - One-Way ANOVA      Analysis Toolpack
14:10
Просмотров 723 тыс.
How To Perform A One-Way ANOVA Test In Excel
8:31
Просмотров 766 тыс.
Introduction to Two Way ANOVA (Factorial Analysis)
8:01
Using ANOVA output to make a graph
9:02
Просмотров 181 тыс.
One-way ANOVA & Post-Hoc Analysis in Excel
10:21
Просмотров 42 тыс.
ANOVA - A Full Lecture to learn Analysis of Variance
56:49