One-Way ANOVA (ANOVA: Single Factor) using Excel 2016 Data Analysis Tools

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ธ.ค. 2024

ความคิดเห็น • 24

  • @texas55snear
    @texas55snear 8 ปีที่แล้ว +22

    This video alone has saved my entire degree.

  • @sophie3howl
    @sophie3howl 4 ปีที่แล้ว +2

    Just letting you know, you're a hero! You just saved my life, Sir!

  • @ashleymogle2700
    @ashleymogle2700 5 ปีที่แล้ว +1

    I had no idea that you were able to conduct ANOVAs in excel, I thought you had to have a special type of software downloaded like SPSS. Thank you for the useful tutorial.

  • @제주감귤-u7h
    @제주감귤-u7h 6 ปีที่แล้ว +2

    Wow this video really helped me a lot.
    But I just have a one problem. What do you mean by reject the null hypothesis? Does that mean that I can accept my hypothesis?

  • @rosasutton8472
    @rosasutton8472 8 ปีที่แล้ว +1

    Interesting seeing the differences between SPSS and Excel. Easier to conduct an ANOVA in Excel, but more in depth in SPSS. Pros and cons.

    • @taxonomistplant7802
      @taxonomistplant7802 5 ปีที่แล้ว

      Hello Dear, Grande Todd
      I hope you are fine and I have some questions and need your help.
      Actually, I was going through the videos on you tube about Anova by you.
      I explain my experimental design.
      Actually I inoculated 3 microorganisms (ASS-ASL and ASY using different concentrations i.e. 50-75 and 100ul/L). I wanted to check if these organisms at different concentrations affect the growth of wheat seedlings. I had 4 replicates for each treatment and 4 CK control for each treatment (No inoculation of microgranisms). As I am not clear, I can send you my raw data. I checked if different dosages of microbes promote or demote the biomass of seedlings including (SHOOT LENGTH , ROOT LENGTH, FRESH WEIGHT, DRY WEIGHT SHOOT FRESH ROOT WEIGHT, ROOT DRY WEIGHT).
      According to my understanding I want to do ANOVA and plot pretty graphs (2-3).
      Could you please help me in this matter? How to contact you. Could you please send your email, so that I can send you my data.
      Thanks
      Eagerly waiting for your response!!
      Best wishes,
      Abdul

  • @survivor90
    @survivor90 6 ปีที่แล้ว

    in which scenario should i perform 1) anova singe factor 2) two factor with replica 3) two factor without replica

  • @eliasbensalem5069
    @eliasbensalem5069 8 ปีที่แล้ว

    What if the assumption of homogeneity (Levene's test) was violated for a pretest? What alternative method can I use to compare a pretest mean score and postest mean score?

  • @XiulanArisu
    @XiulanArisu 7 ปีที่แล้ว +1

    Very helpful, thank you.

    • @DrGrande
      @DrGrande  7 ปีที่แล้ว

      You're welcome, thanks for watching -

  • @162iceguy
    @162iceguy 5 ปีที่แล้ว +3

    Ughh i keep getting “non-numeric data”, what am I doing wrong

    • @precise_pace
      @precise_pace 5 ปีที่แล้ว

      Do not select the first row of the categories excel will create default one's. You'll have to modify the column name yourself.

  • @Wonderer473
    @Wonderer473 4 ปีที่แล้ว

    Does not work for me (Excel pro 2016). The pvalue I get is always "#DIV/0!
    ", what can I do?

  • @venicarios3422
    @venicarios3422 6 ปีที่แล้ว

    Good evening Dr. Grande. May i ask if how did you edit your video and what app did you used? How to take a video with the whole sheet? I'm a grade 9 student from the Philippines and it would be our project in research.Thank you very much!

  • @davidforster258
    @davidforster258 7 ปีที่แล้ว

    Brilliant - thank you

    • @DrGrande
      @DrGrande  7 ปีที่แล้ว

      You're welcome, thanks for watching -

  • @chrisadams9918
    @chrisadams9918 7 ปีที่แล้ว

    thank you

    • @DrGrande
      @DrGrande  7 ปีที่แล้ว

      You're welcome, thanks for watching -

  • @rajmeet6777
    @rajmeet6777 4 ปีที่แล้ว

    Nothing see ur vdo sir