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

-----------------------------------------------------------------------------------------------------------------------
Learn how to use the mighty Excel Analysis ToolPak
-----------------------------------------------------------------------------------------------------------------------
Descriptive statistics as part of exploratory data analysis (EDA):

Introduction to Correlation Analysis in Excel:

-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn the mighty process behavior chart and analyze the business like a Facebook data scientist using just Excel:

🤖 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. 💥

Stay healthy and happy data sleuthing!

#ExcelAnalysisToolPak #AnalysisToolPak #ExcelDataAnalysis

[DaveOnData]

Check out the following video to see the mighty Analysis ToolPak in action:

[Nina]

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!

[AkshayKumar-vdwn]

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.

[minecraftmike]

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

[bane]

I didn't even know this existed. Game changer. thank 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... 🤓

[TomWolfer-ow]

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

[professorherculesfreitas]

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

[michaelward]

Great introduction and overview - many thanks

[sureshsb]

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!

[staysafe]

Thankyou for this great tutorial, David!!

[ianrjm]

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?

[ragingkayn]

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

[haztagstrending]

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

[cathleenbaylon]

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?

[waynelast]

My Excel looks different. Have Office 365.

[beatrizgill]

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