Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Business Math & Statistics Using Excel For Data Analysts and Data Scientists
Play lesson

Data Science Full Course For Beginners | Python Data Science Tutorial | Data Science With Python - Business Math & Statistics Using Excel For Data Analysts and Data Scientists

Master Data Science: Your Comprehensive Guide to Python, SQL, Machine Learning & Deep Learning! Explore step-by-step tutorials and projects, from coding fundamentals to advanced algorithms, with codebasics. Unlock your data-driven career today!

4.0 (1)
20 learners

What you'll learn

Understand the fundamentals of data science and its applications
Acquire skills in Python programming and data analysis using libraries like Pandas and NumPy
Develop machine learning models and understand key algorithms such as Linear Regression, Decision Trees, and Neural Networks
Use deep learning frameworks like TensorFlow and Keras to build and deploy neural network models

This course includes

  • 33.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Learn this 20 % business math and statistics to manage 80 % of your tasks as data professionals. ๐Ÿ“ˆ Discover the importance of business math and statistics, along with essential Excel skills. ๐Ÿ“Š Excel basics: cells, sheets, workbooks, and essential formulas like SUM, SUMIF, and AVERAGE. Unlock powerful features such as conditional formatting and Excel tables. ๐Ÿ’ฐ Using the movies dataset explore the practical use cases of the above formulas. ๐Ÿ“Š Demystify Marvel Studios' profit and loss statement, Gain insights into revenue, budget, profit/loss, profit/loss percentage, and market share. Compare targets with actual results. ๐Ÿ“ˆ Understand mean, median, and mode, and their practical applications in data-informed decisions. ๐Ÿ“‰ Dive deep into variance and standard deviation. Learn how these measures quantify data spread and calculate them using Excel for accurate analysis. ๐Ÿ”— Discover the power of correlation. Measure relationships between variables using simple examples and Excel formulas for various scenarios. This content is from my Excel course: https://codebasics.io/courses/excel-mother-of-business-intelligence File link: https://codebasics.io/resources/business-math-statistics-using-excel โญ๏ธ Timestamps โญ๏ธ 00:00 Introduction 04:59 Excel Basics 21:05 Total, Average, % Revenue 34:48 Basics of Profit & Loss (P&L) Statement 55:01 Mean, Median, Mode 1:02:19 Variance and Standard Deviation 1:16:42 Correlation Do you want to learn technology from me? Check https://codebasics.io/?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description for my affordable video courses. Need help building software or data analytics/AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website. ๐ŸŽฅ Codebasics Hindi channel: https://www.youtube.com/channel/UCTmFBhuhMibVoSfYom1uXEg #๏ธโƒฃ Social Media #๏ธโƒฃ ๐Ÿ”— Discord: https://discord.gg/r42Kbuk ๐Ÿ“ธ Codebasics Instagram: https://www.instagram.com/codebasicshub/ ๐Ÿ”Š Codebasics Facebook: https://www.facebook.com/codebasicshub ๐Ÿ“ Codebasics LinkedIn: https://www.linkedin.com/company/codebasics/ ๐Ÿ“ฑ Codebasics X handle: https://twitter.com/codebasicshub ๐Ÿ“ธ Dhaval's Instagram: https://www.instagram.com/dhavalsays/ ๐Ÿ“ Dhaval's LinkedIn: https://www.linkedin.com/in/dhavalsays/ ๐Ÿ“ฑ Dhaval's X handle: https://x.com/dpcodebasics ๐Ÿ”— Patreon: https://www.patreon.com/codebasics?fan_landing=true

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

FAQs

Course Hive
Download CourseHive
Keep learning anywhere