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 RUclips. 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!

[@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!!!

[@Cashman94]

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

[@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

[@BennyTenuci1]

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

[@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!

[@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.

[@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

[@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!

[@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.

[@Als1822]

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

[@zoni36]

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

[@mahalakshmimannar7244]

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

[@chandrujeyaram387]

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

[@sjonnoh]

Short but very clear. Thanks for sharing your knowledge!

[@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

[@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.

[@coo-kies]

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

[@caylaclanton6074]

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

[@whitedove2667]

This was the BEST video yet! Thank you!

[@karendowan6648]

midterm tomorrow..glad I watched this!

[@geraldine.tuiran]

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

[@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!

[@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 !

[@bourkedp]

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

[@dextuary]

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

[@zoubeydabakhtaoui7030]

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

[@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

[@tiaaday6613]

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

[@thedylanshow1]

Thank you this was exactly what I was looking for.

[@elmirakh9462]

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

[@nicoleduran2433]

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

[@lennyball3885]

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

[@juliana76310]

This video just saved my life thank you!!

[@zethrojoshcarangan5066]

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

[@Seikochu]

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

[@eduardkylegocotano2302]

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

[@malluenggrl]

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

[@garethjones3059]

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

[@Wantaper123]

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

[@rdjalayer]

glad I could help, thanks for the thoughtful comment

[@nurfadilahkamarudin5991]

thank u, this video really help me🤗

[@PartyGod]

Thanks bro

[@johnbeko691]

Simple and best interpretation of one-way ANOVA. Top

[@basirulislam8730]

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

[@VivianHart]

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

[@loisrajcan3117]

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

[@richardowens6868]

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

[@jamvibes3550]

Very clear explanation. Thank you so much!

[@mobr.]

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

[@donnie830017]

Thank goodness you posted this!

[@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).

[@jaspalnarwal]

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

[@tanjinanoumi3742]

Bessssst Anova video.How smooth and lucid explanation 😮

[@wafulamuyala14]

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

[@am3dz]

awesome jalayer..you deserve appreciation..

[@dr.gurjitsinghbhathal7982]

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

[@MrArkadiusz1985]

thank you! really helped with preparing to my exam!

[@clearedmass066]

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

[@AbdulRahman-lr5fz]

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

[@Ramkumarjaga]

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

[@maribethfaithreambillo6462]

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

[@rajesshmech]

Very clear explanation and easy to understand. Thank you sir

[@anchisapoonprasartporn9000]

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

[@sarithachandrasekar690]

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

[@ens2422]

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

[@riadhalsaid2695]

Thank you for the very clear simple teaching video one way ANOVA

[@effiewow]

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

[@kunalgoel6367]

Thank you, Simple & crisp.

[@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.

[@mojtabamasoumi4855]

Very clear explanation, GREAT!

[@ShawnMurray]

Thanks bro!! I needed this.

[@gregalisondrr]

woow. i honestly didnt know aything about this exel and anova thing. i often asked for help from my classmates but this was absolutely helpful. now i understand it all. thaank u so much

[@kryhaunts]

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

[@SandeepKumarSathuaSKS]

Very Nicely explained the procedure....Great Work.

[@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

[@ARWA8400]

THANK YOU SO MUCH YOU'RE AMAZING!

[@mariacristinamoscosozuniga8222]

THANK YOU this was really useful.

[@drrajasekharmathangi6212]

FANTASTIC EXPLANATION SIR

[@boomplay7908]

Amazing!! very well done my friend

[@454545hazel]

very clear, totally hadnt bothered with the sig. of F critical but shall now I get it cheers x

[@user-nv7rc2se5l]

Its simple and to the point. Thanks

[@RaulTorres-lj3ki]

Thank you so much man! you've saved my semester with your explanation ( by the way, much better than my professor's explanation).

[@daveescoro2349]

It was enlighten my mind after watching this videos big thumbs up 👍

[@plamenyankov8476]

Beautiful video, Thanks!

[@nooraghanawakht7799]

Nicely explained. Thank you

[@ehlehlohtz1791]

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

[@athinak5717]

Thank you very much! So much time saved!

[@melodysandravanukon2401]

you are a good teacher. thank you .

[@thehubvideos6854]

wow.. thank you bro! now i understand - Eric from Philippines

[@hannafimuktah2574]

thank you..listening to your explaination much more understandable......(sorry for bad english)

[@copypen1362]

Excellent stuff bro

[@noelhuerta9670]

Very helpful. Thank you for your service

[@halloffame_y5369]

Nice one
Thanks for Simplifying
You just earn my subscription

[@47topoftheworld]

I appreciate your explanation.

[@sandyjameswilliams40]

Cheers man! You nailed it

[@sheet-son]

I need to do this, thankyou so much.

[@argilynngantala383]

thank you so much sir. very helpful tutorial.