How To... Perform a Two-Way ANOVA in Excel 2013
HTML-код
- Опубликовано: 4 ноя 2024
- Learn how to perform a two-way analysis of variance in Excel (version 2013). Use two-way ANOVA when you have one measurement variable and two nominal variables. Also know as Factorial Analysis of Variance.
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.
Gentlemen and a scholar, was literally wasting an hour and you fixed my problem in 2 minutes
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!
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 :)
Glad to be of help!
Same here! This video has saved me, thank you!
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
Bless you Sir! You explained it in such a simple and succinct manner. I understood this example perfectly. Thank you ❤
THANK YOU!!! I now fully understand how to do two way anova and to interpret. I can finally start my scientific paper!
Thank you! Really nice breakdown of what the data analysis is telling you
Finally found a video that explained Two-Way ANOVA thoroughly. Thank you!
Thank you so much, mister Eugene. I hope you have a happy life
Excelent way of explaining! I've been trying to understand how two-way anova works and this did it for me. Thanks a lot!
Thank you - I just added the data analysis to excel - that's going to save me time!
I found this video very, very, very useful. Thank you. I'm tempted to type more 'very's 🤩
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.
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.
Eugene, thank you. You have saved my group a ton of headache from explaining the statistical significance of the interaction.
You are a hero in 2020.
Brilliant! Thank you so much. More of my stats anxiety melting away right when I needed it to.
Better i should learn the things from you sir, its a very very use full for me... plz keep uploading like these videos.
Excellent explanation! While not ideal, I was taught that Anova is still quite robust despite unequal group numbers.
Thank you professor, I find this video is very easy to follow and understand!
thank youuu, this really helped with my thesis❤❤
Incredibly helpful video, well explained and reasoning behind statistical test was great!
It's been awhile since I took stats, this helped a billion! Thanks.
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!
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.
@@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!
extremely helpful!!! thank you, saved my team's group project!
Sir,it's indeed helpful.Many Thanks from India. Could you please make another video of w/o replication as well?
Thank you so much for sharing sir. Very helpful indeed! This helped me a lot especially on the interpretation of results.
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.
Very informative and clear, concise explanation.
Thank you soooooo much for this video!!!! ❤🎉
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
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.
Fantastic video. One of the best out there. Thank you.
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?
Thank you, very clear presentation
yo thanks man, just saved my ass on a final
saved my ass on solving for statistics, thank you for this!
Thank you for your information sir!
My pleasure
good morning sir. how can we determine which of the brand was better? is it the best or super?
Thank you very much. It's really helpful😍
Thanks Dr. Eugene it helped a lot
Thank you! Very clear explanation!
Sir can we perform 2 way anova with more than one observation per cell in Excel
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?
Man I have the same issue. Did you get the answer?
@@junaidgamedev it cannot be done in excel.. someone helped me with another software, i dont remember the name, sorry.
Very helpful! Thank you.
What can I do in Excel if I have some null values and unequal sample sizes?
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 .
I have selected all variables and labels but error show of input range contains non numeric data...
Amazing explanation, thank you so much!
what if your rows are not the same? Iv been given a set of data points, that are equivalent in number
i found this video useful. Thank You kind Sir.
Very very helpful! Thank you so much!
Sir whenever i apply 2 way anova with replication it is showing that input range consist of non-numeric data....what shoukd i do?
Thank you very much for your perfect explanation!
Thanks sir, very clear explanation.
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!
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.
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
Hi Kyla,
This will not work in Excel - you could use another tool such as SPSS or R.
Dr E.
Do i need to compare the datas to the initial value?
Very helpful. Thanks!
very helpful, thanks sooo much
Super helpful! Thank you so much!
good teacher
Many thanks sir.. that is really helpful
What if you have uneven rows in a sample
super helpful! Thanks a lot!
Thanks, excellent instruction
VERY HELPFUL
What do we do if we do not have the same number of data in each row? Thank you!
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.
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.
Thank you so so much
very helpful and easy
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
Hi Nankishor,
You cannot do this in Excel - use another tool like Minitab, EPSS, R, etc.
Dr E.
Always shows that input range has non-numeric data. I'm really frustrated now
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.
@@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
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.
@@EugeneOLoughlin Thank you! It works now - seems excel just wanted me to redo the data at a new sheet. thanks again!
@@joshuas.geraldino1202 :-)
Many thanks
Thanks that was very helpful :)
Thank you sir
Thank you a LOT!!!
👍👍👍 ! ! ! Super Duper AWESOME!
THANK YOU
thank you!!!!
Thank you!
Thank you!!
thank you
Bless you Sir! You explained it in such a simple and succinct manner. I understood this example perfectly. Thank you ❤
Thank you!
thank you
thank you
Many Thanks