Essential Math for Data Analysis using Excel Online
- Unit Outline
- Additional information
- Reviews (0)
About this course
Starting with the absolute basics of math and data, this course builds up your analyst skills while removing the mathematical hurdles and barriers that often come with beginning to learn how to analyze data. This course is intended for anyone with the desire to do data analysis and who would like to learn the math behind it all in a simplified way, as well as for anyone who would like a thorough refresher on the essentials.
Learn how to handle different data types, understand mathematical notation, become proficient in handling data sets and summary statistics, and even get a sneak peek into how to be effective at making stctistical inferences and predictions, all told in a way to maximize your understanding—so that afterward, you can be well on your way toward analyzing data in any field or discipline.
What you’ll learn
- Handle data sets for analysis purposes
- Understand beginning mathematical notation
- Work with different types of data
- Summarize data with distributions and graphs
- Apply summary statistics to analyze and understand data sets
- Calculate business metrics and KPIs to derive business value from data sets
- Apply basic inferential math to data
- Use tools to forecast future trends in data
Estimate Time : 18 hours
Module 1: Introduction to Data and Variables
Module 2: Summarizing Data with Distributions and Graphs
Module 3: Summary Statistics
Module 4: Business Statistics
Module 5: Introduction to Inferential Math and Forecasting
Sr. Content Developer at Microsoft
Ben is a Sr. Content Developer for Microsoft’s Learning and Readiness team, and is an analytics professional and educator with over 8 years of industry and managerial experience. Prior to joining Microsoft, Ben ran and directed multiple consulting firms, where he also held critical analytics roles in companies as diverse as Juniper Networks, Costco, and T-Mobile. He has taught Data Visualization at The University of Washington, and recently founded Seattle Pacific University’s Analytics Certificate Program.
Dr Tom Carpenter
Data Science and Research Consultant
Tom Carpenter is a freelance data science and research consultant and owner of Tom Carpenter PhD Consulting. Tom has a PhD in Social Psychology from Baylor University (doctoral minor in statistics). Tom has worked for several years as a freelance research consultant and statistician with several companies and research organizations, and he also teaches research and statistics. Tom’s passion is helping people hear the story in their data and to draw sound statistical inferences from that data.
|Author / Publisher
When you enrolled into this course you will automatically get a Certificate of Participation for completing the course. An example is provided below.
Only logged in customers who have purchased this product may leave a review.