How to perform ANOVA in MS Excel

Рет қаралды 54,057

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

thank you sir

@AbrarKnowledge 11 ай бұрын

You are most welcome

@pranayakhadka3507 Жыл бұрын

Thanks

@AbrarKnowledge Жыл бұрын

You are most welcome ☺

@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

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

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

@AbrarKnowledge 10 ай бұрын

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 Жыл бұрын

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

Where is the data analysis option coming

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

kzfaq.info/get/bejne/jMh8iKSpzae0mKs.html

@AbrarKnowledge 6 ай бұрын

Above link is step by step guide how to enable toolpak