Excel Data Analysis ToolPak - Why You Should Be Using It
ฝัง
- เผยแพร่เมื่อ 8 ก.ย. 2024
- 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
Check out the following video to see the mighty Analysis ToolPak in action:
📺 Descriptive statistics as part of exploratory data analysis (EDA):
th-cam.com/video/1zEFJHbG0aE/w-d-xo.html
📺 Introduction to Correlation Analysis in Excel: th-cam.com/video/1_jeoqjHtjA/w-d-xo.html
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!
There's a great new alternative to the Data Analysis Toolpak that gives you custom messages explaining the output as it is created.
Interesting! What's it called?
Excel Outlier Analysis Addin
Did you check out the link I sent you Dave@@DaveOnData
It’s a bummer you stopped making videos, I’ve learned a lot from you!
David, I wish you a million subscribers. Your videos are awesome!
Thank you so much for the kind words and I hope your wish comes true! 😉
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.
I didn't even know this existed. Game changer. thank you
5:03 "But there's more"
And I get so enthusiastic when you say this I almost scream!
I am such a nerd... 🤓
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!
Glad you are liking the content and for the kind words! I often wonder the same thing. 🤣
Never used it. Thanks for the vid.
Great introduction and overview - many thanks
Thankyou for this great tutorial, David!!
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
Doh! I am sorry to hear this. Did you get things sorted?
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?
Thank you for a great video
awesome
Wow! Thank you for the feedback. It is much appreciated.
Yashica-Mat is Always Watching
Yes, indeed!
Hi i want to extract results from multiple sheets to match data's... possible to guide me
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?
Will this work for categorical data ?
My Excel looks different. Have Office 365.
Um, I can't even find it on excel...