How to perform ANOVA in MS Excel

#exceltutorial #exceltips #youtubeviralshorts #anova #exceltricks
How to install Toolpak: • Master Microsoft Excel...

[@naveedahmed4407]

Informative video

[@AbrarKnowledge]

Glad you like ...appreciate 👍

[@mohanapriya9409]

Thank you so much 😊

[@AbrarKnowledge]

Welcome..thanks for your comments

[@9962683887]

This video deserves 1M..Im sure you will

[@AbrarKnowledge]

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

[@AbrarKnowledge]

Thanks for you encouragement

[@thallkhan2146]

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?

[@AbrarKnowledge]

100% you hit the nail on the head!!

[@vkvarad9090]

1k in just 3 weeks great sir

[@AbrarKnowledge]

Thanks a lot sir

[@Adeymolahubs]

How do you know that option B is better?

[@AbrarKnowledge]

Good question..p value less than 0.05 alpha

[@Fry942]

thank you sir

[@AbrarKnowledge]

You are most welcome

[@flyingmoon1464]

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

[@AbrarKnowledge]

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

[@Azkaban819]

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

[@AbrarKnowledge]

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]

Appreciate your comments

[@Azkaban819]

@@AbrarKnowledge Understood. Thanks for the explanation sir!

[@AbrarKnowledge]

@sidhanthkumar4882 you are most welcome

[@KehindeAyantola-yy4zu]

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

[@AbrarKnowledge]

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 [e-mail]

[@prachighodeswar9227]

Where is the data analysis option coming

[@AbrarKnowledge]

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]

th-cam.com/video/VbLUAxhAPhw/w-d-xo.html

[@AbrarKnowledge]

Above link is step by step guide how to enable toolpak

[@pranayakhadka3507]

Thanks

[@AbrarKnowledge]

You are most welcome ☺

[@areeshaamira8295]

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

[@AbrarKnowledge]

Thanks for the comments..Have you installed ToolPak Analysis

[@AbrarKnowledge]

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

[@rahulsachdeva2728]

Hlo

[@AbrarKnowledge]

Yes please