Join my Academy, learn Data & AI skills and land a job👇
https://go.analyticsautomation.academ...
Statistics is supposedly essential for data roles, but oddly enough, many data analysts learn it on the job rather than before.
In this video, I clarify the importance of statistics for data analyst and scientist roles, explain key concepts like central tendency, variance, and standard deviation, and demonstrate practical applications in Excel to ease your learning pain.
💬 CONNECT WITH ME
Connect on Linkedin 👉 / lorenzo--rosa
DM me on Instagram 👉 / loresowhat
📩 Get in touch:
[email protected]
🔎 CONTENT
0:00 Introduction to Statistics in Data Roles
2:15 Using Excel to Apply Statistical Concepts
3:23 Central Tendency: Mean, Median, and Mode
5:45 Choosing the Right Measure of Central Tendency
6:36 Understanding Data Distribution and Skewness
8:45 Practical Calculations of Mean, Median, and Mode in Excel
10:40 Range as a Measure of Variability
12:59 Variance: Measuring Data Spread
15:55 Standard Deviation Explained
18:15 Sample vs Population in Statistical Calculations
19:10 Conclusion and Further Learning Resources
#StatisticsForDataAnalytics #DataAnalysisBasics #ExcelForDataScience