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
Пікірлер: 30
Check out the following video to see the mighty Analysis ToolPak in action: 📺 Descriptive statistics as part of exploratory data analysis (EDA): kzread.info/dash/bejne/Y655qKyBkqqWkag.html 📺 Introduction to Correlation Analysis in Excel: kzread.info/dash/bejne/Y5Oex9GqmqvamqQ.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!
It’s a bummer you stopped making videos, I’ve learned a lot from you!
Great introduction and overview - many thanks
Thankyou for this great tutorial, David!!
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.
There's a great new alternative to the Data Analysis Toolpak that gives you custom messages explaining the output as it is created.
@DaveOnData
5 ай бұрын
Interesting! What's it called?
@user-xq2tj1ru4y
5 ай бұрын
Excel Outlier Analysis Addin
@user-xq2tj1ru4y
5 ай бұрын
Did you check out the link I sent you Dave@@DaveOnData
I didn't even know this existed. Game changer. thank you
David, I wish you a million subscribers. Your videos are awesome!
@DaveOnData
2 жыл бұрын
Thank you so much for the kind words and I hope your wish comes true! 😉
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
2 жыл бұрын
Glad you are liking the content and for the kind words! I often wonder the same thing. 🤣
5:03 "But there's more" And I get so enthusiastic when you say this I almost scream! I am such a nerd... 🤓
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?
Never used it. Thanks for the vid.
Thank you for a great video
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?
Hi i want to extract results from multiple sheets to match data's... possible to guide me
Will this work for categorical data ?
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
4 күн бұрын
Doh! I am sorry to hear this. Did you get things sorted?
Yashica-Mat is Always Watching
@DaveOnData
5 ай бұрын
Yes, indeed!
awesome
@DaveOnData
3 ай бұрын
Wow! Thank you for the feedback. It is much appreciated.
Um, I can't even find it on excel...
My Excel looks different. Have Office 365.