Excel Data Analysis ToolPak - Why You Should Be Using It

In a recent poll on my channel, 86% of Excel users do not use the data Analysis ToolPak! That is shocking to me as the Excel Analysis ToolPak is awesome.
In this short video I will cover my top 3 reasons why ANY professional using Excel to analyze data should be using the Analysis ToolPak:
1 - Descriptive statistics
2 - Correlation analysis
3 - Linear regression
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoff...
★★★ My online data analysis courses ▶ school.daveond...
-----------------------------------------------------------------------------------------------------------------------
Learn how to use the mighty Excel Analysis ToolPak
-----------------------------------------------------------------------------------------------------------------------
Descriptive statistics as part of exploratory data analysis (EDA):
📺 • Exploratory Data Analy...
Introduction to Correlation Analysis in Excel:
📺 • Introduction to Correl...
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn the mighty process behavior chart and analyze the business like a Facebook data scientist using just Excel:
📺 • Introduction to Busine...
🤖 From Excel to Machine Learning. No, Really! 🤖
Yes, you read that correctly. ANY professional can move from Excel pivot tables to analyzing data using machine learning. 💥
📺 • From Excel to Machine ...
Stay healthy and happy data sleuthing!
#ExcelAnalysisToolPak #AnalysisToolPak #ExcelDataAnalysis

[@DaveOnData]

Check out the following video to see the mighty Analysis ToolPak in action: 📺 Descriptive statistics as part of exploratory data analysis (EDA): kzbin.info/www/bejne/Z6uod31-l6xjl6c 📺 Introduction to Correlation Analysis in Excel: kzbin.info/www/bejne/Z5DNlqKnn62noKM

[@Nina8100]

Thank you David for explaining something as dry as Excel Data Analysis in a way that kinda gets me excited about it. I wish all my professors were as passionate as you are. Wish u all the best!

[@user-xq2tj1ru4y]

There's a great new alternative to the Data Analysis Toolpak that gives you custom messages explaining the output as it is created.

[@DaveOnData]

Interesting! What's it called?

[@user-xq2tj1ru4y]

Excel Outlier Analysis Addin

[@user-xq2tj1ru4y]

Did you check out the link I sent you Dave@@DaveOnData

[@minecraftmike5193]

It’s a bummer you stopped making videos, I’ve learned a lot from you!

[@axel_r_]

5:03 "But there's more" And I get so enthusiastic when you say this I almost scream! I am such a nerd... 🤓

[@professorherculesfreitas548]

David, I wish you a million subscribers. Your videos are awesome!

[@DaveOnData]

Thank you so much for the kind words and I hope your wish comes true! 😉

[@AkshayKumar-vd5wn]

Dude thanks for these videos. You are THE MAN. I don't know where the thinking came from that excel is slow. I recently downloaded 10 million sales data and used Data Analysis toolkit on it. I used descriptive, t - test, correlation and regression all of them got done within 3 seconds. So this idea that excel is slow and cannot handle big data is false.

[@bane2256]

I didn't even know this existed. Game changer. thank you

[@sureshsb1985]

Your videos are awesome!! I wonder how come you have so less subscribers and views. I wish your channel grows and reaches a larger audience!

[@DaveOnData]

Glad you are liking the content and for the kind words! I often wonder the same thing. 🤣

[@StopWhining491]

Never used it. Thanks for the vid.

[@ragingkayn3901]

New version of excel completely changed the look and layout of this. Does not look nor operate the same way as shown in this video. I have to use this for a class and I am extremely frustrated lol

[@DaveOnData]

Doh! I am sorry to hear this. Did you get things sorted?

[@michaelward4314]

Great introduction and overview - many thanks

[@staysafe4315]

Thankyou for this great tutorial, David!!

[@ianrjm969]

When I download, there is a big button labeled: Analyze Data. Not Data Analysis as you and many others have mentioned. Once data selected, it automatically analyses everything and there is no option to choose. Did they change it?

[@robertplatt1693]

Yashica-Mat is Always Watching

[@DaveOnData]

Yes, indeed!

[@glasses736]

awesome

[@DaveOnData]

Wow! Thank you for the feedback. It is much appreciated.

[@peternanden5776]

Thank you for a great video

[@haztagstrending]

Hi i want to extract results from multiple sheets to match data's... possible to guide me

[@cathleenbaylon4874]

Hello, I cannot install the Data Analysis toolpak on my MS Excel, although I follow what should I do on installing it, it always end up in error, what do you think should be the problem?

[@waynelast1685]

My Excel looks different. Have Office 365.

[@sunnygawande5283]

Will this work for categorical data ?

[@beatrizgill]

Um, I can't even find it on excel...