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!
The Data Analysis Toolpak in Excel requires you to click a button every time you want to perform a task..descriptive statistics...histogram..box plot...t-test...on data. I have developed an alternative to the Data Analysis Toolpak that requires you to only select your data once and then automatically do all these other things.
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.
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?
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
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?
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!
The Data Analysis Toolpak in Excel requires you to click a button every time you want to perform a task..descriptive statistics...histogram..box plot...t-test...on data. I have developed an alternative to the Data Analysis Toolpak that requires you to only select your data once and then automatically do all these other things.
It’s a bummer you stopped making videos, I’ve learned a lot from you!
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
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! 😉
5:03 "But there's more"
And I get so enthusiastic when you say this I almost scream!
I am such a nerd... 🤓
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
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?
Great introduction and overview - many thanks
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.
Thankyou for this great tutorial, David!!
Hi i want to extract results from multiple sheets to match data's... possible to guide me
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?
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?
Thank you for a great video
Will this work for categorical data ?
I have developed an Excellent Excel data analysis tool for categorical data if you have an interest.
Um, I can't even find it on excel...
Yashica-Mat is Always Watching
Yes, indeed!
My Excel looks different. Have Office 365.
awesome
Wow! Thank you for the feedback. It is much appreciated.