Excel - One-Way ANOVA Analysis Toolpack

Many more great Excel tutorials linked below:
• Microsoft Excel Tutorials
Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques
and many useful and practical ones. Be sure to Subscribe and Comment.
Technically you should say Fail to Reject Ho because you have determined there is a lack of evidence against Ho. You have not proven Ho in any significant way. With that said, many introductory courses teach students that they can conclude that we Accept Ho. Please be aware of the nuance regardless of how you choose to phrase the conclusion.
Reject Ho, however, is a stronger statement that we can justifiably make using the laws of probability and the level of significance of the test. When we Reject Ho we are concluding that there is enough evidence against Ho with the state level of significance used. We are willing to accept the chance of making a Type I Error, but we are very clear about the probability of its occurrence, i.e., it is equal to alpha (at least nominally).

[@vannomanno1]

Best Excel ANOVA video on TH-cam. I've been looking for someone to thoroughly explain each of the components and you did it perfectly. Well Done.

[@shawnlaursen8983]

I can teach you all about the ANalysis Of VAriation test!

[@juded14]

Alex Kocher Man, all his videos are crystal clear. Everyone else just talks about the P-value and doesn't really explain all the other components on the AVOVA table. What good is that?! I wasn't sure about the F statistic or F critical, but he explains it at the end. This dude is good!

[@zaneford9851]

100%

[@ronanoconor7565]

tor hoga.. amar baal

[@armandodajti701]

Bro ur a lifesaver, i didnt understand my teacher for a month until i watched this video and understand it in 15 min

[@robynadams5212]

Really appreciate you taking the time to make this video - has explained the process perfectly. I've been able to follow all of your tips and produced my own results for separate data. Amazing! Thank you!

[@abdulsomediddrisu2353]

Thank you so much! I've been looking, for some days now, for ways to simply ascertain the f value in anova table, and I've finally gotten it from your video. Much appreciation!

[@2prettybrwneyez]

Thank you so much for this video, it was amazing in its clarity and explanation of one-way ANOVA.

[@rdjalayer]

Thank you for the thoughtful comment, glad I could help.

[@1990SammieJ]

Analysis Toolpack, where have you been all my life? Thank you so very much for this, you just saved my sanity.

[@anikatasnia1857]

where is the analysis toolpack

[@Cashman94]

I always search for longer videos instead of short ones. Once again this proved to be useful.

[@conipasch5080]

Thank you so much! This is the first time statistics made sense to me. Great clarity and explanation. The excel version provided some great short cuts I had not used before. Thank you!!!

[@christinebennett9890]

Thanks for the video. I really liked how you explained what everything means with the ANOVA. Probably one of the best videos I have watched about ANOVA

[@sashasasha2079]

2020 and this has helped me more than the newer discussions

[@KingsDream]

Sasha where to find data analysis in ms excel 2018, I couldn't find it please help.

[@101korena]

OH MY GOSH... thank you so much for making this video. You explained everything so simply, whereas my professor is teaching is as if we already know this stuff. This video is awesome.

[@elpanch]

thanks a lot for this video man! it's really concise, explanatory and just helpful as opposed to some other videos which are much slower and fail at being as practical as yours!

[@adamhardy6765]

I am so grateful for your videos. I was struggling in my statistics course until I found your channel. Thanks again and please keep making videos.

[@meganoliver7270]

Excellent video, and I have watched many as I made my way through my statistics course. Great baseline of information on the ANOVA. Thanks!

[@BennyTenuci1]

This is awesome. I finally learned ANOVA. You rock!

[@samiramadani3207]

Thanks for the video! I was trying to learn what is one-way ANOVA in high level and how to interpret the results in Excel, this video was super helpful

[@aayd7465]

AGREE, YOU STILL THERE MS SAMIRA ? XD

[@gshreekant1411]

Very good and simple explanation of how to apply Single factor Anova in excel, and understand each and every component of the Anova table. Sincerely, I have never come across such a kind of truly teaching tutorial videos on Statistics. Many thanks Jalayer Academy! .... keep going and helping others ...... with Good wishes from India !

[@whitedove2667]

This was the BEST video yet! Thank you!

[@helenmkandawire3718]

This video makes statistics look so easy. I understood everything from scratch without problens and was able to apply it in my data analysis. Thank you

[@Als1822]

thank you soooo much this was great for studying for my finals!!!

[@chandrujeyaram387]

You have been an excellent guide for teaching ANOVA. Outlandishly simple and Intriguing to learn. Thank you so much.

[@coo-kies]

You have no idea how helpful this video is to me. Thanks!

[@zoni36]

This was a well organized and easy to follow(and understand) video. Thank u for the time and effort for creating this!

[@wrightw2093]

Another awesome video that has made it so simple. I calculated everything manually on your last video but did not come up with the same answers that I did when I ran the data analysis. I'm researching to see what the difference is. Thanks!

[@mahalakshmimannar7244]

Best video for ANOVA u rock by explaining each and every part of it clearly

[@thankutay3269]

Thank you so much for amazing explanation. May I have one more question. If it is different observation numbers among the factors, can I use this one way anova or not?

[@nathaliearbousoff3476]

you're awesome. Thanks for your help from a non-statistician.
Do you also explain how to test if we're even allowed to perform the ANOVA (and if not, the alternative non-parametric solutions?)
Also, once we've rejected H0 how can we add t-tests without screwing up with alpha because of multiple testing?
Thanks again !

[@bourkedp]

You're a bloody legend mate! You have no idea how much time and effort you saved me!

[@karendowan6648]

midterm tomorrow..glad I watched this!

[@rdjalayer]

glad I could help, thanks for the thoughtful comment

[@nurfadilahkamarudin5991]

thank u, this video really help me🤗

[@PartyGod]

Thanks bro

[@geraldine.tuiran]

watching this 8 years after you posted this video but i just want to say THANK YOU! great video

[@caylaclanton6074]

Perfect explanations, perfect examples, none of the extra B.S.. THANK YOU!!

[@sjonnoh]

Short but very clear. Thanks for sharing your knowledge!

[@tiaaday6613]

thankk you so much i have exam toworrow and cant imagine if i havent found this channel

[@dextuary]

Wow! Thank you. You teach really well. Now I want to find one for one way ANOVA with replicating factors

[@shalu9197]

sir, this is vry helpful video..but unable to unstand p-value..can u explain it?

[@zoubeydabakhtaoui7030]

2021 and this had helped me to better understand the Anova analysis using Excel, many thanks to you

[@thedylanshow1]

Thank you this was exactly what I was looking for.

[@kasturiepremlall8580]

Really good video, explaining all variables very well...Tnx...I am however, still unsure why is the alpha value set at 0.05??? How does one arrive at this? should there not be a range for different data sets? its very small and surely your hypothesis will always be accepted? I am confused about this.

[@nicoleduran2433]

Thank you so much!! This helped me a lot. You're a great teacher :D

[@tanjinanoumi3742]

Bessssst Anova video.How smooth and lucid explanation 😮

[@donnie830017]

Thank goodness you posted this!

[@zethrojoshcarangan5066]

Thank you sir, I was enlightened on how to do our research step by step. It helped me a lot

[@malluenggrl]

Such an informative video! Clear, descriptive and concise....thank you! =)

[@juliana76310]

This video just saved my life thank you!!

[@elmirakh9462]

Thanks a lot. Finally I got the exact meaning of this values clearly.

[@lennyball3885]

Great video! This had all the information I was needing to know! I appreciate you!

[@christinasassine8413]

question... do you have that same video explaining the T-test on averages?

[@priyanshiagrawal1881]

Thanks sir a lot. I was completely blank about this topic. But after this video, I realised that the topic is not so hard. Thank you sir for such crystal clear methods and explanation.

[@eduardkylegocotano2302]

This is such a great help. Thank you so much. Better than other vidoes

[@VivianHart]

I am watching this in 2020. It is still very helpful. Thank you so much for sharing this video.

[@basirulislam8730]

Thanks a lot man, I just love your details analysis. Very helpful :)

[@johnbeko691]

Simple and best interpretation of one-way ANOVA. Top

[@ShawnMurray]

Thanks bro!! I needed this.

[@garethjones3059]

Great, this has really helped me understand one way anova, Thank you

[@jaspalnarwal]

Thanks mate, this video has helped me a lot. Keep up the good work

[@richardowens6868]

your explanation was very thorough and helpful, more informative than the teacher. I wish you were the teacher. thank you.

[@Wantaper123]

you just made my life easier with this video!! i understand you better than my teacher

[@mobr.]

Well done. This was a very informative and clear video.

[@s_p_a_c_e_m_a_n]

this video should have a million hits! Very informative! thanks!

[@rdjalayer]

spread the word! thanks for the comment

[@Seikochu]

Great video for data analysis beginner. Clear and on point!!!!! Thank you so much!!!

[@kryhaunts]

GOD BLESS YOU AND THIS VIDEO YOU ARE THE ONLY REASON I AM GOING TO PASS MY RESEARCH METHODS LAB!!!!!!!!!!!!!!!!!!!!!

[@drrajasekharmathangi6212]

FANTASTIC EXPLANATION SIR

[@maribethfaithreambillo6462]

Thanks you so much it took a day to compute my anova. this is very informative it solved my problem.

[@krysren]

Very nice video. Do you know if Excel has the capability to plot the oneway analysis (similar to how JMP does)? Not just the mean but the continuous set of Y variables vs. X? My company does not have JMP (and will NOT purchase it) so I'm forced to use Excel only. It would be great if I could figure how to make box plots, etc in Excel. Thanks for your help.

[@rajesshmech]

Very clear explanation and easy to understand. Thank you sir

[@am3dz]

awesome jalayer..you deserve appreciation..

[@melodysandravanukon2401]

you are a good teacher. thank you .

[@plamenyankov8476]

Beautiful video, Thanks!

[@clearedmass066]

this was very helpful in my Statistical Research class. thank you for the video.

[@loisrajcan3117]

Thanks for this video....you made this so much clearer for me.

[@sophiar5280]

Great explanation!

[@anchisapoonprasartporn9000]

Thanks very much. Your video is so useful, clear explanation!

[@user-dm6ys7ty8c]

Excellent. Thank you so much. You know better the students' mentality and how to explain problems such as this(One-way ANOVA Analysis).

[@AbdulRahman-lr5fz]

Thank u brother, I was struggling by watching ur video my issue got resolve 🥰

[@mojtabamasoumi4855]

Very clear explanation, GREAT!

[@jamvibes3550]

Very clear explanation. Thank you so much!

[@MrArkadiusz1985]

thank you! really helped with preparing to my exam!

[@boomplay7908]

Amazing!! very well done my friend

[@ehlehlohtz1791]

Thank you so much! This is a really big help.

[@dr.gurjitsinghbhathal7982]

This video explain ANOVA step by step and very clear like a expert teacher

[@shaziaparveen7027]

Very helpful. Thank you !

[@effiewow]

This is amazing & super helpful!!! Thank you.

[@nooraghanawakht7799]

Nicely explained. Thank you

[@mariacristinamoscosozuniga8222]

THANK YOU this was really useful.

[@Ramkumarjaga]

Thanks a lot for this video. Saved a lot of time in doing assignment because of this video

[@derickouma4511]

Thank you for your explanation.

[@kunalgoel6367]

Thank you, Simple & crisp.

[@ahmeddarwish1752]

fantastic explanation, really thanks a lot

[@noelhuerta9670]

Very helpful. Thank you for your service

[@ARWA8400]

THANK YOU SO MUCH YOU'RE AMAZING!

[@sandyjameswilliams40]

Cheers man! You nailed it

[@ens2422]

this is just brilliant...helped me a lot thanks Jalayer Academy

[@michaelpaulse1]

Thank you. Great video.

[@user-nv7rc2se5l]

Its simple and to the point. Thanks

[@masreshabirara1398]

Thank you i learn a lot

[@aayd7465]

you are just a LEGEND

[@sarithachandrasekar690]

Really appreciate , literally a good and clear explanation !!! 10/10 . many thanks

[@ayreonfreak]

Do you always need the same amount for every factor or can you also test group A (20 accession) with group B (25 accessions)?

[@wafulamuyala14]

Thanks a bunch. You helped me crack a seemingly daunting task easily.