Two-Way ANOVA with Replication using Excel 2016 Data Analysis Tools

Поділитися
Вставка
  • Опубліковано 13 жов 2024
  • This video demonstrates how to conduct a two-way ANOVA (ANOVA: Two-Factor with Replication) using Excel 2016 Data Analysis Tools. The assumptions for two-way ANOVA are tested using histogram and boxplot graphs.

КОМЕНТАРІ • 29

  • @kemon3733
    @kemon3733 6 місяців тому +1

    Taking a break from Dr.Todd's analysis of crimes to Dr.Todd's analysis of variance is a breath of statistically significant fresh air.

  • @amandavalentino8182
    @amandavalentino8182 5 років тому +1

    Dr. Grande- Your explanation in using excel for ANVOA was very helpful. This video is a great resource on when to understand the factors that are combined, and how to understand the normality with different groups. Thank you for making this clear and easy to understand.

  • @cassiemclaughlin9489
    @cassiemclaughlin9489 8 років тому +1

    I found out late in my collegiate career that I enjoyed statistics and research. Therefore, this was exciting for me to watch. I am interested in the more complex statistical tests that I have not had much exposure to. This has a lot of factors combined, but was very clearly explained. Thank you!

  • @roymilner3890
    @roymilner3890 7 років тому +1

    You do a great job. Best I have seen online. Many instructors talk too fast. I like your pace and thorough teaching methods. I am going to suggest Northeastern University IT class use you as a tutorial tool. Thanks!

    • @DrGrande
      @DrGrande  7 років тому +1

      Thank you for your kind words and thanks for watching.

  • @zainabmohammed1141
    @zainabmohammed1141 7 років тому +1

    OMG! you are the BEST!!!!!!!!!!! It's Sunday and i've been working on my project since Friday. I just needed to answer 1 more question for this first part of what my Prof assigned and you helped me soooooooooooooo much! THANK YOU!

    • @DrGrande
      @DrGrande  7 років тому +1

      You're welcome, thanks for watching -

  • @alexrausch3750
    @alexrausch3750 6 років тому

    Great explanation, this 12 minute long video tied together over a days worth of fragmented knowledge gained from various web pages. Thanks

  • @katrinahetherington3425
    @katrinahetherington3425 Рік тому

    This was very helpful. Thank you.

  • @peeterpolomaa6180
    @peeterpolomaa6180 7 років тому +3

    Thanks a lot, best explanation from half a dozen videos I've watched here :)

    • @DrGrande
      @DrGrande  7 років тому +2

      I'm glad you found the video useful - thanks for watching -

  • @robertpodolsky6252
    @robertpodolsky6252 5 років тому +9

    Can Excel be used if sample sizes among the six groups are unequal?

  • @gustavorios3714
    @gustavorios3714 2 роки тому

    Great video, thanks!

  • @treeplanters9009
    @treeplanters9009 3 роки тому

    Wow great,, worth watching while learning.

  • @ligiapatriciacalderondelga9824
    @ligiapatriciacalderondelga9824 3 роки тому

    Hello Dr. Todd, I have been trying to learn how to preform an ANOVA analisis and your videos are great, however on my data set, every time I try to follow your instructions there is a mesagge saying "input range contain non numerical data". I dont know what to do, acording to the example from the video, actually the first column is a non numerical data so I am not sure how to fix my tables.
    I have another question, it is posible to analize more than one treatment and more than one sample with the ANOVA - two ways with replicates?

  • @kiranbabutiwari1370
    @kiranbabutiwari1370 7 років тому

    Very nice presentation. I am a layman in statistics, yet, understand the things you explained. Thanks.

    • @DrGrande
      @DrGrande  7 років тому

      You're welcome, thanks for watching -

  • @Banxshots
    @Banxshots Рік тому

    What post op test did you perform to see what the difference in score are for the columns

  • @professorbabaji9540
    @professorbabaji9540 6 років тому

    Really, deeply appreciate your help kind sir. Thank you!

  • @lysfalomir
    @lysfalomir 7 років тому

    Very nice video. Thanks a lot for posting it. Do you have anotherone explaining how the ANNOVA is performed when the variables are not independent? For example when you want to evaluate differences between two samples where results for different components are expressed as a porcentual distribution? Thank you very much in advance!

  • @terranceaye1629
    @terranceaye1629 3 роки тому +1

    If I have different number of samples for each categories, how should I do ANOVA ?

  • @regankarki8599
    @regankarki8599 7 років тому

    Hi, Thank you for your tutorial ...I was wondering if we need to do the post hoc test for the result when we get the significant result in two way anova with replication...and how? Can you give some guidances using LSD or Tukey test for this..Thanks

  • @yjathan
    @yjathan 4 роки тому +1

    Thank you so much!

  • @bahadirezici
    @bahadirezici 6 років тому

    I confused the part interpreting the P-value because of setting up the H0. Below information help you understand better if you have the same problem.
    Ho(Null hypothesis) for ANOVA testing is always = No differences between means and the alternative hypothesis is there is at least one differences between the means. So;
    Ho= U1=U2=U3
    H1= Means are not equal
    Hope this helps.

  • @alltimeaviation6812
    @alltimeaviation6812 2 роки тому

    Are two-way ANOVA with replication and two-way repeated measures ANOVA two names for the same thing?

  • @xuming.samyin8461
    @xuming.samyin8461 7 років тому

    Hi, thanks for your tutorial. It is really good. I am wondering if we could do ANOVA with different sample size of each group. Let's say there are 15 samples both in your "Substance Use" group and "Depression" group, but there are 12 samples in "Trauma" group. Could we still do the two-way ANOVA with excel? Thanks!

    • @terranceaye1629
      @terranceaye1629 3 роки тому +1

      Thanks I have the same problem. Have u got any answer by now?

  • @BogdanAnastasiei
    @BogdanAnastasiei 2 роки тому

    So that would be a kind of mixed ANOVA, with both between-groups and within-groups factors. Am I wrong?

  • @oguzyavuz2010
    @oguzyavuz2010 3 роки тому

    what if we do not have same row samples?