How to perform ANOVA in MS Excel

Рет қаралды 52,253

Abrar Knowledge

Жыл бұрын

#exceltutorial #exceltips #youtubeviralshorts #anova #exceltricks
How to install Toolpak: • How to Install the Dat...

Пікірлер: 29

@vkvarad9090 Жыл бұрын

1k in just 3 weeks great sir

@AbrarKnowledge Жыл бұрын

Thanks a lot sir

@mohanapriya9409 6 ай бұрын

Thank you so much 😊

@AbrarKnowledge 6 ай бұрын

Welcome..thanks for your comments

@Fry942 10 ай бұрын

thank you sir

@AbrarKnowledge 10 ай бұрын

You are most welcome

@pranayakhadka3507 Жыл бұрын

Thanks

@AbrarKnowledge Жыл бұрын

You are most welcome ☺

@KehindeAyantola-yy4zu 9 ай бұрын

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

@AbrarKnowledge 9 ай бұрын

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

@Azkaban819 9 ай бұрын

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

@AbrarKnowledge 9 ай бұрын

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 9 ай бұрын

Appreciate your comments

@Azkaban819 9 ай бұрын

@@AbrarKnowledge Understood. Thanks for the explanation sir!

@AbrarKnowledge 9 ай бұрын

@sidhanthkumar4882 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

@prachighodeswar9227 5 ай бұрын

Where is the data analysis option coming

@AbrarKnowledge 5 ай бұрын

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 5 ай бұрын

kzfaq.info/get/bejne/jMh8iKSpzae0mKs.html

@AbrarKnowledge 5 ай бұрын

Above link is step by step guide how to enable toolpak