Essential Mathematics for Data Analysis in Microsoft Excel
- Offered byFutureLearn
Essential Mathematics for Data Analysis in Microsoft Excel at FutureLearn Overview
Essential Mathematics for Data Analysis in Microsoft Excel
at FutureLearn
Duration | 3 weeks |
Total fee | ₹900 |
Mode of learning | Online |
Credential | Certificate |
Essential Mathematics for Data Analysis in Microsoft Excel at FutureLearn Highlights
Essential Mathematics for Data Analysis in Microsoft Excel
at FutureLearn
- Duration 3 weeks
- Weekly study 5 hours
- Included in an ExpertTrack Course 4 of 4
Essential Mathematics for Data Analysis in Microsoft Excel at FutureLearn Course details
Essential Mathematics for Data Analysis in Microsoft Excel
at FutureLearn
Skills you will learn
More about this course
- Data analysis is inextricably linked with maths. While statistics are the most important mathematical element, it also requires a good understanding of different formulas and mathematical inference.
- This course is designed to build up your understanding of the essential maths required for data analytics. It's been designed for anybody who would like to refresh their math knowledge or learn it in a simplified way before embarking on further data analytics training.
- Explore summary statistics and learn how to make statistical predictions so that you can analyze data across any field or discipline. You'll discover how to apply statistical methods to your data, and will practice the formula required to do that so that you can analyze and understand your data sets.
- Mathematical notations include numbers, variables, delimiters, functions, relational symbols, and operator symbols. You'll learn basic notation and expressions, and find out how they are applied to Excel formulas to complete simple calculations.
- Once you have a good understanding of the math behind it, you'll move onto forecasting future trends using your data. You'll apply inferential math to your data sets and calculate business metrics and KPIs to turn your new knowledge into genuine business value.
Essential Mathematics for Data Analysis in Microsoft Excel at FutureLearn Curriculum
Essential Mathematics for Data Analysis in Microsoft Excel
at FutureLearn
Introduction to Working with Data
About this Course
Introduction to Data and Variables
Types of Data
Notation
Means and Deviations
Weekly Wrap Up
Summarising and Graphically Representing Data
Summarising Data with Distributions and Graphs
Bar Graphs and Pie Charts
Mode, Mean and Median
SD vs IQR
Proportions
Weekly Wrap Up
Business Statistics and KPI's
Business Statistics
Business KPIs
Introduction to Inferential Math and Forecasting
Course Wrap Up
Other courses offered by FutureLearn
₹1.81 K
2 weeks
– / –
₹89.23 K
12 weeks
– / –
View Other 1956 Courses
Essential Mathematics for Data Analysis in Microsoft Excel
at FutureLearn
Student Forum
Anything you would want to ask experts?