Perform ANOVA Post-Hoc Tests (Bonferroni Correction) In Excel

In this tutorial, I’m going to show you how to perform the Bonferroni correction in Excel following a significant one-way ANOVA resut. Performing post-hoc tests with the Bonferroni correction will determine where the group differences are.

VIDEO CHAPTERS
00:00 Intro
00:21 My example data
01:13 Performing T-tests
03:25 Bonferroni correction overview
04:41 Performing Bonferroni correction
05:27 Using the IF function
07:08 Interpreting the results

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Software (Microsoft Word 365 ProPlus)

FOLLOW US

AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[malwalsabino]

Now my understanding of ANOVA in general and single factors including post ad-hoc is complete. Thank you so much for the clear interpretation.

[Twhyte]

Two years on and this video is still doing the Lords work 🎉❤

[RileyBiggins]

these videos are some of the best tutorials on the internet. Thank you

[lordsiomai]

you don't get enough credit for how well explained, well edited, and well presented your videos are. you put so much info in such a short amount of time it's amazing

[kendesmarais]

Excellent video! Not only do you show how to do it simply, but now I understand HOW it works and why. Thank you!

[kryptorick]

I just stumbled upon this channel. I really appreciate the clarity of your explanations. These are topics that can easily be made obscure by disorganized explanations. You keep every simple, accurate and organized. Thank you for that

[shivanandathippenahalli]

I am amazed at your simple yet logical conclusions drawn using simple tools available in EXCEL. Thanks again. I appreciate your teaching skills

[mohammedmanik]

One of the best videos I have ever seen. Thank you, Mr. Steven

[sofiacumbo]

You made my day! I was upset because I didn't know how to comment my data and you gave me a perfect way to do that! Thank you again

[juliantrevino]

Thank you so much for this video! It helped a great deal with my homework assignment! The textbook just wasn't doing it for me, but after hearing your explanation I got it completely!

[somasarkhel]

extremely useful contents and great way to deliver.loved it.

[anuragkhare]

Thanks for the great series of videos!! really appreciate your efforts!!

[QuantumLegal]

This was infinitely easier than the way my prof tortured us with

[eizkuqq]

Wow
I've just found out excel is a great tool

[monolune]

I appreciate your very helpful and concise content!

Just a few questions, though:
1. If 2 of the groups turned out to be insignificant, and only 1 is significant, is the null hypotheses then considered? If so, are there any statistical tests to be applied next?
2. In the last slide, why is it that you used p<0.001?

Thank you very much!! ❤

[leoaviles]

SUBBED. Clear presentation and easy to follow guidance. Thanks!

[sethasamoah]

you are great. Thanks for this amazing video

[srinithisrinivasan]

Can you please do tukey's test pls..

[john-patricksharpe]

Very useful and clear video ! Thank you :) to conclude, is it possible to say that Region 1 and 2 can be grouped under the letter A and the Region 3 under the letter B ? That way it would be possible to make a graph with the variable region on the x axis, the measurement on the y axis, add the mean value on an histogram shape and finaly add the letter A or B for each variable region ? This is the kind of graph that comes out when making an ANOVA with XLSTAT software.

[elizabethalsheikh]

Hi, thank you for the video, why do you determine the p<0.01 instead of p<0.05, that in the conclusion in the end of the video?