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.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
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):
ruclips.net/video/1zEFJHbG0aE/видео.html
📺 Introduction to Correlation Analysis in Excel: ruclips.net/video/1_jeoqjHtjA/видео.html

[@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!

[@minecraftmike5193]

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

[@staysafe4315]

Thankyou for this great tutorial, David!!

[@bane2256]

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

[@michaelward4314]

Great introduction and overview - many thanks

[@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.

[@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... 🤓

[@peternanden5776]

Thank you for a great video

[@StopWhining491]

Never used it. Thanks for the vid.

[@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! 😉

[@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. 🤣

[@robertplatt1693]

Yashica-Mat is Always Watching

[@DaveOnData]

Yes, indeed!

[@haztagsmedia]

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

[@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?

[@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?

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

[@sunnygawande5283]

Will this work for categorical data ?

[@glasses736]

awesome

[@DaveOnData]

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

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

[@waynelast1685]

My Excel looks different. Have Office 365.

[@beatrizgill]

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