Exploratory Data Analysis With Excel - Part 2 - Basic Categoricals

[@DaveOnData]

💥 Learning R programming is easy for Excel users! 💥 📺kzbin.info/www/bejne/g3_TpKygiNqFaJI 👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68

[@ragilrakasiwa]

can the file you put in your github i make my personal portfolio, with some modifications? or do you want to give me another set of case study files, related to this session. Thank you so muchhh

[@DaveOnData]

@@ragilrakasiwa - Yes, feel free to use the files as you see fit! Just know that I have no legal responsibility for how you use the files. 😁

[@msnjulabs]

This channel is a gold mine for data mining beginners and students

[@calvinchung3419]

Thank you for teaching. You make it very easy to understand. It just requires practice ans repetition.

[@jaychopra8932]

15:13 gesture for age column ####

[@arkapravobandyopadhyay9851]

David your patient explanations are a boon. Thanks for introducing this to us :)

[@DaveOnData]

Thank you so much for the feedback! Very much appreciate and glad you like the content.

[@Knowledge_Nuggies]

@09:15 #outofcontext

[@nexomatematico7272]

Excellent video, thank you

[@DaveOnData]

You are welcome! I'm happy to hear that you are finding my content useful.

[@michellejohnson6759]

the mighty Pivot Table!

[@DaveOnData]

Indeed, pivot tables are awesome! Keep watching the series for even more awesomeness. 😁

[@cos-ibeuchechukwu9398]

thank you for this. it was very insightfull

[@DaveOnData]

Glad you found the content useful!

[@ishankgupta9575]

Can you please tell me why we have taken table13 in pivot table as range ?

[@iampozyman]

thank you very much!

[@DaveOnData]

You are welcome, glad you liked the video!

[@rafis213]

I loved it, very useful!

[@ameysonawane]

Thank You!! I actually wanted to see Null value handling one hot encoder Handling outliers handling skewness Normalization all this ML things with excel .. have you covered in any other videos?

[@DaveOnData]

You are welcome! That's quite a list of topics you have there, many are worthy of dedicated tutorials of their own. 😁 The short answer is no, based on my understanding, I don't have videos on those topics. That being said... My live courses on linear and logistic regression with Excel cover dummy encoding of categoricals. Regarding outliers, skewness, and normalization, these can be problematic in the world of business analytics. For example: 👉 Outliers in business data are often not the result of data collection errors and removing/transforming them can distort the business insight. 👉 Performing a log transform of an independent variable in a linear regression model is super difficult to explain to business decision-makers. As such, I tend to prefer non-parametric techniques (e.g., decision trees, random forests, xgboost, etc.) in situations where the data doesn't meet OLS and/or logistic regression assumptions. Decision tree-based techniques handle missing values automagically.

[@ameysonawane]

@@DaveOnData Wow such a broad answer david sir Thanks! Now I understood that this channel is more for business analytics. I will cover this series in few days.😁✌️👍

[@shahramsohail9459]

I have excel 2016 I made the new columns of survied and classes then I made the pivot table but the values were not right for the table...they were not matching with your values Then I replicated the columns and just used find and replace to make new columns...now my pivot table matches yours. Excel 16 does not have the IFS function so I used nested IF...is this the reason for wrong values?

[@aq7705]

You are the Bernhard Langer of Excel :=)

[@DaveOnData]

Had to look up the other Mr. Langer you mentioned. I'll take this as quite the compliment! 😁

[@niko73le]

I think it's amazing that you would have had a better chance of surviving as a female in third class than a male in first class! Hats off for gallantry.

[@sanadmasoud5818]

At university They Gave us A breif introdunction about EDA

[@DaveOnData]

Ah, then a lot of the content in the series might be review for you.

[@tutsecret499]

When you say there are many survived female on class A, maybe because there were more women than men aboard? thus not necessarily "the children and women come first" cause of survival.