EXAMPLE: Two-Way ANOVA in Excel plus bar graph (2023)

A rough and quick video on how to get Excel to do a two-way ANOVA and Tukey's HSD, plus a column graph with letter labels to distinguish significant means.
The excel file used in the video is here:
docs.google.co...

[@PlantOnConcrete]

You sir just explained to me in HALF AN HOUR what many other failed ! HA! this is BRILLIANT!! Absolutely in love how you explain things and make them EASILY UNDERTSOOD (coming from a student who's watching this at midnight cuz I'm desperately trying to save my skin)

[@solokmalang]

Really nice video and informative. I would like to know about the post hoct test in Two Way Anova. Should we compare the data between two group or within group ?

[@madhavsunar6398]

what if the interaction shows significant? do we do post hoc for different types of treatment used? for this video 2: dry and wet

[@mathslearningUofA]

The Tukey HSD is the post-hoc test either way.

[@madhavsunar6398]

@@mathslearningUofAYour video is Awesome. For my project, I was comparing different milks at different concentrations and in ANOVA I got F>Fcritcal in interaction. Therefore, do I need to do the Tukey HSD as I am rejecting the null hypothesis. I thought it would be a bit tough, so. Thanks

[@mathslearningUofA]

@@madhavsunar6398 You’re always supposed to do a post-hoc test. The only time you don’t need to is if everything is not significant when you do the ANOVA. If anything is significant when you do the ANOVA, you’re supposed to do the post-hoc test. Note I suggest you talk to a professional about this, rather than someone who made a KZbin video!

[@madhavsunar6398]

@@mathslearningUofA I really appreciate for your help. I hope, you gonna keep posting such golden nuggets! Cheers!