Exploratory Data Analysis With Excel - Part 5 - Bar Charts
HTML-код
- Опубликовано: 11 сен 2024
- Learn to create bar charts in Excel for powerful exploratory data analysis (EDA). In this full tutorial series I will introduce you to some of the most useful data analysis techniques in business analytics using trusty old Excel.
Throughout the series I will show you how to use the best that Excel has to offer for EDA:
1 - The mighty Data Analysis ToolPak
2 - Data visualizations like histograms, boxplots, and bar charts.
3 - Pivot tables
4 - Pivot charts
These are the same techniques that I've used in my hands-on analytics work (e.g., as part of my EDA for building machine learning models).
☕ 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...
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
📗 Get the Excel workbooks 📗
All the Excel workbooks used in this series are available here:
github.com/Dav...
📺 Part 1 of the Series - Basic Numerics: • Exploratory Data Analy...
📺 Part 2 of the Series - Basic Categoricals: • Exploratory Data Analy...
📺 Part 3 of the Series - Histograms: • Exploratory Data Analy...
📺 Part 4 of the Series - Box Plots: • Exploratory Data Analy...
📺 Part 6 of the Series - Scatter Plots: • Exploratory Data Analy...
📺 Part 7 of the Series - TreemapCharts: • Exploratory Data Analy...
-----------------------------------------------------------------------------------------------------------------------
❓ Want to up-level your data analysis skills?
-----------------------------------------------------------------------------------------------------------------------
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 • 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. 💥
Check out the following RUclips video to learn more:
• From Excel to Machine ...
Stay healthy and happy data sleuthing!
#ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel #BarCharts #BarChartsInExcel
💥 Learning R programming is easy for Excel users! 💥
📺 ruclips.net/video/MNpsyjSuR20/видео.html
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 ruclips.net/video/xIXymabyFIM/видео.html
In this video, I find the XLS visualization more intuitive and user-friendly than the R visualization at the end. Especially the fact that all the bars are side by side makes the comparison so much easier than having to switch back and forth between three rows and basically always having to reorient yourself.
Very Insightful Exploratory Data Analysis, Thank you very much.
Heyy longg time... I used to see ur R videos... You are a great teacher
.. thanks for sharing the knowledge
thank you for the video. i am more a intuitive person and this video is made for me I think haha. thanks once again
great job so far. Thanks
Thank you, glad you are finding the content useful!
Hey David,
Do you think that Multiple regression will do all of this analysis for you by finding which variables has the highest correlation with the results being survival rates? If yes, then what are the disadvantages that are masked when using multiple regression directly without analyzing the data?
@-Hussainnn - The mighty Analysis ToolPak in Excel allows you to easily create correlation matrices. There are two primary issues with relying on correlation (Pearson's is the default, which I will assume here):
1 - Correlation assumes a linear relationship with the data. However, the calculation can be misleading. Google "Anscombe's Quartet" to learn why you should always visualize your data.
2 - Categorical data can be problematic. Enter visualizing your data.
Hi David. Your tutorials are great, but we just need to hear your voice. You can actually stop showing your face since it's getting in the way.
I actually like to see who's teaching me. There's better connection (for me) and it's therefore more impactful (to me).
@@commonNigerian +1