How to perform ANOVA in MS Excel

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • #exceltutorial #exceltips #youtubeviralshorts #anova #exceltricks
    How to install Toolpak: • How to Install the Dat...

Комментарии • 31

  • @vkvarad9090
    @vkvarad9090 Год назад +9

    1k in just 3 weeks great sir

  • @mohanapriya9409
    @mohanapriya9409 7 месяцев назад +3

    Thank you so much 😊

  • @thallkhan2146
    @thallkhan2146 4 дня назад +1

    If ANOVA result is insignificant, mean that their is no significant difference between the groups.
    Can we say that ANOVA assumption are not fill fulled therefore their result is insignificant?

  • @Fry942
    @Fry942 11 месяцев назад +3

    thank you sir

  • @Azkaban819
    @Azkaban819 10 месяцев назад +5

    Could have used independent t-test too here since there are only 2 samples?

    • @AbrarKnowledge
      @AbrarKnowledge  10 месяцев назад +1

      Good perspective..Anova is better perspective due to interaction it gives..as you know p value remain same whether we choose to do t or anova

    • @AbrarKnowledge
      @AbrarKnowledge  10 месяцев назад

      Appreciate your comments

    • @Azkaban819
      @Azkaban819 10 месяцев назад

      @@AbrarKnowledge Understood. Thanks for the explanation sir!

    • @AbrarKnowledge
      @AbrarKnowledge  10 месяцев назад

      @sidhanthkumar4882 you are most welcome

  • @pranayakhadka3507
    @pranayakhadka3507 Год назад +1

    Thanks

  • @KehindeAyantola-yy4zu
    @KehindeAyantola-yy4zu 10 месяцев назад +3

    After locating Data, I can't locate data analysis on my Excel please can you help me out

    • @AbrarKnowledge
      @AbrarKnowledge  10 месяцев назад +1

      Thanks for the questions
      One of two ways you can find
      1.After Installing ToolPak check under data menu whether Toolpak is enabled
      2.If you have already had a ToolPak then after analysis, result default shows in next tab of excel- please check
      Further need any assistance.. you can email me at AbrarKnowledge@gmail.com

  • @flyingmoon1464
    @flyingmoon1464 Год назад +2

    What's use from this sir, please tel Where can we use this sir...🤔🤔🤔🤔

    • @AbrarKnowledge
      @AbrarKnowledge  Год назад +1

      Good question! This is part of statistics and ANOVA analysis of Variances helps to test the experiment as Hypothesis and we can draw conclusions with 95% or 99% confidence...ANOVA and all Hypothesis tests are powerful and we can state the results with significant

  • @prachighodeswar9227
    @prachighodeswar9227 6 месяцев назад +1

    Where is the data analysis option coming

    • @AbrarKnowledge
      @AbrarKnowledge  6 месяцев назад

      Thanks for the question.
      You have to add ToolPak which comes along with Every excel and just needs to add-ins..let me share that link as well.
      Once done, under data ribbon you will find it

    • @AbrarKnowledge
      @AbrarKnowledge  6 месяцев назад

      ruclips.net/video/VbLUAxhAPhw/видео.html

    • @AbrarKnowledge
      @AbrarKnowledge  6 месяцев назад

      Above link is step by step guide how to enable toolpak

  • @areeshaamira8295
    @areeshaamira8295 9 месяцев назад +1

    When i go to data on my excel it does not show the option of data analysis

    • @AbrarKnowledge
      @AbrarKnowledge  9 месяцев назад

      Thanks for the comments..Have you installed ToolPak Analysis

    • @AbrarKnowledge
      @AbrarKnowledge  9 месяцев назад

      There is also a video how to install.. it is just free add in and you need to install within excel

  • @rahulsachdeva2728
    @rahulsachdeva2728 Год назад

    Hlo

  • @9962683887
    @9962683887 8 месяцев назад +1

    This video deserves 1M..Im sure you will

    • @AbrarKnowledge
      @AbrarKnowledge  8 месяцев назад

      Thank you so much..Insha Allah one day it will reach

    • @AbrarKnowledge
      @AbrarKnowledge  8 месяцев назад

      Thanks for you encouragement