KNOW the difference between AVERAGE // MEDIAN // QUARTILES - Easy explanation 👌
AVERAGE is the default option in data analysis. But do you know the problems with it? Here is simple but effective explanation of the problems with AVERAGE and how alternatives like MEDIAN & QUARTILE work.
The story begins with Bill Gates walking into a bar...
⏱ In this video:
=============
0:00 - Bill Gates walks into a bar (the Average problem)
0:59 - AVERAGE Explained
2:12 - Calculating AVERAGE in Excel
2:40 - MEDIAN Explained (AVERAGE vs. MEDIAN)
4:27 - QUARTILES Explained
5:53 - Important Rule when working with data (always see the data)
7:30 - How to apply these ideas in work
More on this topic:
===============
Beginner to PRO Data Analysis with Excel (Video, must watch) - https://youtu.be/v2oNWja7M2E
Essential Excel Functions - https://youtu.be/HgNCvd8IbSc
Averages are Mean (Podcast) - https://chandoo.org/wp/cp010-averages-are-mean-part2/
Data Analysis in Power BI - https://youtu.be/uwe8C7K8fXY
CONNECT WITH ME 🔗
📺 2nd channel (in Telugu) - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw
📷 Instagram (for tips & behind scenes) - https://www.instagram.com/chandoo.xlsx/
🐥 Twitter (fresh updates) - https://twitter.com/r1c1
🌐 Website (1000+ articles, files) - https://chandoo.org/wp/
💡 Classes - https://chandoo.org/wp/excel-school-program/
#average #median
~
Knock knock...
Who is there?
19,043,249,034
Oh, 19,043,249,034 - come in
Sorry, I can't. I am outlier.
Видео KNOW the difference between AVERAGE // MEDIAN // QUARTILES - Easy explanation 👌 канала Chandoo
The story begins with Bill Gates walking into a bar...
⏱ In this video:
=============
0:00 - Bill Gates walks into a bar (the Average problem)
0:59 - AVERAGE Explained
2:12 - Calculating AVERAGE in Excel
2:40 - MEDIAN Explained (AVERAGE vs. MEDIAN)
4:27 - QUARTILES Explained
5:53 - Important Rule when working with data (always see the data)
7:30 - How to apply these ideas in work
===============
Beginner to PRO Data Analysis with Excel (Video, must watch) - https://youtu.be/v2oNWja7M2E
Essential Excel Functions - https://youtu.be/HgNCvd8IbSc
Averages are Mean (Podcast) - https://chandoo.org/wp/cp010-averages-are-mean-part2/
Data Analysis in Power BI - https://youtu.be/uwe8C7K8fXY
CONNECT WITH ME 🔗
📺 2nd channel (in Telugu) - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw
📷 Instagram (for tips & behind scenes) - https://www.instagram.com/chandoo.xlsx/
🐥 Twitter (fresh updates) - https://twitter.com/r1c1
🌐 Website (1000+ articles, files) - https://chandoo.org/wp/
💡 Classes - https://chandoo.org/wp/excel-school-program/
#average #median
~
Knock knock...
Who is there?
19,043,249,034
Oh, 19,043,249,034 - come in
Sorry, I can't. I am outlier.
Видео KNOW the difference between AVERAGE // MEDIAN // QUARTILES - Easy explanation 👌 канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Excel formula references - A1 vs. $A$1 vs $A1 vs A$1 explainedAwesome Power Query example - Calendar data to table format 📅➡📄Employee Shift Tracker Excel Template - How it worksConvert number to words with this Excel formula + LET Function DemoMay the Power BI with you - Demo of Star Wars Infographic🧇 Yummy WAFFLE Chart in Power BI - How to make one?How to do weighted sorting in Excel?Celebrate Halloween with Creepy Spider Web Chart in ExcelHow to create a fully *INTERACTIVE* and AWESOME Dashboard in Excel (PART 2)How to split text values in Excel with formulas - Quick Solution ⏳Combine Excel Sheets with *this* simple formulaDAX Concepts: How to Create Best in Category Calculations with EaseWhere to get FREE Datasets to practice Data AnalyticsAverage calculation in Excel, but with a twist 🥨Try this yummy Lollipop Chart 🍭 (Excel trick)Easiest Lookup formulas for any situation - an interview with Oz Du Soliel (Excel on Fire)Can you split The Hangover expenses using Excel?How to connect to Amazon AWS S3 Buckets from Power BI - Step by Step Tutorial (with code samples)6 Massively time saving Pivot Table tricks (Don't miss #4 & #6) ⏰Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...