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

Поділитися
Вставка
  • Опубліковано 23 тра 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.com/spreadsheets/...

КОМЕНТАРІ • 7

  • @PlantOnConcrete
    @PlantOnConcrete 2 місяці тому +1

    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
    @solokmalang 9 місяців тому

    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
    @madhavsunar6398 2 місяці тому

    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
      @mathslearningUofA  2 місяці тому +1

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

    • @madhavsunar6398
      @madhavsunar6398 2 місяці тому

      @@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
      @mathslearningUofA  2 місяці тому +1

      @@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 UA-cam video!

    • @madhavsunar6398
      @madhavsunar6398 2 місяці тому

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