Excel Techniques - 11 - ANOVA - Two Factor without Replication.avi

Поділитися
Вставка
  • Опубліковано 28 сер 2024
  • Excel Techniques for Statistics DGGB 6820 - Summer 2010
    ANOVA - Two (or more) Factor without replication
    (Please be aware that the audio is a little out of sync)
    Download the Excel Workbook at:
    docs.google.co...
    Download the Stats Notes at:
    docs.google.co...

КОМЕНТАРІ • 25

  • @billygraham5589
    @billygraham5589 Рік тому +1

    So what are we testing for? What is the null and what is the alternative? Does it make a difference that Rows were no a significant p value, but the Columns did have a significant p value? How does that work with the null and alternative hypothesis, whatever they are?

  • @sgoldan
    @sgoldan 14 років тому +1

    Excellent explanation. The example, and your conclusion at the end really helped me understand.
    Thanks a lot!

  • @phudo6760
    @phudo6760 9 років тому

    Thank you for your documents and videos. They're very cool. Thanks again.

  • @hieuphungminh6690
    @hieuphungminh6690 4 роки тому

    Lol that tiny roast in the conclusion

  • @mohammedhishamshaikh
    @mohammedhishamshaikh 8 років тому

    Thanks a lot! It helped me a lot!

  • @toasty3984
    @toasty3984 9 місяців тому

    You saved my life 😂

  • @cojocariulaurian
    @cojocariulaurian 11 років тому

    It is a verry good video. Thank you. I kile the last explenation. They are better suited for Life Guards rather than Marines :))

  • @Dasaniyin
    @Dasaniyin 8 років тому

    Good explanation! I really appreciate the help!

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

    What if those recruits were tested again in all 3 tests to see if they have improved (say for example after 2 weeks), giving you 3 pairs of before-and-after scores? What test should you use if they improved in any of those performances?

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

      it's called a repeated measures anova (2 x 3) for before and after (2) and 3 tests per individual.

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

    Can we do a tukey test to compare between the subjects to see who is the best among them ?

  • @CherryCakeLane
    @CherryCakeLane 4 роки тому

    I did everything you said but it comes up with an error message "this input contains non numeric data". I did click labels, I did highlight as you did, not sure why it won't do it for me. Help?

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

      When you select blank cells (samples with different number of data points), the non-numeric data error pops up.

  • @shaimabaitmaqbool772
    @shaimabaitmaqbool772 4 роки тому

    Thank you so much

  • @disturbingbird
    @disturbingbird 12 років тому

    Thank you, much appreciated!

  • @phudo6760
    @phudo6760 9 років тому

    Hi guys, I hope you can help me solve this problem.
    I want to verify the independence of two factor without replication, can i use '' ANOVA - Two Factor without replication'' ? and how?
    In this example, I can verify the independence of factor " Recruit " and "Score", its relationship to the result.
    Thanks a lot!

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

    Hi what is error how is it computed ? Can we use tukey test for columns.?

  • @n19934
    @n19934 8 років тому

    hey how do you find SSE what is the formula?

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

    The design of this data file suggests this is a ONE-WAY ANOVA with 3 levels (tests 1-3). If each person takes each test, then test is a repeated ('replicated') factor. Differences between tests should not be tested as if it is a 'non-replicated' factor because it is theoretically not true and you lose power to detect differences when you treat them as if different groups of people were taking each test.
    Testing for differences between individuals is NOT sound practice, as each persone would have to be treated as a factor, or perhaps a factor of 'person' with six levels. This whole example is very botched in my opinion.

    • @Motorhomemarx
      @Motorhomemarx 5 років тому

      Truth. It's a poor demo that he should revise.

  • @drTWO7
    @drTWO7 12 років тому

    thank you so much!

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

    Thanks!

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

    Your analysis is inappropriate for the data. This test assumes that all the values are equally independent of one another, but in fact you have scores for SQ, RQ and TQ that all come from the same individual and are related to one another. This is a repeated measure of a subject. You can see this is true by scrambling the order of, say, the TQ values--you will get the same statistical result from the two-way ANOVA, whereas if the test were appropriate for a repeated measure on a subject you would get a different statistical result. This error is on many videos on youtube. I see now that weakside made the same comment below.

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

      Except that weakside advocated for one-way ANOVA, which is also inappropriate for the same reasons.

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

    statistisignifcaldiffernce